Home› CMDB Portal
Options

?expand function in Odata Grids

Simon_ZeinhoferSimon_Zeinhofer Customer Ninja IT Monkey ✭✭✭✭
edited February 2023 in CMDB Portal

Just for my genereal understanding:

Is the "?expand=" function from this KB Article also available in oData Grids other than the predefined collections?

https://kb.cireson.com/article/custom-grids/2612

If yes, is it possible to combine it with the "?$filter=" function? Because I failed miserably and was not able to make it work.

Best Answer

  • Options
    Justin_WorkmanJustin_Workman Cireson Support Super IT Monkey ✭✭✭✭✭
    Answer ✓

    @Simon_Zeinhofer - This is technically possible. However, the data in the platform tables doesn't typically have a relationship to actually expand on. The relationships like Affected and Assigned user are "flattened" with a few properties exposed during caching. If you look at <server>/platform/api/$metadata, you can see the "NavigationCollection"s that can be expanded for any given type. You will see that mostly there isn't any data to expand.

Answers

  • Options
    Simon_ZeinhoferSimon_Zeinhofer Customer Ninja IT Monkey ✭✭✭✭

    +1

  • Options
    Justin_WorkmanJustin_Workman Cireson Support Super IT Monkey ✭✭✭✭✭
    Answer ✓

    @Simon_Zeinhofer - This is technically possible. However, the data in the platform tables doesn't typically have a relationship to actually expand on. The relationships like Affected and Assigned user are "flattened" with a few properties exposed during caching. If you look at <server>/platform/api/$metadata, you can see the "NavigationCollection"s that can be expanded for any given type. You will see that mostly there isn't any data to expand.

Sign In or Register to comment.