Anonymous, bureaucrat, administrator
7,528
edits
Changes
→Dynamic Parameter Replacements
// * Examples
[[intParamAdd:1;2;0]] --> Will replace in the SQl statement as 3[[intParamAdd:3;0;2]] --> Will replace in the SQl statement as 1[[intParamAdd:[[LoopCount]];2;0]] --> Will replace in the SQl statement as the current Outer loop count +2[[intParamAdd:[[Internal_LoopCount]];2;0]] --> Will replace in the SQl statement as the current Internal loop count +2
</syntaxhighlight>
As a Keystat can have multiple parameters to replace, specify where in the statement to perform the replacement. To do this add a specific key word to the places in the SQL statement that need to be replaced. This key word is ''[[intParamAdd]]''. When the Keystats engine sees this it will replace it with the required value, as outlined above.
<syntaxhighlight lang="MySQL">
// * Replacement Syntax -> [[intParamAdd:1;2;0]] --> Replace [[intParamAdd]] with 3
// * SQL Statement before replacement
SELECT COUNT(intCCL_292_Id) FROM CCL_292
WHERE dteCCL_292_EndDateTime >= '--parameter[[intParamAdd]]-- 00:00:00'
AND
dteCCL_292_EndDateTime <= '--parameter[[intParamAdd]]-- 00:00:00';
// * SQL Statement before replacement
After the replacement has been calculated there is a final option that can be used. This option allows a key stat to further add to the number generated by the above examples. To use this functionality modify the key word ''[[intParamAdd]]'', outlined above, to be ''[[intParamAdd:X]]''. Replace X with the number you want to add to the dynamic parameter replacement already generated.
<syntaxhighlight lang="MySQL">
// * Replacement Syntax -> [[intParamAdd:1;2;0]] --> Replace [[intParamAdd]] with 3
// * SQL Statement before replacement
SELECT COUNT(intCCL_292_Id) FROM CCL_292
WHERE dteCCL_292_EndDateTime >= '--parameter[[intParamAdd:0]]-- 00:00:00'
AND
dteCCL_292_EndDateTime <= '--parameter[[intParamAdd:1]]-- 00:00:00';
// * SQL Statement before replacement