How do we employ an array function within a struct to retrieve particular records from an array of objects?
Hi @Snowwhite5378 ,
You can achieve this by using an Inline Function, sample query is mentioned below:
SELECT inline(array(struct(1, 'a'), struct(2, 'b'))), 'AAA';
https://experienceleague.adobe.com/en/docs/experience-platform/query/sql/syntax#inline
For more details on higher-order functions follow the link below:
https://experienceleague.adobe.com/en/docs/experience-platform/query/sql/higher-order-functions
Regards,
Kumar Saurabh
Views
Replies
Total Likes