Trigger user query with variable with Macro Universal Function

Answered

Jay Cheah

• June 25, 2016 07:23

 I want to trigger a user-query that contains variables after a user has tabbed away from a UDF. 

At the moment, I can successfully trigger the user-query, that's simple enough, but I cannot seem to transfer the data that the user has just keyed into the UDF into the user-query input box

The user-query looks like the following:

Declare @JobNum varchar(20)
Set @JobNum = (select min(S0.U_CBS_Job_No) from ORDR S0 Where S0.U_CBS_Job_No >= [%0])

SELECT DocNum, CardName, U_CBS_JobAddress, U_CBS_Job_No FROM ORDR WHERE U_CBS_Job_No = @JobNum

Vote

0

• Official comment

  

  Naama Aharoni

  • June 27, 2016 15:23

  Hi Jay,

  You should create this query as an SQL report UF which should provide with more formatting options. One of them is to define the [%0] variable input as an SQL query - that query should be taking the value of the UDF.

  There is no need for a macro in that case. You can link the SQL Report UF as the result of your validation.

  Thanks, Naama

Please sign in to leave a comment.