0

I'm unable yet to locate a particular "Item owner: sitecore\smith" value I see well-and-alive in Content Editor "Quick Info" of an item, but not in the SQL Server backend tables.

I often pull a convenient SELECT query over the:

  • Items
  • VersionedFields
  • unVersionedFields

tables, but this particular field VALUE doesn't seem to live there. I went to other tables like History, but still didn't find it there either.

To be noted is that it's a content that is created from an importing agent automation from a CSV file. So the __owner "sitecore\smith" is from the developer under which the import agent executes, rather that the real Sitecore end-user. But does it really matter as to simply find where this value "sitecore\smith" lives in the backend tables..

Thank you!

  • sitecore\smith is a user, but the master database doesn't contain user information, the Core database handles that functionality. Are you just trying to determine where information for sitecore\smith exists? – Dylan Young Oct 3 '18 at 17:52
  • Thank you Dylan, I'm trying to determine where the "sitecore\smith" VALUE, of presumably the __owner field came from, on the "Quick Info" of an item. When I lookup the item in SQL Server versionedFields table (and unversionedFields, sharedFields tables , I find __created_by, but there's no __owner field for this particular item. The mystery deepens further: I do a View Source in the browser, and see, nested in <td> "Item Owner:" => sitecore\admin. – Coeur Dusite Oct 8 '18 at 21:18
  • PS: thanks a ton for your wonderful Youtube workshops! I've been iterating on these recently and this has been really helpful! – Coeur Dusite Oct 8 '18 at 21:21
2

Item owner is a versioned field of an item. You can see it in the Security section:

enter image description here

enter image description here

If you want to find that value for given item in a Sitecore database, you can use a query like:

SELECT 
    *
FROM 
    [VersionedFields]
  WHERE 
    FieldId = '52807595-0F8F-4B20-8D2A-CB71D28C6103'
AND
  ItemId = '110D559F-DEA5-42EA-9C1C-8A5DF7E70EF9'

enter image description here

  • Thank you Marek, yes this is the query that should surface it up, but unfortunately doesn't. And strangely enough, I do a View Source on the "Quick Info" page, and I see "Item Owner:" ... "sitecore\admin" while the page shows "sitecore\smith".. The mystery deepens. I'm thinking of 2 possibilities: 1) it could come from an internal Sitecore/Lucene index, and not from the SQL Server tables and although both should be synced they are not. Or 2) it could be the "Item Owner" of a bucket and/or parent content. But this is unlikely. Or this is yet another table like versionedFields that I missed – Coeur Dusite Oct 8 '18 at 21:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.