Querystring not working

[perezandres]

Is querystring token working for DNN 9.2.2?
I have this query:
SELECT '[QUERYSTRING:Fecha]',Username, Email, CreatedOnDate FROM Users WHERE CreatedOnDate>='[QUERYSTRING:Fecha]'
I use the URL http://MyDomain/MyURL?Fecha=2018/11/01 but querystring token Fecha is empty.

Maybe I'm doing something wrong?

Thank you

[richard-edwards]

What version of SQLView Pro are you using?

Can you turn debug on in the advanced settings in the report set and let me know what the debug output looks like.

Your statement looks fine to me.

[perezandres]

Version 5.0.0: it's the last one, isn't it?
I've enabled debugging but I don't kown where to get its output.

Thank you for your help!

[richard-edwards]

Once you've enabled debug in report set advanced options, just run the report and you should see a sql statement at the bottom of the module output. It is usually highlighted unless your css stylesheets are overriding the rules I use for that.

[perezandres]

OK, now I've seen it ;-)
It just shows the query, without the data that should come from the qs:
SELECT '',Username, Email, CreatedOnDate FROM Users WHERE CreatedOnDate='' ORDER BY CreatedOnDate DESC

[richard-edwards]

Hmm, and you are sure your url has that querystring exactly?

[perezandres]

This is the querystring I've just copied from my URL: ?Fecha=2018/11/01

[richard-edwards]

Ok, leave it with me and I'll check into it. I'm just setting up a brand new dev laptop and have aways to go before it's fully configured for development. I'll aim at getting it looked into by the weekend if I can.

[perezandres]

OK, don't worry ;-)