I am filling a listview from a select to the Oracle database. This is the code.
%pre% What this result presents to me:
Now ... what I need is for it to look something like this:
}
}
It would be to group the orders with the same id.
The select to the database is a view that would be this:
%pre%Assuming that your query is ordered as you want, that is, the records are correct, what you should do would be something like this:
%pre%What we are doing here is comparing the order with the previous one. If the order is different, we put all the data we want in the list .. If not, we leave those columns blank, and only fill the others.
This way you will achieve what you need. Notice that if the orders are different, I change the current order. And I start the first one in 0.
This is commonly known as control cuts.