Samples and tips how to troubleshoot EPiServer object store functionality.
List indexed values of object store
All data in object store are located in serialized strings and can be hard to troubleshoot, to get a quick view you can run the following command and see all fields visible for SQL queries.
SELECT
'',
COALESCE(
tblIndexBigInt.FkItemId,
tblIndexInt.FkItemId,
tblIndexDateTime.FkItemId,
tblIndexDecimal.FkItemId,
tblIndexfloat.FkItemId,
tblIndexGuid.FkItemId,
tblIndexString.FkItemId) as id,
Fieldname,
CAST(COALESCE(
tblIndexBigInt.FieldValue,
tblIndexInt.FieldValue,
tblIndexDecimal.FieldValue,
tblIndexfloat.FieldValue,
tblIndexString.FieldValue,
CAST(tblIndexGuid.FieldValue as VARCHAR(MAX)),
CAST(tblIndexDateTime.FieldValue as VARCHAR(MAX))) as VARCHAR(MAX))
as value
FROM tblSchema
JOIN tblSchemaItem ON tblSchemaItem.fkSchemaId = tblSchema.PkId
LEFT JOIN tblIndexBigInt ON tblIndexBigInt.fkSchemaItemId = tblSchemaItem.PkId
LEFT JOIN tblIndexInt ON tblIndexInt.fkSchemaItemId = tblSchemaItem.PkId
LEFT JOIN tblIndexDateTime ON tblIndexDateTime.fkSchemaItemId = tblSchemaItem.PkId
LEFT JOIN tblIndexDecimal ON tblIndexDecimal.fkSchemaItemId = tblSchemaItem.PkId
LEFT JOIN tblIndexfloat ON tblIndexfloat.fkSchemaItemId = tblSchemaItem.PkId
LEFT JOIN tblIndexGuid ON tblIndexGuid.fkSchemaItemId = tblSchemaItem.PkId
LEFT JOIN tblIndexString ON tblIndexString.fkSchemaItemId = tblSchemaItem.PkId
WHERE indexed = 1
UNION
SELECT SchemaId, tblItem.pkId, '-Name', Name
FROM tblItem
JOIN tblSchema ON tblSchema.pkId = tblItem.fkSchemaId
ORDER BY id, fieldname DESC