B4J Question Search field on a Tableview

[Peter Lewis]

Hi All

I am looking for a way to be able to search my SQLite data and display the results in a Tableview.

I am from a Clarion Background and we had the option to place a box next to the table and as we started typing in what we were looking for it would automatically filter out records depending on what was typed in, even if it was not complete.

Does B4J have something like this ?

I have searched around the Forums but could not find anything, maybe my search wording was wrong.

Thank you

Peter

 

[Erel]

There are all kinds of ways to implement it.

I would have started with the direct approach. Handle the TextChanged event. Check if the text length is larger than 2 or 3 and create a SQL query with LIKE to filter based on the prefix.

Example is attached.

The source for the CSV file with the data: http://blog.plsoucy.com/2012/04/iso-3166-country-code-list-csv-sql/

 

[Erel]

If you want it to match all occurrences instead of prefix only then change the filter value to: "%" & New & "%"

 

[Peter Lewis]

If you want it to match all occurrences instead of prefix only then change the filter value to: "%" & New & "%"

Thank you Erel. You are the Master !!!

 

[Erel]

And a modified version that highlights the matches:

It uses TextFlow (included in the example): https://www.b4x.com/android/forum/threads/61237/#content

 

[Peter Lewis]

There are all kinds of ways to implement it.

I would have started with the direct approach. Handle the TextChanged event. Check if the text length is larger than 2 or 3 and create a SQL query with LIKE to filter based on the prefix.

Example is attached.

The source for the CSV file with the data: http://blog.plsoucy.com/2012/04/iso-3166-country-code-list-csv-sql/

I updated and tested with one of my tables and it works exactly how I wanted it to, I am surprised I did not find it searching the forums. How should I have searched for it ? I have having to ask questions all the time.


There was only one issue with this and if I put the following lines of code as you suggested, then the Tableview problem I had earlier by not displaying the correct headers and column widths does not work. So I took these 2 lines and and it worked again.

Are these lines Important ?

'    SearchField_TextChanged("", "")
'    SearchField.RequestFocus

Thank You

 

[inakigarm]

The first line calls the SearchField (textfield view) Textchanged Event with params "" to fill the tableview with all the records from DB

If New = "" Then
        DBUtils.ExecuteTableView(sql, "SELECT name, code FROM countries", Null, 100, tableview1)

The second calls the focus on Searchfield (textfield) view.

Maybe if you introduce a delay before calling this lines (with Callsubdelayed or the new sleep function) the tableview1 redraws correctly (difficult without seeing the code)

 

[Peter Lewis]

The first line calls the SearchField (textfield view) Textchanged Event with params "" to fill the tableview with all the records from DB

If New = "" Then
        DBUtils.ExecuteTableView(sql, "SELECT name, code FROM countries", Null, 100, tableview1)

The second calls the focus on Searchfield (textfield) view.

Maybe if you introduce a delay before calling this lines (with Callsubdelayed or the new sleep function) the tableview1 redraws correctly (difficult without seeing the code)

I found out how to solve it. Initially I had to move all the code that relates to the table ie names and widths to after the DBUTILS commands. Not that DBUTILS command are inside another sub , I have to do it there as well and it works.

Thank you for responding

 

[Erel]

I am surprised I did not find it searching the forums. How should I have searched for it ?

It was only created today.
It now returns as the second search result: https://www.b4x.com/android/forum/pages/results/?query=tableview+search+b4j