Home › Discussions › Questions & Answers › Ensuring Parameter Anchors Exist in Main SQL
Customer · · Questions & Answers · 5 replies
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?
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.
If a developer needs to insert dynamic SQL text multiple times within the report’s main SQL, is that supported with a single anchor?
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.
If we want to enable the ‘Multiple Values’ checkbox for a parameter, is there any restriction on the anchor type we can use?
Yes, the multiple values functionality is only available for parameters using anchor styles `1=1` or `&lexical`, not for `:bind` anchors.
Sign in with LinkedIn or Google to take part.
