Query of Queries child sorting

4 replies
412 views
Translate

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 is closed to new replies. Start a new post to keep the conversation going.

D

Dave Watts

Community Expert

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

Translate

Dave Watts, Eidolon LLC

B

Ben_Brandt_805Author

Participant

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.

Translate

D

Dave Watts

Community Expert

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

Translate

Dave Watts, Eidolon LLC

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.