All DataSource Objects in 2sxc / EAV
2sxc provides a large set of DataSource objects which either get data from somewhere (SQL, CSV, ...) or modify data on the In and passing it to Out. This page will give you an overview and link you to further sources if you need to know more.
All Public DataSources
These are all the data sources which are either provided in the default installation of 2sxc.
| Data Source | Purpose | Description & Details | Ver. |
| Get Data | Provides each content-type on the out-stream | ||
| Get Data | This is the root cache node per App | ||
| Modify | Removes properties/attributes. | ||
| Modify | Renames properties/attributes. | ||
| Caching | Cache all streams passing through | ||
| Relationships | Get all related child entities | v12.10 | |
| Get Data |
Current Module instance data …Will get the content-items assigned to a Dnn-Module. This is used internally on each view, but can also be used when using module-data to configure a query. | ||
| Get Data | Get data from a CSV-file | ||
| (base) | The base class for all DataSources | ||
| Get Data | Base class for coding using .net Tables | ||
| Filter | Get one or more items with specific Ids | ||
| Filter | Get items of a specific content-type | ||
| (internal) | Generate an error for testing VisualQuery debug | ||
| (base) | Base Class for custom data DataSources | ||
| Logic | Find and remove OR retrieve duplicate items | ||
| Modify | Restructure imported data to be multi-language | v11.20 | |
| Filter | Get items created by specific user | ||
| CMS Data | All the pages of the current site | v15 | |
| Logic | Page through items | ||
| Relationships | Get all related parent entities | v12.10 | |
| (internal) | Do-Nothing DataSource mainly for testing | ||
| Filter |
Filters items the current user shouldn't see …This is part of the "Unpublished-Data" concept. Since each item could be either published or draft, this helps you show the correct ones for the current user based on his edit-rights. It's automatically in the default pipeline, unless you explicitly don't want it. |
||
| (internal) | Internal system to run Queries | ||
| Sub-Query | Run another query and use results | ||
| Filter | Filter items with a specific relationship | ||
| special | Control created JSON content for security and optimization | ||
| CMS Data | All the sites of the current system | v15 | |
| Logic | Shuffle/randomize item order | ||
| Get Data |
Get SQL data as entities …This lets you get data from any SQL data base. It also has powerful script-injection protection, so messy parameters won't hurt it. | ||
| Logic |
Returns the first stream having data …Use this to choose from multiple in-streams which data to show. It will use all the in-streams sorted A-Z, and return the first stream which can deliver data. The remaining streams will not be queried. | ||
| Logic | Merge multiple streams into one | ||
| Logic |
Pick a stream by stream-name…Use this to pick one of multiple in-streams by name. Often used together with the token [Params:ShowDrafts] | ||
| Get Data | All the Settings / Resources of the current System and App | v15 | |
| Modify | Restructure imported data to have tree-relationships | v11.20 | |
| Filter | Filters by value | ||
| Sort | Sorts all items by values |
Dnn DataSources
These are Dnn specific DataSources and won't work on Oqtane.
| Data Source | Purpose | Description & Details |
| Dnn FormAndList | Get Data | Get data from the old FnL
Use old FnL data in 2sxc …Will let you access Form-And-List aka UDT (Universal Data Table) data. Note that this DataSource is in external DLLs and has not been maintained, it probably doesn't work any more. |
| Get Data | Get data from the Dnn Database | |
| Get Data | Get Dnn Users and profiles |
Internal / System DataSources
These data sources are used internally, like for selecting an App in an edit dialog.
| Data Source | Purpose | Description & Details | Ver. |
| (system) | Get all Apps in a Zone/Site | ||
| (system) | Get all Attributes of a Content-Type | ||
| (system) | Helper to correct data with Templates | ||
| (system) | Get all ContentTypes of an App | ||
| (system) | All the features in the the current system | v15 | |
| (system) | All the licenses in the the current system | v15 | |
| (system) | All the Metadata Target Types in the EAV | v15 | |
| (system) | Provide debug info when creating Queries | ||
| (system) | All the sites of the current system | v15 | |
| (system) | Get all Zones (Sites) in an installation |
Demo App and further links
You should find some code examples in this demo App
- ...
More links: Description of the feature on 2sxc docs
History
- Introduced in 2sxc ??.??