You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

how to add fields groupby clause in psquery

3 replies [Last post]
Guest's picture
Guest

hi
Im doing upgradation FSCM8.8/9.1.............I have one issue in psquery.i.e...in query groupby is ther here i want to add some fields in psquery.....let me know clearly how to add those felds

Rajendra Prasad's picture
User offline. Last seen 5 years 51 weeks ago. Offline
Joined: 08/08/2011
Posts: 7
Re: how to add fields groupby clause in psquery

can u make ur requirement is clear?

Raj

Guest's picture
Guest (not verified)
Re: how to add fields groupby clause in psquery

U dont need to add manually,if u are having the aggregate fields in your query then automatically it adds the group by clause.

rahul1.sharma's picture
User offline. Last seen 9 years 6 weeks ago. Offline
Joined: 10/19/2010
Posts: 3
Re: how to add fields groupby clause in psquery

yes, it is correct.If u are using aggregate function in Psquery than Group By is automatically added.