Question Re: MDK Queryoptions using Rule does not work in Technology Q&A

MDK Queryoptions using Rule does not work

sopizaken — Wed, 23 Feb 2022 12:32:48 GMT

Hi experts,

We have created an mdk project that displays a hierarchy of locations and equipments under those locations. However, we dont have a separate entity for the locations. We only have an entity for all the equipments and we just have fields to identify as to which location the equipment belongs to. Because of this, every time i read the entity, i get duplicate values for the locations.

That is why, i have created a rule to define a query option wherein the list will only get one equipment of that location. I have seen that the filter parameter that is being returned by the rule is correct, however the list still displays all the items. Would you know why the list doesn't seem to get the correct filter for this? Here's the custom rule i have written:

When i added an alert displaying the output, it correctly returns the unique filter parameters.

Appreciate any inputs you may have.
Thank you!

Re: MDK Queryoptions using Rule does not work

dhanikawick41 — Wed, 23 Feb 2022 13:44:14 GMT

Hi @sopizaken

I think you do not need to return the entityset name if the rule is used as a query because you already define it in the Target. Your output variable should be as below.

let output = "$filter=";

I did a similar thing recently and what I returned was something as below and it worked totally fine.

return "$filter=TechnicalObject eq '" + technicalObject + "'&$orderby=OrderNumber desc";

Thanks.

Re: MDK Queryoptions using Rule does not work

bill_froelich — Wed, 23 Feb 2022 13:51:33 GMT

Dhanika is correct, you should not return the Entity Set name in your query options rule.

Re: MDK Queryoptions using Rule does not work

sopizaken — Fri, 25 Feb 2022 08:27:20 GMT

Thanks dhanikawick41! That solved the issue 🙂