Android Question How do we search within search results?

[epiCode]

I am using b4xtable to search across multiple columns:

I wish to narrow down search results by allowing to search within the results.

1. Is it possible with B4XTable?
2. If not, how else can it be done? It would be nice if anyone can share how they achieved it.

Thanks!

PS: This is not the case of simple SQL AND / OR or using % with LIKE. because the two terms may not be in the same column/row

 

[Erel]

B4XTable search is based on SQL LIKE feature. It simply ORs all searchable columns.

You can implement the first search using CreateDataView:

B4XTable1.CreateDataView($"${NameColumn.SQLID} LIKE '%F%' OR ${StateColumn.SQLID} LIKE '%F%'"$)

 

[epiCode]

B4XTable search is based on SQL LIKE feature. It simply ORs all searchable columns.

You can implement the first search using CreateDataView:

B4XTable1.CreateDataView($"${NameColumn.SQLID} LIKE '%F%' OR ${StateColumn.SQLID} LIKE '%F%'"$)

This is exactly what I was looking for. Thanks Erel !