**FR - ORDER BY to be enforced in Processes

RentProperty

So support just confirmed that this is in fact how it has been from day one.... But I cannot see why it has to be this way.

I neeeed to Find Objects in a very specific order Within my process and the execute my Sub Process on them in that order. However Doing: FIND Account WHERE xxxx ORDER BY Account.Priority ASC, Account.ID DESC, has no effect. It Just finds it in a random sequence.

Having to build a workaround for this is not ideal since we might want to run a process like this on 5000 accounts with 5 - 50 Transactions on each account.

PLEASE support... Can you consider Enforcing ORDER BY in Queries within Processes as well.

intra

I am now also in the same boat where i require to a strict order to the items in context being fed into my sub process.

Happy to chip in for this feature.

Jaymer

I was recently working on building Chart data for ANYCHART.

I needed the chart sorted by the branch name (Affil). My data strings were being build NOT in a random order, but by the internal ID sequence.

FIND Orders WHERE Orders.ob_Week=LoggedInRegularUser.ps_Week ORDER BY Orders.Affil 
CAppendChartStrings

It was odd to me that it seemed like the ORDER BY was ignored.
Being on MS SQL SERVER, I ran a trace to see what was going on and found that INDEED the rows were being FOUND in my specified order, but somehow the next process (CAppendChartStrings) seemed to be losing the order.

While slowing my process down, I added
IN BATCHES OF 1
to the end and now my chart data is built in the order specified in the FIND

Final code that works:

FIND Orders WHERE Orders.ob_Week=LoggedInRegularUser.ps_Week AND Orders.Active>0 ORDER BY Orders.Affil IN BATCHES OF 1 
CAppendChartStrings

Jaymer...