Syntax error! How get value in object by variable

Analytics
1

Hi!

I have a sample query like

SELECT orID.[testId] FROM `cms-deploy-dev` 
LET orID = {
"test": 123,
"0018e390-e5bf-4efc-8fd7-2715521d1213": 1,
"0007ec8c-bbd7-419e-a83c-f06df9d27cce": 2
}, testId = "test"
WHERE _type = 'game'  
LIMIT 1

How can I get value from Object orID by variable testId ?

Thank you!

2

@Lenty_Me , try using get_object_field_value() function: get_object_field_value(orID, testId).
E.g.

SELECT get_object_field_value(orID, testId)
LET orID = {
  "test": 123,
  "0018e390-e5bf-4efc-8fd7-2715521d1213": 1,
  "0007ec8c-bbd7-419e-a83c-f06df9d27cce": 2
 }, 
 testId = "test"
3

Thank you, Could you provide documentations about functions like get_object_field_value?

4

Hi @Lenty_Me ,
Analytics object functions are documented at

We’ll need to add get_object_field_value() documentation there as well.