Data Store - Wich Record - Using "OR" or "AND"

Feature Request
#1

Hello Everyone,

In the current implementation of Update, Upsert and Delete for Data Stores, the “Wich Record” clause only uses the operator “OR”, would be great to have the “AND” operator as well.

#2

You can make an AND work now…

If you have field1 with value f1 and field2 with value f2, create a field1_field2 with value f1_f2 and test for that…

I do it in many places in my app and it always works perfectly!

1 Like
#3

Stumbled upon this issue today.
I don’t know the reasoning behind it, but I expected AND and it feels more suitable here.
After reading the discussion here, I know that I’m not the only one.

Meanwhile, I have to go with a workaround that Antony suggested.

#4