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!!