Support for user-defined queries in data extracts
Users now can model their own SQL queries as custom business object queries against the Read-Optimized Data Store. These views can be run on demand in synchronous mode in your own integrations, or included as part of an asynchronous data extract.
Define an extract based on Standard Views or User-Defined Queries and specify the Parameter Values for the extract.
Extract Definition
Create a User-Defined Query on which to base the extraction.
User-Defined Query
Customers may set up a guided journey to embed the existing AI agent to transform SQL to Boss Query Language (BQL) when constructing a new user-defined query.
Users can now schedule data extraction jobs that run faster and perform queries that will have no impact on interactive application performance.
Steps to enable and configure
Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.
Offering: Manufacturing and Supply Chain Materials Management No Longer Optional From: Update 27C
Redwood: Use complex and user-defined data extracts using a Redwood page
Access requirements
No additional privileges are needed.