5 replies

How to filter based on a field while also using search index?

How can I narrow a table on a certain field and then also search based on a field?

For example, say I have a

registrations

registrations

registrations

registrations table where each one will belong to a different

organization

organization

organization

organization and each has

name

name

. How can I effectively query based on an index for

organization

organization

organization

organization and then also filter them based on a search parameter for

name

name

? It doesn't appear we can use an index and a searchIndex at the same time.

I've considered just doing a regular index on

organization

organization

organization

organization and then doing a filter on

name

name

, but I might have to do some sort of fuzzy lookup manually. I also thought of using a search index on the

name

name

field and then filtering on the

organization

organization

organization

organization. I'm not sure what pattern to adopt here.

Any advice on how to structure this effectively? I'm going to try and call

paginate

paginate

paginate

paginate on the resulting list and showing these results in a table .

Thank you.