Happy New Year Everyone!
I need help on this area.
I have a SQL Store Procedure to retrieve from an Customer Aging with the paramter of @ReportDate. After enter the @ReportDate, the return show as query which show me customer aging.
How do I present in on the AwareIM Report?
From the user guide:
"EXEC_SP Action:
This action allows execution of a database stored procedure. You can initialise input parameters of the stored procedure with rule expressions and you can also capture the output parameters of the stored procedure in the attributes of business objects. If the stored procedure returns a “result set” (the result of the SQL SELECT statement) you can capture returned records as instances of business objects, which can then be placed in the Context or returned by a query. The stored procedure can be in the native Aware IM database or in the external database.
EXEC SP ‘procAlertGet’ WITH ‘@alerID’=1 RETURN Alert"
Can anyone guide me? How do I call back to AwareIM?
Many thanks....