Android Question [Solved] Which View is the most convenient to select an Item from many?

[Sergio Castellari]

Situation:
I need to choose an item from a large list of options (coming from a MySql table)

a) Currently I use "ComboBox" with all the elements pre-loaded to select an Item. When they are few, it is the right view.
b) What view would be correct for cases where you want to select an Item from hundreds available?

Note: Looking at the B4XTable search I would like something similar with data taken from a MySQL table

 

[Jeffrey Cameron]

Have a look at: https://www.b4x.com/android/forum/t...ul-alternative-to-autocompleteedittext.19379/

 

[Mariano Ismael Castro]

[B4X] SQLSearchView - SQLite based Search View

This library is based on B4XSearchTemplate. The difference is that instead of building an in-memory index, it uses a SQLite database. It is relevant when you want to search large collections. I've tested it with a collection of almost 400k items. It starts immediately and the search is fast...

www.b4x.com

Situación:
Necesito elegir un elemento de una gran lista de opciones (proveniente de una tabla MySql)

a) Actualmente utilizo "ComboBox" con todos los elementos precargados para seleccionar un elemento. Cuando son pocos, es la vista correcta.
b) ¿Qué vista sería la correcta para los casos en los que desee seleccionar un artículo entre los cientos disponibles?

Nota: mirando la búsqueda de B4XTable, me gustaría algo similar con datos tomados de una tabla MySQL

 

[Erel]

SearchView was replaced with B4XDialog + B4XSearchTemplate. This is the best option.

SQLSearchView / Trie / some other options are useful for huge lists with 100k+ items.

 

[Sergio Castellari]

Thanks @Erel
Any example?
never use

 

[Mahares]

Any example?

What about Trie based search:

[B4X] Trie based search dialog

This started as an educational project but it can be useful in some cases. Trie is an interesting data structure that allows fast lookup of prefix matches. It is a tree of prefixes. Source: https://en.wikipedia.org/wiki/Trie In the B4X implementation, each node holds a character, a list of...

www.b4x.com

It has a full example.
If you stick with B4XSearch, there is an example here:

[B4X] XUI Views - Cross platform views and dialogs

XUI Views is a b4x library (https://www.b4x.com/android/forum/threads/100383/#content). The same b4xlib library is compatible with B4A, B4i and B4J It is a collection of custom views and dialogs. Everything is written in B4X. The source code is included inside the b4xlib file, which is a zip...

www.b4x.com

If you get stuck with your project when you try one or the other, post your project and you will get help.

​

 

[Mariano Ismael Castro]

Thanks @Erel
Any example?
never use

 

[Sergio Castellari]

What about Trie based search:

[B4X] Trie based search dialog

This started as an educational project but it can be useful in some cases. Trie is an interesting data structure that allows fast lookup of prefix matches. It is a tree of prefixes. Source: https://en.wikipedia.org/wiki/Trie In the B4X implementation, each node holds a character, a list of...

www.b4x.com

It has a full example.
If you stick with B4XSearch, there is an example here:

[B4X] XUI Views - Cross platform views and dialogs

XUI Views is a b4x library (https://www.b4x.com/android/forum/threads/100383/#content). The same b4xlib library is compatible with B4A, B4i and B4J It is a collection of custom views and dialogs. Everything is written in B4X. The source code is included inside the b4xlib file, which is a zip...

www.b4x.com

If you get stuck with your project when you try one or the other, post your project and you will get help.

​

@Mahares
Thank you!!!!
I followed the SearchTemplate example and got it to work.
A small example of @Mariano Ismael Castro

Thanks to both of you!

Now I have new needs:
a) Can the list of search items be adjusted to the Left? Currently they are focused and I did not find any property for it.
b) Can the font size be adjusted? I wish a smaller font.

Big hug!!!

 

[Mahares]

Now I have new needs:
a) Can the list of search items be adjusted to the Left? Currently they are focused and I did not find any property for it.
b) Can the font size be adjusted? I wish a smaller font.

Dim lbl As B4XView= SearchTemplate.CustomListView1.DesignerLabel
    Dim f As B4XFont= XUI.CreateFont(Typeface.CreateNew(Typeface.SERIF, Typeface.STYLE_BOLD), 24)  'change the size as you wish smaller or bigger
    lbl.Font =f
    lbl.SetTextAlignment("CENTER", "LEFT")

No hugs Sergio. Covid is tarnishing the entire world of us

 

[Sergio Castellari]

Dim lbl As B4XView= SearchTemplate.CustomListView1.DesignerLabel
    Dim f As B4XFont= XUI.CreateFont(Typeface.CreateNew(Typeface.SERIF, Typeface.STYLE_BOLD), 24)  'change the size as you wish smaller or bigger
    lbl.Font =f
    lbl.SetTextAlignment("CENTER", "LEFT")

No hugs Sergio. Covid is tarnishing the entire world of us

@Mahares
you are a genious!!!!
It worked PERFECT! ... goal accomplished!
I was unaware of these configuration possibilities ... (and I am still unaware ...)
A million thanks!
A big VIRTUAL hug
Have a nice weekend!

 

[Mahares]

you are a genious!!!!
It worked PERFECT! ... goal accomplished!

Thank you so much Sergio for the compliments. I am not a genius at all. Erel and a few others here are. I struggle through it like everyone else. Have a great weekend.

 

[Sergio Castellari]

Maybe it's an abuse (but it's related to my original post):
Is there a way to create a public "SearchTemplate", that is to say that you create it for example in the "Main" or "B4XMainPage" and can invoke it from any B4Xpage?

Greetings