4

Suggested by Thomas Vieil – Needs Votes

TLDR: Add support for ALL hierarchical operators in the Query Editor

Hierarchies is a data modeling feature that is both powerful and elegant.

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/query-hierarchical-data

Frustratingly, the Query Editor User Interface (UI) used for building dynamic lists (or saved queries) only supports a couple of the hierarchical operators. Currently, when the selected attribute is a primary key, only "under" and "not under" are present among all operators in the drop down list. Other operators such as "above" are missing.

The proposition is to show ALL the hierarchical when the selected attribute is the primary key (of a table with explicit hierarchical relationships).

Comments (1)

Thomas Vieil

Tue, 11 Oct 2022 12:39:21 GMT

Examples

This fetchxml, using "under", was generated with the current UI (xml formatting modified to pass the malicious input filters):

fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false"
  entity name="account"
    attribute name="name" /
    attribute name="accountid" /
    order attribute="name" descending="false" /
    filter type="and"
      condition attribute="accountid" operator="under" /
    /filter
  /entity
/fetch

But this fetchxml, using "above", cannot be generated with the UI (xml formatting modified to pass the malicious input filters):

fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false"
  entity name="account"
    attribute name="name" /
    attribute name="accountid" /
    order attribute="name" descending="false" /
    filter type="and">
      condition attribute="accountid" operator="above" /
    /filter
  /entity
/fetch

Dynamics 365

Full support for Hierarchical operators in the Query Editor

4

Examples

Search Ideas