Skip to Content
0
Jun 04, 2020 at 03:29 PM

CMS Database Universe - E-mail Recipients

478 Views

Hi,

I run the following query on Query Builder and I can get the results.

SELECT SI_NAME, SI_OWNER FROM CI_INFOOBJECTS WHERE SI_SCHEDULEINFO.SI_DESTINATIONS LIKE '%abc@xyz.com%' AND SI_RUNNABLE_OBJECT = 1

I want to have the destination dimension on the CMS Universe and added a new dimension as "Properties.si_scheduleinfo.si_destinations". However, it's always blank on query results. All other dimensions like Start Date, Schedule Type etc. can be retrieved.

Is there anything else required to get the destinations field to Universe and queries?

Regards,
Erdem