In the query there is order by three fields (ie order by 1,3,4)
and i used sort stage to satisfy that , but the data is not sorting .
any clue why this is happening?
any other solution to sort apart from this?
Problem with Sort stage
Moderators: chulett, rschirm, roy
Re: Problem with Sort stage
Click on the blue part to go to beaditya's relating post.beaditya wrote:In the query there is order by three fields (ie order by 1,3,4)
and i used sort stage to satisfy that , but the data is not sorting .
any clue why this is happening?
any other solution to sort apart from this?
How are you exaclty specifying the sort criteria? Read the plug-in documentation of sort stage for more info.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Re: Problem with Sort stage
DSguru2B wrote:Click on the blue part to go to beaditya's relating post.beaditya wrote:In the query there is order by three fields (ie order by 1,3,4)
and i used sort stage to satisfy that , but the data is not sorting .
any clue why this is happening?
any other solution to sort apart from this?
How are you exaclty specifying the sort criteria? Read the plug-in documentation of sort stage for more info.
i gave in the sort specification as
MGMT_ACCT asc,Redeploy_Eff_Date asc,Eff_Date asc.
is there any other way to do so . its not even sorting MGMT_ACCT either.
Re: Problem with Sort stage
Why are you not using the "order by" clause in the query itself ..
I dont think thats whats happening in the OP's case. I think its more like a datatype problem. beaditya might be expecting a numeric sort on a char field or viceversa.
Even i try not to use the sort stage. I usually adhere to the unix sort. Much faster.
Even i try not to use the sort stage. I usually adhere to the unix sort. Much faster.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.