Fork me on GitHub
2sxc 9.0 for DNN 7 to 9
Website Builder, Content Manager, App-System: free and amazing - done your way
You are here: Home  >  Docs  >  Feature

DnnFormAndList DataSource

Introduced in Version 07.00.00
Demos of this feature
A data source which will deliver Form And List data (formerly known as UdT or User Defined Table) to your templates, razor, tokens or WebAPI / JSON. 

 

This is what it looks like in the Visual Query Designer

 

Streams in the DnnFormAndList DataSource

  • In - non expected
    • It expects no In-Streams. If you add any, you can use them in the queries (for example to provide configuration)
  • Out - Default only
    • Default - containing the result of the Form-and-List internal Database (for the selected Module)

Configuration of the DnnFormAndList DataSource

In-Page instructions should suffice, read that :)

  1. Title - put anything you want here
  2. FnL Module Id - either the Module-ID like 402 or a Token which will deliver the ModuleId like [In:Default:ModuleId]
  3. Title-Field Name
  4. Content-type-Name

Special Behavior of the Form and List DataSource

The original module allows field (column) names with spaces and other special characters. Because this would often cause problems when templating, this DataSource will automatically change the names by replacing spaces with "_" characters. The FnL internal columns (usually prefixed with UdT) sometimes also get corrected names. The easiest way to discover what they are is to look at the test-JSON. 

 

Tags for this feature

2serve . 2invent . 2create is 2be.