2
Vote

think I found an issue with F&L datasource and url parameters

description

If i use the F7L datasource and I have an url parameter for instance 'foo;
 
and I use a filter for example
 
Title = @url_foo
 
i get the following error
 
A critical error has occurred.
Cannot find column [@url_foo]
 
the same setup works if I use an older query to get my user defined table data
 
SELECT
dbo.UserDefinedRows.UserDefinedRowId, Data1.FieldValue AS Title, Data2.FieldValue AS Summary
FROM
dbo.UserDefinedData AS Data1
INNER JOIN
dbo.UserDefinedFields AS Fields1 ON Data1.UserDefinedFieldId = Fields1.UserDefinedFieldId
INNER JOIN
dbo.UserDefinedRows ON Data1.UserDefinedRowId = dbo.UserDefinedRows.UserDefinedRowId
INNER JOIN
dbo.UserDefinedData AS Data2 ON dbo.UserDefinedRows.UserDefinedRowId = Data2.UserDefinedRowId
INNER JOIN
dbo.UserDefinedFields AS Fields ON Data2.UserDefinedFieldId = Fields.UserDefinedFieldId
WHERE
(Fields1.FieldTitle = 'Title')
AND (Fields.FieldTitle = 'Summary')
AND (dbo.UserDefinedRows.ModuleId = 713) AND (Data1.FieldValue like @url_foo)
 
but this is not the most optimal query so I was hoping to use the reports f&l datasource but so far nu luck with url parameters

comments

hanivic505 wrote Mar 18 at 12:10 PM

i also had this error on dnn 7.0.3 and reports module version 05.05.00 any luck to solve this issue or i'm doing things the wrong way