MIGX: &where filter addressing MIGX_formname?

How can i use &where filtering in my getImageList call to output only results for forms whose MIGX_formname start with a certain word?

This here doesn’t work:

You can’t use normal SQL filtering, because here you are filtering the items of a JSON array and not rows in a database.

Take a look at the function filterItems to see what options are available:

It probably works if you use contains.

Another option is to create a custom snippet (based on the getImageList snippet) where you code the filtering yourself based on your exact needs.

1 Like

Thanks @halftrainedharrycontains works:


This topic was automatically closed 2 days after discussion ended and a solution was marked. New replies are no longer allowed. You can open a new topic by clicking the link icon below the original post or solution and selecting “+ New Topic”.