Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Maxime_Lenglet
Contributor
Contributor

MDM Query Language: how to alias Types in $explicitprojection$?

In our company we have a Talend MDM Enterprise Edition server.

From the homepage of the TAC, I can see version is: 7.1.1.20181026_1147-

I'm in charge of querying data from this system. Disclaimer: I'm not part of our team working with the Talend server.

So I use the MDM Query Language as described in this online doc: https://help.talend.com/reader/OExHeKAk2NLlFKnNAXdI1A/ef~ulFtrHdc5ut5XIpp5IA

When I query like this:

{

 "select": {

  "from": [

   "SomeType"

  ]

}

}

I get something like this:

[

 {

  "sometype": {

   "idsometype": "1",

   "labelsometype": "Label # 1"

  }

 },

 {

  "sometype": {

   "idsometype": "2",

   "labelsometype": "Label # 2"

  }

 }

]

I saw there is a way to alias fields, e.g.

{

 "select": {

  "from": [

   "SomeType"

  ],

  "fields": [

   {

    "alias": [

     {

      "name": "id"

     },

     {

      "field": "SomeType/IdSomeType"

     }

    ]

   },

   {

    "alias": [

     {

      "name": "label"

     },

     {

      "field": "SomeType/LabelSomeType"

     }

    ]

   }

  ]

}

}

but then I get this:

[

 {

  "$explicitprojection$": {

   "id": "1",

   "label": "Label # 1"

  }

 },

 {

  "$explicitprojection$": {

   "id": "2",

   "label": "Label # 2"

  }

 }

]

HOW do I alias the "$explicitprojection$"???

Labels (3)
0 Replies