Queryfilter parameters

Richard over 7 years ago

Given the following:

a!checkBoxField(label: "whatever",choiceLabels: {"banana","apple","strawberry"}, choiceValues: {"banana","apple","strawberry"}, value: split(local!choice,";"),saveInto(local!choice,joinarray(save!value,";")))

can I ....

a!query(
blah
blah
...
filters: { a!queryFilter(field: "fruits", operator: "includes", value: split(local!choice,";"))}
)

or would this work?
a!query(
blah
...
blah
....
filters: {
apply(
a!queryFilter(
field: "fruits",
operator: "includes",
value: _
), split(local!choice,";")
)

}
)

Discussion posts and replies are publicly visible

Parents

0 Richard over 7 years ago

Ah, re-read the documentation on touniformstring(), but the problem is that the database field "fruit" is a condensed string with a ';' delimiter, so the fact that local!choices isn't an array is less of a problem than the fact that it should probably be treated as separate query filters.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Richard over 7 years ago

Ah, re-read the documentation on touniformstring(), but the problem is that the database field "fruit" is a condensed string with a ';' delimiter, so the fact that local!choices isn't an array is less of a problem than the fact that it should probably be treated as separate query filters.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data