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?
I believe it is because an ID isn't a number, so the range criteria fails. Try wrapping ID in the number function as [number(Id)>2]. ID by itself can only be used with equality, like ID=3 or ID!=4.
Thanks. I'll try that.