Home › Discussions › Questions & Answers › Internal parameters not visible to users

Internal parameters not visible to users

Avatar photoCustomer Questions & Answers 7 replies

I need a parameter that derives a value used internally in the SQL logic, but the user should never see or modify this field on the run window. How do I achieve this invisibility?

7 replies

  • Support Enginatics

    You define this parameter using a negative display sequence number. Negative display sequence numbers are specifically used to define hidden parameters.

  • Avatar photoCustomer

    What is the typical technical use case for such a hidden parameter?

  • Support Enginatics

    They are typically utilized to populate a &lexical anchor with dynamic SQL text before report execution. For example, the AR Transactions and Lines report uses a hidden parameter to dynamically generate a string for revenue account columns.

  • Avatar photoCustomer

    If I am debugging, can I force these hidden parameters to display temporarily?

  • Support Enginatics

    Yes, developers can show these hidden parameters for debugging purposes by setting the profile option ‘Blitz Report Show Hidden Parameters’ to ‘Yes’.

  • Avatar photoCustomer

    If I define a standard visible parameter, but I don’t give it a display sequence number, what happens?

  • Support Enginatics

    If you have multiple entries for the same parameter name (e.g., to insert different SQL text at different positions), only one of them needs the display sequence, parameter type, and LOV setup. Subsequent lines for the same parameter name have the display sequence left blank.

  • You must be logged in to reply to this post.