Data Store Insert Problems - Two Where Parameters Acting as OR Rather Than AND

Wappler General
1

I have a data store responses into which I am inserting a value like this:

responses.update({question: id, attendee_number: this_attendee_number.value},{response: i_question_type_s.value})

My expectation is that this will insert into the data store where question=id AND attendee_number=this_attendee_number.value

However it is inserting into the datastore where question=id OR attendee_number=this_attendee_number.value

Do I understand this incorrectly?

If so, how can the insert find the record using the AND rather than OR of the two where parameters?

3

At the moment the filtering uses OR, will see if maybe we could also allow AND.

4

Okay… I’ll create an extra field that is the two fields combined then and insert based on that for now.