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

[omacoder]

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?

[former_member230921 · Accepted solution]

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 ?

[omacoder · Accepted solution]

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

[LepreuxLoic]

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

[omacoder]

Awesome, thank you

[MichaelGrackin]

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.

[DellSC]

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

[omacoder]

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