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
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
Category: Segmentation