B4A Library [Class] SearchView - More powerful alternative to AutoCompleteEditText

Edit: better to use B4XDialog + B4XSearchTemplate

SearchView is made of an EditText and ListView. When the user enters text into the EditText the ListView shows the items that start with this text or that contain the text (in this order).

This view is useful for allowing the user to select an item from many items.

Advantages over AutoCompleteEditText:

• SearchView uses an internal index that is built when you call SetItems. This allows it to quickly find the matches.
• SearchView also shows items that contain the input text (not just prefixes).
• The class code can be further customized as needed.

Tutorial about handling large, searchable lists: https://www.b4x.com/android/forum/t...e-list-with-searchview-b4xserializator.61872/

 

[Erel]

You can add SearchView to any Panel you like. Including a panel that belongs to a TabHost tab.

 

[incendio]

Dear Erel,

I have tried this class with about 18500 records, crashed during built an index.
I built my self almost similar function to searchview, not a class, since my skill is not enough.

Function built using sqlite data(in internal sdcard) and its index feature. Very-very fast, 18500 records shows almost instantly, though only capable to search first letters only (ab->display all data start with ab, etc).

 

[Mahares]

@incendio: Can you zip and post your project so we can see how you can achieve that speed. Who knows, perhaps someone can help you change it where you can search by a string anywhere in the column, not just the start. SQLite has that capability.

 

[LucaMs]

Dear Erel,

I have tried this class with about 18500 records, crashed during built an index.
I built my self almost similar function to searchview, not a class, since my skill is not enough.

Function built using sqlite data(in internal sdcard) and its index feature. Very-very fast, 18500 records shows almost instantly, though only capable to search first letters only (ab->display all data start with ab, etc).

You could try my ComboSearch.
It saves the data in a SQLite database (indexed).
But it has two fields: the first contains the words to search, the second an object that will be returned along with the word; this object can also be null.
You can fill the list from a db, but it does not have a progressbar.
I did a test with 18500 records: a long time to load, only a moment to look for.

 

[LucaMs]

Uhm...

You probably do not have the necessity of the second field.

But the main problem is the duplication of data: to fill the internal db you must also put the db containing the data in the project.

This feature that I added seems to be useless

 

[incendio]

@incendio: Can you zip and post your project so we can see how you can achieve that speed. Who knows, perhaps someone can help you change it where you can search by a string anywhere in the column, not just the start. SQLite has that capability.

Yes, I can search anywhere in the column, but don't need it, so, not included in my function.

I have tested to include search anywhere in the column, speed is slower than only search first letters, but still very fast and acceptable. For a small data, I think, won't be any different.

Function is very simple but the sample data is large, +/- 2.5MB, so I stripped down sample data in order to post here.

 

[LucaMs]

You only have the ability to find words that start with a certain letter capitalized.

With this line:
DB.ExecNonQuery ("PRAGMA case_sensitive_like = OFF") [or ON]

you can solve at least the upper/lower case.

 

[incendio]

You only have the ability to find words that start with a certain letter capitalized.

With this line:
DB.ExecNonQuery ("PRAGMA case_sensitive_like = OFF") [or ON]

you can solve at least the upper/lower case.

Thanks for the tip, but I need my data to be capitalized.

 

[Mahares]

@incendio: Your project only has 96 records. That does not make for a good test. Having all 18500 records would have made for a good test. For your info, edt.text would still work. You did not have to change it to edt.text.ToUppercase in your select statement. Also , sometimes when you are running a query, the fewer columns requested in the SQL statement, the faster the query runs. In your case SELECT nm is faster than SELECT nm,id because you did not need the id.

 

[incendio]

Yes, it is only 96 records, cause this is just a sample, to big to post the whole records to this forum.

The sample project is just to give an idea how to deal with large data and i have tested with 18500 records.

 

[hzchrisfang]

Hello Erel,
How would I add the searchview to a customdialog? I have a try, but the itemclick event not work.

 

[Erel]

Use a non-modal dialog instead. Just show a Panel in front of all other views.

 

[Shay]

Hi
Strange thing, the "ProgressDialog"
is not shown in nexsus 4
is it ok on galaxy s2, s3..
any idea why? / how do I overcome this?

 

[Erel]

Try to add more calls to DoEvents.

 

[Shay]

you mean add more on this line? (change 100 to 200?)
If i Mod100 = 0ThenDoEvents

 

[Erel]

Change to 10.

 

[tcgoh]

Moving the code to a service will not help. Services code run in the same thread as any other code.

If the data is static then you can store the index in a file and then load it instead of building it.

Hi,

How do you store the index into a file?
Sorry I'm new on searchiew and I have a large txt file which takes a long time building it upon starting the APP.

Thanks

 

[Erel]

You can use KeyValueStore or RandomAccessFile.WriteObject / ReadObject.

 

[tcgoh]

Sorry I'm not familiar with RandomAccessfile. I use this code but its not working

Dim raf As RandomAccessFile
    raf.Initialize(File.DirRootExternal, "test.txt", False)
    raf.WriteObject(index, True, 0)
    newObj = raf.ReadObject(0)
    raf.Close
    Return newObj
   
    sv.SetIndex(newObj)

Thanks for helping

 

[Erel]

Your code looks correct (assuming that you only use it to test this functionality). Which error do you get?