• State Verified Answer
  • Replies 2 replies
  • Subscribers 12 subscribers
  • Views 10613 views
  • Users 0 members are here
Options
Related

Query Builder show database names instead of labels - how to improve property selection for complex data structures?

AngelaIp

Hi community,

does anyone know how to prevent that Aras use labels for the property selector in the QueryBuilder?

I try to extend a Query Definition, but I would prefer if Innovator shows the native database name of the properties instead of the label:

Note following situation in the image:
- Entries are not distinguishable when they have the same label, like "Document"
- Entries are sometimes just blanks where I have removed the label on purpose

Innovator doesn´t even seem to honor my perfect sort_order of these properties. Does anyone have an idea how to improve the situation? I currently use a pretty old QueryBuilder version. Maybe situation has improved in newer Innovator versions, but I have to work with what I have Grinning

Thanks and best regards!

Angela

  • +1 Offline

    Try edit Modules/aras.innovator.QueryBuilder/Scripts/PropertiesView/propertiesView.ts

    function showSelectedProperties() {
...
// Line 112 in my version of Innovator
createNewElement(parentElement, 'li', property.className, property.label); // Change property.label -> property.name
...
}
...
function fillSelect(selectedProperty, select) {
...
// Line 212 in my version of Innovator
select.add(new Option(selectedProperty.label, selectedProperty.name)); // Change selectedProperty.label -> selectedProperty.name
...
}

  • 0

    Hi Alaxala,

    thanks for this fast and perfect solution! In Innovator 12 the same file exists, but it´s a js file instead of a typescript. The code differences are not too big.

    In my version, I had to change an additional 3rd line of code to make the solution work: select.add(new Option(property.label, property.name));

    I found an additional solution which can be handy if somebody needs to select a lot of properties. When you have enabled the relationships in the QueryBuilder, you can directly access the QueryItems. This allows us to add the select properties manually. But it´s not really faster than using the "enhanced" propertiesView.

    Now I can build queries at light speed! Thanks!

    Angela