Apr 17, 2018 at 10:23 PM

How to write SQL statements used in export property files?

107 Views Last edit Apr 18, 2018 at 12:06 PM 3 rev

I have the following export query in my property file.

exportquery1=SELECT SI_NAME FROM CI_SYSTEMOBJECTS WHERE SI_KIND = 'USERGROUP' AND SI_NAME IN ('PHI-Access','Blood-Access')

When I run the export bat file I get the following error:

Failed to get dependencies of the job.(PRS 00048) The property with ID SI_CUID does not exist in the object (FWM 02021) GetRelatedDependenciesFailed.

But when I run this statement, it works.

exportquery2=select * from ci_infoobjects WHERE SI_PARENT_CUID = 'AUjZybtr0WNFtdPJppkVBJo'

So it seems like I do not have enough information on my select statement to work properly.

I've seen couple of articles by Mahak Rathore include a link to his property files. But the property file doesn't exist. Is there a way to get a copy of the samples he provided?

Thanks

conrado