Hi,
is it possible have an custom operator go through all rows of an query and then return an completely new set of rows based on that?
Use case is as follows, i've got an table with an json string, i want to return all rows where an certain string matches within that json. This can be one row, this can be 50 rows.
Then i would to feed all the json of those rows into some logic, and return based on an setting in the custom operator a bunch of nodes or edges.
Hi Gerwin,
As far as I know GQI custom operators are row based. This means that you could only process one row at the time. In this case you will need to use an ad-hoc data source
Hope it helps.
Hi Gerwin,
You will need to use the GQIDMS class:
https://docs.dataminer.services/user-guide/Advanced_Modules/Dashboards_and_Low_Code_Apps/GQI/Extensions/API_Reference/GQIDMS.html
In Github you can find some examples:
https://github.com/orgs/SkylineCommunications/repositories?q=gqids&type=all&language=&sort=
Is it possible to link an input argument to an feed?
The use case have is the following: an virtual matrix element which supports loop devices. I want to show an path from an source to all connected destinations and loop devices. In the destinations table is an column containing the complete path for that destination. So I’ve got an script now that will search that column for the source-guid i want to show. and will then filter that data to extract all nodes an paths. i then generate an dot-string which will work, but i would like to do it natively in Dataminer with dashboard and node edge component. So i’ll open the dashboard from an visio with an parameter in the url and i would like to to the same logic to get the nodes and edges. (there is some logic then when selecting an loop device as source it will detect that and will draw the path from the actual source.)
Hi Gerwin,
You could create a new column in the custom operator that allows you to identify the rows you are interested on. For example, the new column can contain the value of the node or the edge parsed from the JSON.
As for the removal of the rows, you can use GQI Filter method to remove the rows that didn't give you a result in the new column you created, or you can use the method row.Delete() as this example does: SLC-GQIO-SkipX/SkipX_1/SkipX_1.cs at main · SkylineCommunications/SLC-GQIO-SkipX (github.com)
How can i access the filter data or an table within an DMA from an ad hoc source? since the engine is not available.