Support of Special Keywords in SQL report macros Completed

Yannick Fetet

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

Comments

3 comments

Date Votes
  • Comment author
    SSP Automation
    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]
    0
  • Comment author
    Rasmus Jensen

    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?

    0
  • Comment author
    SSP Automation
    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 :-)
    0

Please sign in to leave a comment.