Hi,
I'm following this tutorial to create a custom sort operator for GQI.
The example is going over the table row by row to identify the relative sorting position.
However, in my use case, I need the full column dataset to determine the relative sorting position.
Is there a way for me to get all values from a given column in my custom operator?
Hi Thomas,
Thanks for your feedback.
However, from the provided documentation, I'm unable to figure out how I can get all values in one column in one go.
The GQIColumn class doesn't seem to contain a method or property to fetch the info.
Do you have an example?
I'm sorry, I have misread your question. I don't think it is possible to get the entire column.
Hi Ive,
Not sure if it would work for your application, but have you tried using the 'Column Manipulations' method 'RegExMatch', where you can create a new column in the GQI table based on the RegexMatch results of selected column, then sort off this new results column? It may take a couple column manipulations as Regex in GQI only acts off the first match, you cannot group them together.
Hi Ive.
You can retrieve the entire column, through "header.GetColumn(columnName), in the HandleColumns method.
You can find more details about the HandleColumns method on the docs:
https://docs.dataminer.services/user-guide/Advanced_Modules/Dashboards_and_Low_Code_Apps/GQI/Extensions/Custom_Operator/Tutorials/Custom_Operator_Tutorial.html?q=HandleColumns
It receives a GQIEditableHeader as argument, which can access individual columns:
https://docs.dataminer.services/user-guide/Advanced_Modules/Dashboards_and_Low_Code_Apps/GQI/Extensions/API_Reference/GQIEditableHeader.html?q=GQIEditableHeader
There is also a full example on documentation about custom sorting:
https://docs.dataminer.services/user-guide/Advanced_Modules/Dashboards_and_Low_Code_Apps/GQI/Extensions/Custom_Operator/Tutorials/Redirect_Sort_Operator.html