SAP MDK Grouping with $select but not visible in App

[Ladidudidadacat]

Hello,

i have an analytic query and when i try something like "$select=Customer" in SAP Gateway Client it gives me a grouped result and everything is fine. But when i try it with my Service in the WEbIDE and have "$select=ClusterName" in my query options for a list there are no values visible 😞

Maybe someone can help me 🙂

Kind Reagrds

Fabian

[ashishjain14]

Can you elaborate how are you using it in webide?

[Ladidudidadacat]

Hey Anish,
i have a contact cell table where i set on the Target the service and the entity. It is working fine when i have no select in the query option (top, filter,etc.) is working. But not with an select in it:

I just have an empty screen after deploying 😞
I also checked the backend(payload trace) and it looks good:

Also the response is looking good:

Therefore i am asking here. Do i have to change something in the service or in the query options. My goal is to group my analytic query by country, article, etc.

Kind Regards
Fabian

[Ladidudidadacat]

Ashish, i love you!!!!
Thank you so much!!!!
Now i see the selected values!!!!
You are the hero of my week! Or even hero of the month! You made me sooo happy 🙂
Can´t say "thank you" often enough!

Kind Regards
Fabian

[bill_froelich]

Fabian,

As a workaround, in your MDK .service metadata, please set the Service Option for fixMissingNullValues to true.

"OnlineOptions": {
    "ServiceOptions": {
      "fixMissingNullValues": true
    }
}

This should allow the query to return the result set expected. We are still looking into this further as well from our side.

--Bill