Dataview filtering multiple WHERE

Hello

I am having to filter a Dataview using the Datasource and adding a Where statement followed by a Group By. I managed to add a second Where but i want a third OR Where.

I can do this using Filtering and || but i need it followed by a Group By so i have to use the datasource.

serverconnect_results.data.results.where(o_occupation, input2.value, “contains”.default("%")).where(m_firstname.lowercase(), input1.value.lowercase(), “contains”.default("%")).groupBy(member_id)

Need to add a fuzzy search for m_lastname . so it finds occupation AND (firstname OR lastname)

Is there a perfromance loss by filtering the datasource instead of the dataview filtering field?

Community Page
Last updated: