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

Maxime_Lenglet — Sat, 16 Nov 2024 01:03:13 GMT

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$"???

topic MDM Query Language: how to alias Types in $explicitprojection$? in Talend Data Catalog

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