Support of Special Keywords in SQL report macros

Completed

Yannick Fetet

• August 26, 2020 10:35

Dears,

It seems that special keywords cannot be used in SQL Report macro scripts.

It would be great to have this in order to reduce the number of macros to display the same report from several documents for example. See attached screenshot (we display a list of documents, linked with a line UDF "procurement number" : and the same query would display the list whatever the source document we execute it, given that we can use a variable like ObjType or Table identifier that allows the filter).

 

 

Or maybe it is already possible and I did not get it right ?

Thanks in advance

Best regards

Vote

2

• 

  SSP Automation

  • August 26, 2020 10:40

  Thank you for your request. It has been scheduled for review by the development team that will get back to you should there be questions.
  (Please note that as we are user-driven we can't guarantee that your request will be met unless it gets many votes and/or fit the product vision)
  Read more about the Feature Request process here
  [Internal Id: 24580]
  
• 

  Rasmus Jensen

  • September 17, 2020 07:37

  As far as I know, this is already possible. In this example (on MSSQL but work the same on HANA it works)

  

   

  The only thing I see different from your screenshot is that I have quotes around the keyword 

  $[BOY_TABLE_IDENTIFIER] >> '$[BOY_TABLE_IDENTIFIER]'

   

  Or am I missing something here?
• 

  SSP Automation

  • September 17, 2020 07:45

  The development team has now completed this request. Expect it to be in the next release of the product. Thank you again for helping us make the product better :-)

Please sign in to leave a comment.