Sort a dMC field dynamic values
I've tried adding Sort() to the select station and also the Dynamic Value field and neither seems to work. Anyone know if this is possible?
7 replies
-
It is possible. Please share your code so we can troubleshoot.
-
I am doing a simple Select for the Dynamic Table and a single field in the dynamic values called Checklist Items contains the text values.
dMV Table
select Checklists
dMC Values section
sort(‘Checklist Items’)
-
What you are asking it to do is to sort by record Id, which is the default sort so you wouldn’t see any changes.
What you can try is the order by command:
select Checklist order by fieldname
Ninox has more info on their docs site. I have to say I am surprised at how detailed it is. I’ve been using order by with text fields and have not encountered any issues, so you will have to play around to see what works for you.
-
That did the trick and I was assuming the Sort() was the right one but Order did the trick thanks!
-
Fred Highlighting the use of Order in the select statement fixed my issue
Content aside
- Status Answered
- 1 yr agoLast active
- 7Replies
- 114Views
-
3
Following