• Basics
  • Abyss
  • Web APIs
  • C# & Razor
  • .net API
  • JS & TS API

    Show / Hide 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
    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

    1. Introduced in 2sxc ??.??
    • Improve this Doc
    Back to top Generated by DocFX