UFFE Body and Line Queries with Parameters

Answered

Martin

• September 16, 2016 16:07
• Edited

Hi

I am trying to create an UFFE for a set of orders which meets a particular shipping type and due date, to create an integration to a logistics partner. Ideally i would want to provide a start and end date and the query will return all of the orders between these dates and these will be exported in a single file.

I can't figure out how to pass a parameter into the where clause in the body sql and line sql so that the queries are constrained to the right date range? I tried with the B1 parameters ([%0]) and by setting a @Store variable in the UF that calls the UFFE UF... no luck... Can maybe try writing the query results into a temp table and writing from there?

Any ideas how i can achieve this?

 

Thanks

Vote

2

• Official comment

  

  Thomas

  • September 21, 2016 09:23
  • Edited

  Hi Martin,

  Unfortunately it is not possible to pass parameters to the batch runner / UFFE. Only workaround i can think of is to create a user defined table where you have start date and end date columns. When you create the batch configuration SQL, select the start and end dates from that user defined window. That's not very user friendly, but it'll let you use a date filter.

  To make it more user friendly, you can make a menu item which activates the user defined window, so you don't have to always find it from the huge list in order to change the dates.

  Anyway, this is a great development request and i will mark it down in our development system.

  Best regards,

  Thomas

Please sign in to leave a comment.