Skip to main content

New answers tagged

0 votes
Accepted

Challenge in SQL JSON_VALUE to Query XDB.Shards: Assistance for the xdb_Collection.Intreactions.Events Column

After looking at the data in the database, it became evident that the Events value was not in JSON format due to the presence of extra square brackets at the start and end. To resolve this issue, I ...
Sunil Rana's user avatar
1 vote

Challenge in SQL JSON_VALUE to Query XDB.Shards: Assistance for the xdb_Collection.Intreactions.Events Column

Since you trying to fetch distinct title from the Events Property inside the Interactions table and Events property being an array of events in xConnect, you can use following query to achieve the ...
ckhanna's user avatar
  • 1,143
0 votes

Challenge in SQL JSON_VALUE to Query XDB.Shards: Assistance for the xdb_Collection.Intreactions.Events Column

Events columns contains JSON which is an array. You need to add [0] to get the event. In your case please find the example SELECT COALESCE(JSON_VALUE(i.Events, '$[0].DefinitionId'), 'Unknown') AS ...
Sreekrishnan's user avatar
0 votes

Challenge in SQL JSON_VALUE to Query XDB.Shards: Assistance for the xdb_Collection.Intreactions.Events Column

Events columns contains JSON which is an array. That's why you need to add [0] to get the first event and only then Title, e.g.: SELECT TOP 10 interaction.InteractionId, JSON_VALUE(interaction....
Marek Musielak's user avatar
  • 23.9k
3 votes

How to move contact and traffic data from xDB to CDP

Sitecore has introduced the xDB to CDP Migration Tool using which you can migrate visitor contact data from the Sitecore XDB to the Sitecore CDP. Prerequisites of using this tool: Sitecore XP license ...
Raman Gupta's user avatar
  • 2,609

Top 50 recent answers are included