Value for a property in a schema showing empty | Community
Skip to main content
GK-007
GK-007
Level 9
November 11, 2025
Solved

Value for a property in a schema showing empty

  • November 11, 2025
  • 1 reply
  • 151 views

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

Best answer by 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!

1 reply

Harveer_SinghGi1
Community Advisor and Adobe Champion
Harveer_SinghGi1Community Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
November 13, 2025

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!

Terms & ConditionsAccessibility statement

Loading footer...