Insight Macro for Confluence: Sorting columns

[Johannes Buverud]

It looks like the macro default displays the values sorted on label name.

Is it possible to sort on other attributes?

[Andreas Larson · Accepted solution]

Hi Johannes,

If I understand you correctly, the only thing you have to do is to drag and drop the selected attributes in the right order, in the configuration.

Best Regard

[Johannes Buverud]

In "edit macro", I tried dragging another attribute to the top, but it did not sort on that attribute. 

(Ideally it should be possible to just click the column header to sort it, just like in Insight.)

[Andreas Larson]

All right, I got you. It's not possible to sort by clicking on the header but something we got feature requests for and will implement in a version not too far away.

The way to sort right now is by doing it in the IQL, see https://documentation.riada.se/insight/latest/insight-user-s-guide/iql-insight-query-language#IQL-InsightQueryLanguage-IQL-OrderBy

Best Regards

[Johannes Buverud]

Sorting by IQL worked perfect, and looking forward to the feature request being implemented.

Thanks!

[Joseph Isom]

@Andreas Larson I am excited to hear that you will soon allow sorting by clicking on the header. I would also like to know how I can request filtering by clicking on the header?

Our use case: we have 10,000+ insight objects and we have a team that is responsible for conducting monthly inventory. We would like to provide them a Confluence page that lists all the assets but allows them to filter down to a building or room level. I am sure there is some way to do it with IQL (I am still learning) but the users of this page would not begin to understand how to modify a filter in IQL. 

[Thomas Bowskill]

Clickable headers would be great to have -- that and the ability to filter (although I know that one is a bit of a stretch!)