SQL in Genexus and Gxflow

Question

You can return the result of an SQL query in Genexus transaction?

I need to create a Workflow through Genexus, where using DBRET, I was able to read the data from an external BD and now I need to return some information in Gxflow.

I managed to get the flow to return all the data through the transactions imported from the external BD, but I need to individually consult each item of the BD and return the result in the Inbox of gxFlow.

In my case it is a third-party helpdesk system that I am consulting on Genexus, and I want to control the information of the calls, through Gxflow. I need to have Flow generate a new record in Inbox, whenever there is a record of a new call in the external tool.

I wonder if anyone has ever seen or needed anything like this?

Thank you and I look forward to hearing your answers! Obi

Answer 1

Good morning André,

If I understand your need, you want to generate a record in a table of a third system (which you mapped via Dbret), generates a new instance in Gxflow. If so, I believe it can be done in two ways:

1. Webnotification
2. Bank trigger or Webservice

If it is done via webnotification, you must take into account that the browser must be active (receiver) so that the action of generating a new instance is performed. To fulfill a possible need not to be with the browser active, you can create a routine from time to time check if there is any new record that did not generate the instance

The second solution I think is simpler, but I do not know if it is feasible, because you will need to maintain the silt of the third system, either creating a Rigger in his bank or calling a WS your.

I hope I’ve helped, anything at contact at [email protected]