Sorting for a View Element
I have a relation field with multiple records in it and I display it via a view element. Now I want to have some dynamic sorting by name, or by a number, but with the sorting I dont have some luck. Here is the code without the sorting and prepared for it.
let ActiveRecords := (select 'Line-up' where Zeitaufzeichnung.'Aufzeichnungen Meldung' like "recordings");
let ActiveRecordsbyName := ActiveRecords.Name;
let ActiveRecordsbyAmount := ActiveRecords.'Erarbeiteter Wert';
let AZ := ActiveRecords;
let ZA := ActiveRecords;
let Amount_UP := ActiveRecords;
let Amount_DOWN := ActiveRecords;
let WorkingInIt := ActiveRecords;
switch 'Sortierung Produktion' do
case 1:
AZ
case 2:
ZA
case 3:
Amount_UP
case 4:
Amount_DOWN
default:
WorkingInIt
end
27 replies
-
Hi
I am fairly certain that the sort order is defined in the view (where you say which columns to show and you are able to sort one of them ascending or descending, not in the script that creates it.
Regards John
-
I was thinking maybe its possible to make the sorting also dynamic, like you see here on the screenshot, how I intended it to get working.
otherwise, I need to create 4 different views to have this sorting I need. But it's much more effort to get it done, than coding it.
-
-
If it were me, I'd go with creating 4 views. You have done so much prep work anyway.
-
Of course, good luck!
-
Jacques has some good tips on ordering.
So you could do something like:
let ActiveRecords := (select 'Line-up' where Zeitaufzeichnung.'Aufzeichnungen Meldung' like "recordings"); switch 'Sortierung Produktion' do case 1: ActiveRecords order by upper(Name) case 2: you will have to decide if you want to implement the global function case 3: ActiveRecords order by 'Erarbeiteter Wert' case 4: ActiveRecords order by -'Erarbeiteter Wert' default: ActiveRecords end -
On the other hand, you could still use Fred's method if you replace the view with an HTML table in a formula field. Which is in my opinion much nicer than a regular view element...
-
I included an example database based on the Contacts template. If you look in the dashboard, you'll see the html-table.
I also find it strange I cannot sort using the switch function so I had to use the if then loop... (see attachment) maybe you have any ideas?
A click on the Contacts picture opens the record
-
This worked for me:
let list := switch n do case 1: (me order by firstname) case 2: (me order by lastname) case 3: (me order by company) case 4: (me order by website) case 5: (me order by category) default: me end;See the video.
-
Aha, this is of course a lot neater! thanks !
I hadn't used the parentheses
-
Thank you very much, I will have a detailed look at it. :-)
-
Hi Steven, What's happening if the Sorting Order Field is other, example Category a Chose Field in Contacts
-
let list := switch n do
case 1:
(me order by category = "Family")
case 2:
(me order by category = "Business")
case 3:
(me order by stage = "Private")
case 4:
(me order by stage = "Other")
default:
me
end;
This work, The problem is order in desc mode
-
For me it's not sorting the View Element. Does it work now or not?
-
Did you replace the View code with the one I posted?
-
yes this one:
-
Sorry, mis read your post. is correct that you can't pre-sort views. If you see that my "working code" was for 's HTML table.
-
Content aside
- 9 hrs agoLast active
- 27Replies
- 81Views
-
5
Following