your values seems to be strings, maybe try without the quotes to have integer so it can compare with integer in the query ? (or make both into string if that’s what you meant to do)
Hi @Prosolution - if you are using the same field like test_1 multiple times in the same file, the values will be added to it in a list. So it will never just equal one value. You can check if the list contains one value with WHERE contains(test_1, "100").
In general, the best way to troubleshoot issues with WHERE is to remove the WHERE and see how the field shows up in your table! Does its appearance in the table match how you planned to filter it?
In your case, I would expect to see lists in each cell for test_1 and test_2 for any file where you set them multiple times. Note that if you sometimes set them only once, then my contains suggestion will not work there but = "100" should. Mixed up data types are complicated!