Query DataSource Syntax

Sherry Collins asked on August 16, 2015 19:03

I have created a custom filter that is connected to a query datasource. I don't seem to be able to use a stored procedure with a custom filter, so I have changed it to inline sql in the datasource webpart.

I was passing a parameter to the stored proc which I now need to include in the in-line sql.

I need to do something like this (except this is not working)

where (NodeAliasPath like '%'##WHERE##'%')

It seems to be evaluating correctly, but the syntax is not correct.

Can someone help me with this.


Recent Answers

Sherry Collins answered on August 17, 2015 21:23

Nevermind. I found the answer. Thanks anyway

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.