Sort condition only works in initial query

[Former Member]

I have a two structure selections where I need the ability to sort the results descending (toggled one at a time). I've created two "Bottom % - 100" conditions and have one active to start.

When I first execute the query, the active condition correctly sorts the results descending on the first column. However, if I deactivate that first condition and then activate the 2nd sort condition, the query results do not re-sort themselves accordingly.

Even if I save a query view with only the 2nd sort active and then re-execute the view, the 2nd sort still does not apply correctly. The query results only sort correctly during the first execution of the base query, with whichever sort condition was saved as active in the query definition.

Any thoughts on how to effectively alternate sort columns would be appreciated.

Thanks.

-Amy

[Former Member]

Hi,

Keep both conditinon as active by default and then change after first exceution as needed.

I hope it will help.

Thanks,

S

[Former Member]

Unfortunately that does not work. The query results only sort by whichever condition was saved last. If I turn off the one condiiton, and leave the other one active, the results do not re-sort themselves to match the active condition.

Any other ideas?

Thanks.

[Former Member]

can u leave both conditon active and then deactive the first one, ?