Hi All,
In query builder for XIR2, I would like select SI_NAME and SI_FCDP_SOURCENAME or SI_FCDP_SOURCEID for selected all reports name and data provider name if the SI_FCDP_SOURCENAME or SI_FCDP_SOURCEID like ‘\%’
Query:
select top 10000 SI_NAME, SI_FCDP_SOURCENAME
from CI_INFOOBJECTS
where SI_FCDP_SOURCENAME LIKE ‘\%’
but the result returns nothing.
I don’t know if I can use SI_FCDP_SOURCENAME like that.
Have you a idea?
Thx
Stéphane.
stephane.arnaud 
(BOB member since 2008-10-14)
You cannot do that kind of query using query builder because SI_FCDP_SOURCENAME is not a stand alone propery rather part of a propertybag SI_FULLCLIENTDATAPROVIDERS. You cannot use propertybags in where clause. You can use SDK to get the filtering you want. Use following query to get Dataprovider info then scan through it to find what you need:
select top 10000 SI_NAME, SI_Processinfo.SI_FULLCLIENTDATAPROVIDERS
from CI_INFOOBJECTS
where si_kind=‘fullclient’
Rachid
rachidb 
(BOB member since 2006-07-06)
(BOB member since 2007-10-05)