SQL in Genexus and GxFlow

0

Is it possible to return the result of a SQL query in a Genexus transaction?

I need to create a WorkFlow through Genexus, where using DBRET, I was able to read data from an external DB and now I need to return some information in GxFlow.

I was able to make the flow return all the data through the transactions imported from the external DB, but I need to query each DB item individually and return the result in the gxFlow Inbox.

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

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

Thanks in advance and waiting for answers! Obi

    
asked by anonymous 30.01.2015 / 12:00

1 answer

0

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), it generates a new instance in GXFlow. If so, I understand it can be done in two ways:

  • Webnotification
  • Bank Trigger or Webservice
  • If 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 fill a possible need not to be with the browser active, you can create a routine from time to time to check if there is a new record that did not generate the instance

    The second solution I understand is simpler, but I do not know if it is feasible, as it will have to maintain the slurry of the third party's system, either by creating a trigger on its bank or calling it a WS.

    I hope to have helped, anything in contact in the email [email protected]

        
    10.09.2015 / 13:46