score:4

Accepted answer

This is the syntax used in your specific program (Datazen Dataview) to substitute parameters.

So what you're seeing are that the SQL variables @prmFromDTand @prmToDT are being filled with parameters.

Reference:

In previous versions of Datazen, all parameter substitution was done inline. This necessitated the use of quotes to wrap string values (ex. WHERE x = '{{ @Xvalue }}'). While this is still the case for non-DB connections types, it is advised not to do so for DB types. While DB types will automatically unwrap the quotes from around a parameter if the parameter is the only text contained within the quotes, if any other text is present, the query will surely fail. For example, while the above example evaluates to "WHERE x = @p1" something like "WHERE y = 'P001-{{ @Yvalue }}'" will evaluate to "WHERE y = 'P001-@p1'" which is clearly not proper SQL parameter syntax.

Source:

https://social.technet.microsoft.com/wiki/contents/articles/32028.datazen-data-view-parameter-replacement-functions.aspx

Also reference on how to use parameters in datazen and the resulting syntax: https://christopherfinlan.com/2015/06/10/how-to-enable-user-activity-reporting-on-your-datazen-dashboards/


More questions

More questions with similar tag