How do we write a query for an array function within a struct to retrieve particular records from an array of objects?

How do we employ an array function within a struct to retrieve particular records from an array of objects?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Kumar29917170hcyp

Hi @bellasnow5378 ,

You can achieve this by using an Inline Function, sample query is mentioned below:

SELECT inline(array(struct(1, 'a'), struct(2, 'b'))), 'AAA';

Regards,

Kumar Saurabh

Accepted solution

Adobe Employee

You can achieve this by using an Inline Function, sample query is mentioned below:

SELECT inline(array(struct(1, 'a'), struct(2, 'b'))), 'AAA';

Regards,

Kumar Saurabh

Sign up