Android Question How do we search within search results?

epiCode · Nov 12, 2021

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 · Nov 12, 2021

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

You can implement the first search using CreateDataView:

B4X:

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

epiCode · Nov 12, 2021

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

You can implement the first search using CreateDataView:

B4X:

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

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

Android Question How do we search within search results?

epiCode

Active Member

Erel

B4X founder

epiCode

Active Member

Similar Threads

Android Question How do we search within search results?

epiCode

Active Member

Erel

B4X founder

epiCode

Active Member

Similar Threads

Privacy & Transparency

Privacy & Transparency