All DataSource Objects in 2sxc / EAV

you are here (click to zoom) - discover the stack

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.
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	Relationships	Get all related child entities	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.
Csv	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
CustomDataSource	(base)	Base Class for custom data DataSources
ItemFilterDuplicates	Logic	Find and remove OR retrieve duplicate items
LanguageModeler	Modify	Restructure imported data to be multi-language	v11.20
OwnerFilter	Filter	Get items created by specific user
Pages	CMS Data	All the pages of the current site	v15
Paging	Logic	Page through items
Parents	Relationships	Get all related parent entities	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
Sites	CMS Data	All the sites of the current system	v15
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]
SystemStack	Get Data	All the Settings / Resources of the current System and App	v15
TreeModeler	Modify	Restructure imported data to have tree-relationships	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	Ver.
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
Features	(system)	All the features in the the current system	v15
Licenses	(system)	All the licenses in the the current system	v15
MetadataTargetTypes	(system)	All the Metadata Target Types in the EAV	v15
QueryInfo	(system)	Provide debug info when creating Queries
Scopes	(system)	All the sites of the current system	v15
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