Is it possible to "Sort on" more than 1 field in a DataView?

Wappler General
1

Capture

Is it possible to sort my Data View on more than 1 field?

e.g. I want to sort my data

  1. Sort by xx_db_field … then
  2. Sort by yy_db_field

If so how?

Thanks anyone who can help.

2

Hi, can you explain the logic of what are you trying to achieve?

3

I have a list of items that need to be ordered in a filtered DataView component

  1. Order by Scheduled start
  2. Order by Priority

I can acheieve this in an SQL query as such, (but in this case I am using a DataView so cannot)
SELECT column1, column2,…
FROM tbl
ORDER BY column1 [ASC|DESC], column2 [ASC|DESC],…

4

So do you want to have sorting buttons, which allow you to sort on different columns? I am still not sure i understand what do you want to achieve.

5

This data view lists exactly what I need except in the wrong order. I want to list 1st of all by “jw_sched_start” then followed by “priority” but it appears I can only add one field to the “sorton”

dmx-data-view id=“data_view_urgent” dmx-bind:data=“sc_w.data.qrySeiki” pagesize=“20” filter="(urgent !=1 && priority ==1) && (jw_op_status ==0)" sorton=“jw_sched_start” sortdir=“asc”></dmx-data-view

6

Why don’t you just sort this in the query builder then?

Screenshot_21
Screenshot_21.jpg1117×672 82.9 KB

Data view will show the data as sorted in the query builder.

7

Yes this would work normally but this is a very complex page. So it’s not possible to order the data view by more than 1 column?

8

No, that’s why im suggesting to do this on the server side.

9

What happens if you do the first sort on the current DataView and do the second sort a second DataView with the first DataView as the source.

This is only a theory, have not tried it and is only meant as a work-around.

1 Like
10

Thanks @ben … I will try…I didn’t think of using the original data view as the source of another data view… The limits are really endless with wappler!