I have a table and when i double click a row a panel opens, where i have placed another table. Im using GQI to fetch the data in the panel table. I want to pass the column value (which im double clicking) to the gqi query and process the query based on my input to display my data.
Hello,
To my knowledge, it's not possible to pass a single cell value using the double-click options in table settings. By default, you can only pass the entire row, which means you'll need to select one or multiple cell values you want to filter on.
In your panel queries you would need to add a filter on each column you want to apply it to
then you would need to select the feed from the first table
The result would be the panel opening filtering here on the element name from the row you selected in your table
To achieve filtering on a specific cell, you can use the following workaround:
- Use the column appearance in the layout menu of your first table.
- Create a transparent background for each cell you want to be able to filter on.
- Configure an action for this background to open your panel.
Then you can configure action to this background to open a your panel
Here since i configured my Severity cells i would need to filter the severity in the GQI of my panel
Then you would need to repeat this process for every column you want this feature to be available
The downside to this process is that you need to make a panel for every column, and it's not a double click but a single click
Here is the result :
cliking on Suggestion would open a panel filtering on "Suggestion"
If anything is unclear or you need more information, please don't hesitate to ask.
Best Regards,
Alexandre
Hello, sorry for the wait time. So, if I understand correctly, the first table retrieves a list of services, and the second table in the panel should be able to filter the alarms of the service selected in the first table?
For this, I think the best solution is to use the Ad hoc data source : https://github.com/SkylineCommunications/SLC-GQIDS-ServiceAlarms
In the panel table. To make it dynamic, you’ll need to use the feed from the first table as the name of the service in the ad hoc data source argument
However, you will only have access to certain alarm properties
ID (String)
Element (String)
Parameter (String)
Value (String)
Time (DateTime)
Severity (String)
Owner (String)
As specified in the readme section.
In order to retrieve more information about the alarms, you would need to modify the ad hoc data to be able retrieve more alarm properties defined here: https://docs.dataminer.services/develop/webservices/WS_v0/WS_CustomDataTypes_v0/AlarmEventMessage.html?q=alarmeventmessage
Hope it helps,
Alexandre
Thanks for the workaround. I have added the screenshot above to clear the requirement. As you can see the ss, if i click italy vs spain(service) column my panel opens with elements and parameters that are under the service. right now it is not dynamic coz im not able to pass the service name into my GQI