Skip to main content
B
Ben_Brandt_805
Participant
March 7, 2018
Question

Query of Queries child sorting

  • March 7, 2018
  • 1 reply
  • 394 views

When preforming a query of query I am losing the sort order of the cached query.

The column that the cached query is sorting by is not one I could use in the new

query. Is there any way to keep the sorting the same through both queries?

Thanks

This topic has been closed for replies.

1 reply

D
Community Expert
Dave WattsCommunity Expert
Community Expert
March 8, 2018

I'm confused. If you can't order by the original column, how would you expect the new query to be sorted by that column?

Dave Watts, Fig Leaf Software

Dave Watts, Eidolon LLC
B
Ben_Brandt_805Author
Participant
March 8, 2018

Hi Dave,

The original query gets sorted properly. I was thinking that when I queried the original query the sort order would still be the same, just a smaller result set based on the columns I selected.

D
Community Expert
Dave WattsCommunity Expert
Community Expert
March 8, 2018

Hi, Ben!

Can't you just include an ORDER BY clause in the second query? There's no guarantee that any query will be sorted the way you want it without an ORDER BY clause.

Dave Watts, Fig Leaf Software

Dave Watts, Eidolon LLC
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices