Home Discussions Questions & Answers Ensuring Parameter Anchors Exist in Main SQL

Ensuring Parameter Anchors Exist in Main SQL

Avatar photoCustomer September 6, 2024 at 7:24 am

We have new developers creating Blitz Reports, and we need a tool to ensure they are correctly associating parameters with anchors that exist in the main report SQL, or catching typos in the anchor definition. Which report can perform this validation?

Viewing 4 reply threads
  • Author
    Replies
    • Support September 7, 2024 at 10:49 pm  

      Use the Blitz Report Parameter Anchor Validation report. It checks if all parameter anchors exist in the `xxen_report_parameter_anchors` table, ensuring correct linkage.

    • Avatar photoCustomer September 9, 2024 at 7:24 am  

      If a developer needs to insert dynamic SQL text multiple times within the report’s main SQL, is that supported with a single anchor?

    • Support September 10, 2024 at 5:33 pm  

      Yes, the same anchor may be used multiple times inside a report SQL, and Blitz Report inserts the corresponding parameter text for each occurrence at run-time.

    • Avatar photoCustomer September 12, 2024 at 11:36 am  

      If we want to enable the ‘Multiple Values’ checkbox for a parameter, is there any restriction on the anchor type we can use?

    • Support September 13, 2024 at 10:25 am  

      Yes, the multiple values functionality is only available for parameters using anchor styles `1=1` or `&lexical`, not for `:bind` anchors.

Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with: