Showing results for 
Search instead for 
Did you mean: 
Community Champion
Community Champion

DB2 CONNECTOR: Filter and Select Query Examples?


I have a Flow that writes data to DB2 tables. After a write is successful, I want to send out a report that shows ONLY the new records written to the database. 


I have a variable called varObjectIDs that is set earlier in the Flow. Its a string variable that looks like: "1,2,3" etc. and holds the ID's of the new tables.


Question is: 

  • How do I use varObjectIDs to select only the new records in a DB2 Get Rows action? 

I think the answer lies with the "Filter Query" or "Select Query" paramenters but I don't understand them enough to use them. 



I tried putting OBJECTID eq varObjectIDs in the Filter Query, but Flow didn't accept that.

Any other ideas?

Thank you!

Dual Super User
Dual Super User

Hi @ericonline 


I am no DB2 expert but if your variable contains the ids in string format

OBJECTID eq varObjectIDs will not work


you might have to loop through each varObjectIDs and test the query and check if record exists


one option would be to hardcode the id and check first if it works

example : OBJECTID eq '1' 

or OBJECTID eq 1


based on response you can set your query accordingly



Reza Dorrani


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly


Community Support
Community Support

Hi @ericonline,


If you use Filter array, you need to put the current item into the left or right blank, and the other side you need to put the value you want find.Annotation 2019-08-13 112236.png

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (2,993)