UNION Operator in Runtime Analytics

[dhanashree_m]

Hi Team,

Can we use union operator in runtime analytics?

Below is the sample query:

select u.username as USERNAME, u.email as EMAIL from users u where u.username = '${userName}'
union
select u.username as USERNAME, a.customproperty22 as EMAIL from accounts a, user_accounts ua, users u, endpoints e where u.userkey = ua.userkey and ua.accountkey = a.accountkey and a.endpointkey = e.endpointkey and e.endpointname = '${appName}' and u.username = '${userName}'

Thanks!

[jayasudha]

Hi Dhanashree,

Greetings.. Thank you for reaching out to us.. Yes. It is supported in "Runtime Analytics"

Thanks and regards,

Jayasudha R

[rushikeshvartak]

Yes, you can always preview before creating report 

See below i have created same with above query