We have a section of code that executes multiple independent NQL queries, appending their results into an ArrayList variable. The application retrieves data from this variable, and these individual NQL queries are dynamic in nature; they accept variables based on business logic and execute when certain conditions are met.
In CB, is it possible to write join queries that combine these dynamic NQL queries? If so, could you please share any blog posts or documentation references related to this topic?
Hi @mreiche , the requirement is there are a set of queries which are executing and output of a query needs some preprocessing (looping and various checks based on some variables) before it is passed on to next query as inputs. This we would not able to meet directly with Union, Intersect etc. We wanted to understand if any other possible way can be explored?
Thanks for your reply . We just did a quick study but we do not found any way to encapsulate the business logic in the UDF like we did in stored procedure in Oracle.