DNN

Snippets

03

SQL Query

SELECT R.UserDefinedRowId,
F.FieldTitle,
D.FieldValue
FROM dbo.UserDefinedRows R
LEFT OUTER JOIN dbo.UserDefinedData D on R.UserDefinedRowId = D.UserDefinedRowId
INNER JOIN dbo.UserDefinedFields F on D.UserDefinedFieldId = F.UserDefinedFieldId
WHERE R.ModuleId = @ModuleId
ORDER by R.UserDefinedRowID

DNN Function

UserDefinedTableController.GetDataSet(ModuleID)

Posted in: DNN

Comments

There are currently no comments, be the first to post one!

Post Comment

Only registered users may post comments.