AnsweredAssumed Answered

Retrieve Multi-valued select answers in NSQL and Filter on those answers

Question asked by C_T on Oct 8, 2010
Latest reply on Oct 13, 2010 by Dave

I'm creating a custom portlet and am looking for a way to retrieve the data from our multi-valued select fields so that we can filter on those fields using a lookup? I am able to flatten the multi-valued field to display all the selected options in a string, but it doesn't make it easy to filter on that field (you can only enter text to search rather than use a lookup to select the desired values). Ideally, I'd like to be able to retrieve the answers for the multi-valued field (via my NSQL query) and be able to tie that field to a lookup to make it easier to filter.

- The animals field's possible answers are dog, cat, bear, fish, rabbit.
- I want to be able to filter on the animals field to find out how many records selected dog and bear.

Has anyone done this before? I know I'm asking for a lot, but those are the requirements from our users. Any pointers would be much appreciated!