Search expression: a list as constraint?

[ohyoonkwn]

Hello, I wish everyone has a happy 2021!

Try to make a last push in 2020 and it seems I need some help…

I’m building up a search function for a repeating group that calls a list of ‘Answers’. The Answer table has a data type called ‘Ask’. The tables look like this:

Here are two scenarios that I faced that the search constraints data type mismatch.

1. Search Answers that contain Asks created by the current user.

2. Search Answers that contain Asks which were Answered by the current user.

Regarding 1) I tried to use Search for operation in a search for Answers. But the second search result returns a list of Ask data whereas the data type is Ask.

Regarding 2) I have no clue where to start…

Would be great to hear from you!

Thanks!
Ohyoon

[boston85719]

@ohyoonkwn

1. I tried to use Search for operation in a search for Answers. But the second search result returns a list of Ask data whereas the data type is Ask.

Yes, when the data type is Ask, it will return a list of Ask data

You might need to do an advanced filter…using a list of things to filter and constrain a list usually requires an advanced filter.

You would set up the search and after the dynamic expression select ‘more’ to then add :filter operator…in this filter area you can choose an advanced filter

This will allow you to constrain by saying list contains list and then specify the list it should contain.