Another Multiple Choice (Dynamic) question
How can the list of choices be filtered?
Sorting the list is straightforward, but I cannot figure a way to filter them.
By which I mean e.g.
select choices where Id > 2
The idea is that the list of choices would be limited to those records in the 'choices' table whose Id value is greater than 2. But although no code error is shown, it doesn't work. That MC(D) field is just displayed as empty everywhere. So that use of 'select' and 'where' filter fails and no list is produced.
I also tried:-
(select choices)[Id >2]
which similarly fails.
There are some rows in that 'choices' table that I don't want to be shown when used for an MC(D) field and it would be handy to be able to exclude rows as required. Anyone any idea how to filter the values?