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]

Add SearchView to a panel and then hide or show the panel by changing its Visible property.

 

[achtrade]

How can this SearchView be filled with data from a SQLite database ?

a piece of code should be highly thankful

 

[Erel]

You need to create a list with the items you want to show in SearchView.

For example:

Dim items As List
items.Initialize
For Each row() As String In DBUtils.ExecuteMemoryTable(SQL, "SELECT name FROM table1", Null, 0)
 items.Add(row(0))
Next
sv.SetItems(items)

 

[achtrade]

You need to create a list with the items you want to show in SearchView.

For example:

Dim items As List
items.Initialize
For Each row() As String In DBUtils.ExecuteMemoryTable(SQL, "SELECT name FROM table1", Null, 0)
items.Add(row(0))
Next
sv.SetItems(items)

Thanks Erel, that worked. But I post the question in the wrong threat, I wanted to asked it here:

https://www.b4x.com/android/forum/t...e-list-with-searchview-b4xserializator.61872/

can I ask again in that threat ?

 

[Erel]

can I ask again in that threat ?

It is always better to start a new thread in the questions forum over posting in the 10th page of an existing thread.

 

[achtrade]

I have a second EditText below the first one, when I start to type in the first ET and the list shows up, I can't select the item in front the second ET, instead, the second ET got the focus without select any item from the first list.

How can I fix this ?

 

[Erel]

Are you calling SearchView.AddToParent after the second EditText is added?

 

[achtrade]

Are you calling SearchView.AddToParent after the second EditText is added?

This is my code:

Sub Activity_Create(FirstTime As Boolean)
    lblCustomer.Initialize("")
    lblCustomer.Text = "Customer"
    lblProd.Initialize("")
    lblProd.Text = "Product"

    Panel1.AddView (lblCustomer, 5%x, 5%y, 200dip, 300dip)

   'first searchview
    sv.Initialize(Me, "sv")
    sv.et.Hint="search customers"
    sv.AddToParent(Panel1, lblCustomer.Width, 5%y, 300dip, 300dip)

  'second searchview
    Panel1.AddView (lblProd, 5%x, 15%y, 200dip, 300dip)
    sv2.Initialize(Me, "sv2")
    sv2.et.Hint="search products"
    sv2.AddToParent(Panel1, lblCustomer.Width, 15%y, 300dip, 300dip)
end sub

that's all

 

[achtrade]

this is how the screen looks

 

[Erel]

Try to add sv2 before you add sv.

 

[achtrade]

Try to add sv2 before you add sv.

This worked, but I still can see the second ET, how can I add a white background when the list is showed ?

 

[Erel]

You can change the ListView color with (Initialize sub code):

lv.Color = Colors.Red

 

[jayel]

Erel,

I am strungling with the searchview, as is, it works, but I have to return the index of th choosen item from the original list, so I can look in another list of maps to return the id.
How can I do that?

greets

John

 

[Erel]

Erel,

1. Please don't limit your questions to a single member.
2. Please start a new thread for this question.

 

[Erel]

New version was uploaded to the first post. SearchView is now implemented as a custom view and should be added with the designer.
There is also a new ActivityHeightChanged method that should be used together with the IME library to handle the activity height changing when the keyboard appears.

 

[Erel]

New version was uploaded. It uses CSBuilder to highlight the search term:

It requires B4A v6.8+

 

[LucaMs]

You could add this code, to be able to use this view also on a smartphone in landscape mode (little space for the Listview, but it is better than nothing. I just created a similar Custom View, without ListView; I have yet to test it well and it has a small inconvenience of use for which I'll ask you a suggestion, though I think there's not an ideal solution).

 

[Peter Lewis]

HI All, I am finding that once I have used the selection and passed the values to another Activity ( After the other activity the workflow goes back to the main activity) , The selected value appears the next time I go back into that Activity. Is there anyway of clearing that , and when should I clear it.

I put message boxes all over to see where the flow goes and it comes back to Activity Resume, If I use the back key and use SearchView again , it goes back to Activity Create and then it is cleared.

Any ideas would be useful. Thank you

 

[Erel]

Please don't make duplicate posts: https://www.b4x.com/android/forum/threads/searchview-clearing-the-selected-value.77975/

Note that you should use Log instead of Msgbox.

 

[achtrade]

I have a CLV and a SearchView inside a panel, when I'm typing in the edittext the result of the searchview is behind the CLV, I can't see it. How to bring the result of the searchview in front the CLV ?