Skip to main content
Solved

Apps9 Lobby sorting - can't see how to in query builder

  • October 29, 2020
  • 3 replies
  • 296 views
S
Hero (Customer)
Forum|alt.badge.img+10

Hello All

I’ve created a lobby element using the query builder in data source designer for Customer Sales Order Milestone. Data works no issue, however I can not see a way to sort the data by expected date so it looks more user friendly. What am I missing?

Thanks Sarah

Best answer by paul harland

Hi Sarah,

I think that’s a limitation of the query builder approach.

You can get order by when you use SQL format for data source.

3 replies

paul harland
Superhero (Employee)
Forum|alt.badge.img+24
  • paul harland
  • 547 replies
  • Answer
  • October 30, 2020

Hi Sarah,

I think that’s a limitation of the query builder approach.

You can get order by when you use SQL format for data source.

S
Hero (Customer)
Forum|alt.badge.img+10
  • sholmes
  • Author
  • Hero (Customer)
  • 97 replies
  • November 2, 2020

Thanks Paul - thought that might be the case - I’ll have to see if I can improve my SQL skills

PvanderHeyden
Do Gooder (Customer)
Forum|alt.badge.img+1
  • PvanderHeyden
  • Do Gooder (Customer)
  • 2 replies
  • January 9, 2023

You can also edit the source code in the exported XML.
See:

 


Terms & ConditionsCookie settingsAccessibility statement