Skip to main content
avillanueva
23-Emerald I
23-Emerald I
October 6, 2025
Solved

Options for column sorting missing from QML report definition

  • October 6, 2025
  • 2 replies
  • 360 views

I have long wondered this question and figured someone out there might know. I have a QML report that looks fairly simple. Even though I have a bunch of selected columns in my output, you are not able to apply sorting on all of them. In this case, I am reporting all Suppliers but the Supplier name is not available to be the default sort. What gives here?

avillanueva_0-1759759737149.png

It even shows a blank column which is strange. 

avillanueva_1-1759759789387.png

 

Best answer by joe_morton

I think it's because those are "Objects". You can't enter specify criteria for an Object when you run the search. It can't be be sorted either. The query is finding Objects, then there's an additional step to render that as a String for the actual results.

 

Usually when you are reporting on an Object, you can find the underlying column you want by navigating the links. I don't have a consistent solution for Supplier Name, but you can try one of these:

  • Principal.Name
    joe_morton_0-1759760814628.png
  • Organization.Name
    joe_morton_1-1759761086243.png

     

 

2 replies

Marco Tosin
21-Topaz I
21-Topaz I
October 6, 2025

As far as I know, and from what I've seen in the ones I've done, only “Column” attributes can be sorted, not “Object” attributes.

 

 

Marco
joe_morton
18-Opal
18-Opal
October 6, 2025

I think it's because those are "Objects". You can't enter specify criteria for an Object when you run the search. It can't be be sorted either. The query is finding Objects, then there's an additional step to render that as a String for the actual results.

 

Usually when you are reporting on an Object, you can find the underlying column you want by navigating the links. I don't have a consistent solution for Supplier Name, but you can try one of these:

  • Principal.Name
    joe_morton_0-1759760814628.png
  • Organization.Name
    joe_morton_1-1759761086243.png

     

 

avillanueva
23-Emerald I
23-Emerald I
October 6, 2025

Thanks, that makes sense, I changed how it was called out and it sorts now.

avillanueva_0-1759770772442.png