Problem with advenced queries
WEBCON BPS Designer Studio always had problem with testing and resolving advanced SQL queries, which may be a bit frustrating when there is a need to use form fields like Data table or Data row. On query testing or form field configuration given query is encapsulated and runned on choosed data source. This encapsulation is the problem, because everything which is not a simple select statement, will result an error.
The simplest example – “order by” clause. In WEBCON BPS Studio there is no way to test or confgure form field with this clause. So what can we do?
Solution
Configured SQL query is encapsulated only in WEBCON BPS Studio. That means our query will be executed normally on browswering on web. All you need to do is prepare specific simple SQL query wich will return columns with the same names. Values do not matter at this point. This query should allow you open form field configuration window.
After setting form field configuration you may just paste your prepared valid advenced SQL query.
Select WFD_ID as ID, WFD_SIGNATURE as name from WFElements
Right SQL query
order by WFD_ID DESC
That’s all!
In Studio, the “Select WFD_ID as ID, WFD_SIGNATURE as name from WFElements
order by WFD_ID DESC”, works fine.
In Webcon, we have to change to “Select WFD_ID as ID, WFD_SIGNATURE as name from WFElements
order by ID DESC”