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 |
App | Get Data | Provides each content-type on the out-stream |
AppRoot | Get Data | This is the root cache node per App |
AttributeFilter | Modify | Removes properties/attributes. |
AttributeRename | Modify | Renames properties/attributes. |
CacheAllStreams | Caching | Cache all streams passing through |
Children | Get Data | Get all related child enties v12.10 |
CmsBlock | 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. |
CsvDataSource | Get Data | Get data from a CSV-file |
DataSourceBase | (base) | The base class for all DataSources |
DataTable | Get Data | Base class for coding using .net Tables |
EntityIdFilter | Filter | Get one or more items with specific Ids |
EntityTypeFilter | Filter | Get items of a specific content-type |
Error | (internal) | Generate an error for testing VisualQuery debug |
ExternalData | (base) | Base Class for external data DataSources |
ItemFilterDuplicates | Logic | Find and remove OR retrieve duplicate items |
LanguageModeler | Modify | Restructure imported data to be multi-language new in v11.20 |
OwnerFilter | Filter | Get items created by specific user |
Paging | Logic | Page through items |
Parents | Get Data | Get all related parent enties v12.10 |
PassThrough | (internal) | Do-Nothing DataSource mainly for testing |
PublishingFilter | 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. |
Query | (internal) | Internal system to run Queries |
QueryRun | Sub-Query | Run another query and use results |
RelationshipFilter | Filter | Filter items with a specific relationship |
Serialization Configuration | special | Control created JSON content for security and optimization |
Shuffle | Logic | Shuffle/randomize item order |
Sql | 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. |
StreamFallback | 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. |
StreamMerge | Logic | Merge multiple streams into one |
StreamPick | 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] |
TreeModeler | Modify | Restructure imported data to have tree-relationships new in v11.20 |
ValueFilter | Filter | Filters by value |
ValueSort | 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. |
DnnSql DataSource | Get Data | Get data from the Dnn Database |
DnnUserProfile | 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 |
Apps | (system) | Get all Apps in a Zone/Site |
Attributes | (system) | Get all Attributes of a Content-Type |
Block | (system) | Helper to correct data with Templates |
ContentTypes | (system) | Get all ContentTypes of an App |
QueryInfo | (system) | Provide debug info when creating Queries |
Zones | (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 ??.??