Question Re: Same query returns two different results - AdminTools vs SDK - Recycle Bin? in Technology Q&A

Same query returns two different results - AdminTools vs SDK - Recycle Bin?

omacoder — Tue, 09 Jul 2019 14:47:27 GMT

Query:

select * from ci_infoobjects where si_cuid ='AXAx1NZNBVdOpRBohW40JBA'

If I run this in the AdminTools\QueryBuilder, I get no results.

If I run this query through the SDK, I get the record returned.

Any ideas why the discrepancies? I believe it may have to do with this item being in the recycle bin. Is the AdminTools Query Builder tool hiding items in the recycle bin?

If so, how do I query via SDK and hide these items in the Recycle Bin?

Re: Same query returns two different results - AdminTools vs SDK - Recycle Bin?

DellSC — Tue, 09 Jul 2019 14:54:14 GMT

Are you using the same credentials to log in to the QueryBuilder and through the SDK? If not, then the issue might be that the two users have different access rights.

-Dell

Re: Same query returns two different results - AdminTools vs SDK - Recycle Bin?

omacoder — Tue, 09 Jul 2019 15:10:57 GMT

Yes... thanks for double checking. Using administrator.

Re: Same query returns two different results - AdminTools vs SDK - Recycle Bin?

MichaelGrackin — Tue, 09 Jul 2019 16:06:44 GMT

Brian, The Recycle Bin Folder SI_ID = 530 and the CUID is 'AQbJ_w80vzFKoHvId1bZRIQ'. Try to enhance your SDK query to exclude objects that are decendents of this folder object.

Re: Same query returns two different results - AdminTools vs SDK - Recycle Bin?

former_member230921 — Tue, 09 Jul 2019 17:47:31 GMT

I just tried by deleting object (moved to recycle Bin) and created query as you mentioned .

QueryBuilder - 0 objects

cmsquery REST API - 0 objects

Then restored object from recycle bin . I got object in both queryBuilder and cmsquery.

Which SDK are you using ?

Re: Same query returns two different results - AdminTools vs SDK - Recycle Bin?

omacoder — Tue, 09 Jul 2019 18:17:27 GMT

I'm sorry, you're correct. I was mixing between my pre-prod and prod environments for verification. My bad!!

Re: Same query returns two different results - AdminTools vs SDK - Recycle Bin?

LepreuxLoic — Tue, 09 Jul 2019 20:52:14 GMT

Hi Brian,

Central Management Server automatically filters recycled objects, unless you include property SI_RECYCLED_OBJECT in select subpart of your CMS query.

With your sample query it looks like:

select *, SI_RECYCLED_OBJECT from ci_infoobjects where si_cuid ='AXAx1NZNBVdOpRBohW40JBA'

Regards,

Loic

Re: Same query returns two different results - AdminTools vs SDK - Recycle Bin?

omacoder — Tue, 09 Jul 2019 21:44:32 GMT

Awesome, thank you