Hi!
I'm using the action SQL Get rows (v2) to get a list of users from a data base view. To get only active users I added the filter query "Status eq 1". I thought that it worked as it should until i noticed that 3 users (of ~2500) was missing. To test I skipped the filter inside the action but added an array filter action with "@equals(item()?['Status'], 1)". Now I got all the users but strangely I got the exact same number of users in both scenarios. Further investigation showed that I had a couple of duplicates in the scenario with the filter inside "Get Rows" instead of my missing users. Can any one explain this behavior?