SELECT dynamic property in array by N1QL query

Is this possible to SELECT property in array,
such as my array look like


I want to query property in array such as

SELECT name,type,price FROM default

where the array is dynamic.

further more,If I use USE KEYS and filter array,can I query dynamic property such as


the result should be

    "id": "id1",
    "key1_for_id1": "value1",
    "key2_for_id1": "value2"
    "id": "id2",
    "key1_for_id2": "value1",
    "key2_for_id2": "value2"
    "key3_for_id2": "value3"

@atom_yang, Check this article by @keshav_m

1 Like

Above things to select and name the attributes you need to pass two arrays

  1. To name result attributes

  2. Identifiers to select

    sample document:
    β€œk0”: 80,
    β€œk1”: 8,
    β€œk2”: 0,
    β€œk3”: β€œA0080”,
    β€œk4”: β€œA0008”,
    β€œk5”: β€œA0000”,
    β€œk6”: true,
    β€œka0”: [
    β€œka1”: [
    β€œkm0”: 80

Arrays : [k0,k1,k2] [β€œk0”,β€œk1”,β€œk2”]

select RAW o FROM items LET o = OBJECT p:[k0,k1,k2][ARRAY_POSITION(["k0","k1","k2"],p)] FOR p IN ["k0","k1","k2"] END WHERE k0 = 80;

"results": [
            "k0": 80,
            "k1": 8,
            "k2": 0

Thank you very much.

Where is OBJECT function docs?
and as article shows OBJECT will create name:value pairs, in this example,which is name and which is value?


is name and p is value?why?

OBJECT in this case is not function it is collection similar to ARRAY syntax.
@prasad, Can you check if this documented.
@atom_yang In mean time you can see syntax ARRAY, FIRST, and OBJECT

Left side of colon is name which is evaluated and dynamically derived. Right side of colon is value. FOR each element treated as attribute of item and builds json object.

The following is better because names are unique and values are not.

OBJECT p:[k0,k1,k2][ARRAY_POSITION([β€œk0”,β€œk1”,β€œk2”],p)] FOR p IN [β€œk0”,β€œk1”,β€œk2”] END

Both arrays needs to be of same size and we are building name:value pair form both arrays at the same position.

1 Like

so p is name ,such as β€œk0”,β€œk1”,β€œk2”, and [k0,k1,k2][ARRAY_POSITION(["k0","k1","k2"],p)] is corresponding value ?
I am still confused why [k0,k1,k2][ARRAY_POSITION(["k0","k1","k2"],p)] is corresponding value from items?

If p is "k1"
ARRAY_POSITION([β€œk0”,β€œk1”,β€œk2”],p) ===> 1
[k0,k1,k2][ARRAY_POSITION([β€œk0”,β€œk1”,β€œk2”],p)] ===> [k0,k1,k2][1]===> k1
p:[k0,k1,k2][ARRAY_POSITION([β€œk0”,β€œk1”,β€œk2”],p)] ===> β€œk1”:k1
now k1 is expression (it is not a string, no string quotes) so it evaluates form the document and picks value.

Other easy way is [k0,k1,k2] is array of expressions when evaluated (picks the values from the document) becomes array of values.

1 Like

Orz… k1 is cool!
thank you very much. I understand.

it doesn’t seem to be in docs. It should be in
Will get this fixed. Thanks Atom/Sitaram.

1 Like