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