Order list ascending

[xinote (Ruben)]

Hi

i have these blocks:

there are lists the get data from sql, but i want order the results by the column “ESTANTERIA”

i used the extensions LISTADDON & LIST UTILS but the problem is the same, the result are ordered only by “Estanteria” and change the other values,.

Not match from sql to app

i need to order by “estanteria” & “pulmon” & “alveolo”

somebody can help me?

[xinote (Ruben)]

temporarily i add into the Sql the colum “ESTANTERIA” to Primary and this WORK IT fine¡¡

but i would like have how primary column the “ID”, if is possible.

Thanks

[Rogerio_Rios (Professional Support)]

Select referencia,cuatindad,hora,estanteria,pulmon,alveolo FROM yourtable Order by estanteria,pulmon,alveolo
And Return primary Key to ID

[xinote (Ruben)]

Thanks but the problem is in the get data system.

I used the deephost extensión, and i have tryed to use the run sql but i cant get nothing…

[Rogerio_Rios (Professional Support)]

Friend, you are asking to put the list in order. This command above is the way to return ordered data. It is the solution to get the data in order as you requested. This extension is not recommended here in the community.
Exchange for : App Inventor Tutorials and Examples: MySQL | Pura Vida Apps
Or This
MySQLi. PHP. GET. POST. Insert. Update. Delete. Segur SQL Inject

[Rogerio_Rios (Professional Support)]

@xinote

is in the get data system

To get data: Select SQL command.

[xinote (Ruben)]

How?
I used run sql, wrote the code, and after i used the on sucess…
I dont know if you if you know This extension

[Rogerio_Rios (Professional Support)]

@xinote

need to order by “estanteria” & “pulmon” & “alveolo”

I already posted the solution. Hugs