This content has been marked as final. Show 2 replies
You can write simple select statement in VO query without any where clause like this:
SELECT po_header_id PoHeaderId,LISTAGG(po_line_id,',') WITHIN GROUP (ORDER BY po_header_id) PoLineIds FROM xxpo_dropship_documents_v
and then set where clause using vo.setWhereClause("<condition>");
after this, use vo.setWhereClauseParam() to set the parameters values.
thanks for your suggestion.
However, then I can't use the GROUP BY anymore, can I?
And I noticed that it still doesn't use the user environment to the database. How can I query environment dependent views, in general?