Table of Contents

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

You should find some code examples in this demo App

  • ...

More links: Description of the feature on 2sxc docs

History

  1. Introduced in 2sxc ??.??