Ability to Merge Arrays on Client Side

[Antony]

This is a request for the following capability:

On the client side, to be able to create a sub array of my_array where field1==1 OR field2==1 , specifically on data taken from the Data Store.

So if I have in a Data Store:

Name field1 field2
==================
Fred    1     1
John    1     0
Jane    0     1
Mary    0     0

I want an array with Fred, John and Jane.

The .where(field1==1).where(field2==1) structure will only give me Fred.

It is the basis of some very complex search functions I need to carry out on my contacts Data Store.

This can be done when taking data from the database in a Server Action, but now we have the Data Store, we need to bring this capability into the client side to use directly for example on a repeat.

How Do I Merge Two Sub Arrays in a Repeat?

When creating sub-arrays, you can want them with an and or an or function. I can do the and function with multiple .where() conditions my_array.where(`field1`, 1, "==").where(`field2`, 1, "==") So now I want to do the or function - so basically to merge two arrays: my_array.where(`field1`, 1, "==") MERGED WITH my_array.where(`field2`, 1, "==") How do I do that? While this kind of thing can be done during database access, I need it for Data Store acce…