Value for a property in a schema showing empty

[GK-007]

Hello Team,

As part of our schema we have an property whose value is set by reading one of the query param and set the value. We are able to see the value as part of the page load event but same property value is not returning if query in dataset. Below is the query.

select _xxxxxx.ids.sfId,TIMESTAMP from xxxx_com_qa where TIMESTAMP > '2025-11-09

I am unable to understand what's the issue, why it's not retrieved. Unavailability of this value also preventing to create CJA report.

Thanks,

GK

[Harveer_SinghGi1]

Hi @GK-007 ,

I'd check for couple of things to troubleshoot this,

• Try running DISTINCT(select _xxxxxx.ids.sfId) from xxxx_com_qa to check if you are getting any anything at all in this field
• Check for any batch failures because of any data type mismatch on this field
• Check your data prep in datastream for possible overwrite of this field
• Make sure _xxxxxx.ids.sfId field notation is correct. For e.g. if _xxxxxx.ids is an array of object then the syntax would change as _xxxxxx.ids[*].sfId.

Cheers!