0

Using @@ in Filters= for NL(Filter)

Hi,

I'm creating an NL(Filters) string. As part of this string, I've also got a Filters= which references user's filters $C$6:$D$10.

One of the user filters is Document No and the required filter is *DNK*

 

But when I add the full Filters= (using SQL data warehouse data source), I'm getting the error message "Must declare the scalar variable "@@"."

 

This doesn't happen using SQL or WS directly to the Business Central database.

 

a) Does anyone know why this error would be showing?

b) Is there a fix for this? Can I specify the "@@" another way?

 

For reference, I've tried to move the *DNK* outside of the Filters= range and hardcoding the filter directly (with the "@@"&) but am still getting the same error.

 

Thanks

0 comments

Please sign in to leave a comment.