Namespace LemonEdge.API.Entities.Reporting
Classes
Chart
DataTemplate
DataTemplateAttachment
Dataset
DatasetQueryableItem
DatasetQueryableItemFieldInfo
DatasetQueryableItemJoin
DatasetShortcut
DatasetShortcutOverride
DevExpressReport
ExpressReport
ExpressReportDataSet
ExpressReportDataSetParameter
ExpressReportExportFormatHelper
ExpressReportRelationship
ExpressReportRelationshipColumn
FilterDescriptor
Pivot
PivotFieldInfo
QueryRunner
QueryRunnerStep
QueryRunnerStepParameter
Report
ReportDevExpressHelper
SQLAssembly
SQLFunction
SQLTypeWrapper
SQLWrapper
SQLWrapperChain
SQLWrapperChainLink
SQLWrapperDependant
SQLWrapperResult
SQLWrapperStat
SSRSReport
SSRSReportExportFormatHelper
Helps with the various ssrs report file types
VennSet
VennSetQueryableItem
VennSetQueryableItemFieldInfo
VennSetQueryableItemParam
Interfaces
IChart
The system entity for a Chart, which is displays data from a IPivot and in turn a ISQLWrapper
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/charts/intro.html for more information
IDataTemplate
The system entity for data templates which can be used when exporting data into excel
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/data-templates/intro.html for more information
IDataTemplateAttachment
The system entity for a Template Attachment, which holds the file to use as a template for the exported data
See https://help.lemonedge.com/excel-templates/ for more information
IDataset
The system entity for a DataSet, which is used for dynamically creating reports for use throughout the system
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/datasets/intro.html for more information
IDatasetQueryableItem
The system entity for a DataSet Queryable Item, which belongs to a IDataset
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/datasets/queryable-items-view.html for more information
IDatasetQueryableItemFieldInfo
The system entity for a DataSet Queryable Item field, which belongs to a IDataset and IDatasetQueryableItem
This ties a field from a queryable item to its definition in a ISQLTypeWrapper against the SQL Wrapper for this dataset. This way the system knows which queryable item field should be described by which result column in the sql
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/datasets/columns-view.html for more information
IDatasetQueryableItemJoin
The system entity for a DataSet Queryable Item Join, which belongs to a IDataset and IDatasetQueryableItem
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/datasets/queryable-items-view.html for more information
IDatasetShortcut
The system entity for a query shortcut, which is used for dynamically enhancing datasets
IDatasetShortcutOverride
IFilterDescriptor
The system entity for filter descriptors, which is used in IDataset filters, and other system filters
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/datasets/where-filters-view.html for more information
IPivot
The system entity for a pivot entity, which is capable of taking any sql wrapper of data and pivotting it dynamically
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/pivots/intro.html for more information
IPivotFieldInfo
The system entity for a pivot field info entity, which belongs to a pivot definition
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/pivots/design-view.html for more information
IQueryRunner
The system entity for a Query Runner, which allows each result of a query to be run against a QueryRunHandler
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/query-runners/intro.html for more information
IQueryRunnerStep
The system entity for a Query Runner Step, which takes the result of a IQueryRunner and processes it
See https://help.lemonedge.com/query-runners/ for more information
IQueryRunnerStepParameter
The system entity for a Query Runner Step Parameter, which provides the parameter value for the IQueryRunnerStep
See https://help.lemonedge.com/query-runners/ for more information
IReport
The system entity for a base report. This is the main report base. All report entities inherit from this
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/reports/intro.html for more information
IReportBase
Any LemonEdge entity interface that inherits this, means it is acquires all the functionality of a report and can be used in IQueryRunner
See https://help.lemonedge.com/reports/ for more info
IReportDevExpress
The system entity for a dev express report
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/reports/express.html for more information
IReportExpress
The system entity for an express report
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/reports/express.html for more information
IReportExpressDataSet
The system entity for an express report data
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/reports/express.html for more information
IReportExpressDataSetParameter
The system entity for an express report data parameters
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/reports/express.html for more information
IReportExpressRelationship
The system entity for an express report relationship
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/reports/express.html for more information
IReportExpressRelationshipColumn
The system entity for an express report relationship column
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/reports/express.html for more information
IReportSSRS
The system entity for a ssrs report
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/reports/ssrs.html for more information
ISQLAssembly
The system entity for clr sql assemblies which can be used in IDataset and ISQLWrapper sql
See https://help.lemonedge.com/help/settings/enterprise-tools/sql-functions/intro.html for more information
See https://docs.microsoft.com/en-us/sql/relational-databases/clr-integration-database-objects-user-defined-functions/clr-user-defined-aggregate-invoking-functions?view=sql-server-ver15 for information about sql clr functionsISQLFunction
The system entity for clr sql functions which can be used in IDataset and ISQLWrapper sql
See https://help.lemonedge.com/help/settings/enterprise-tools/sql-functions/intro.html for more information
See https://docs.microsoft.com/en-us/sql/relational-databases/clr-integration-database-objects-user-defined-functions/clr-user-defined-aggregate-invoking-functions?view=sql-server-ver15 for information about sql clr functionsISQLTypeWrapper
The system entity for a sql type wrapper, which indicates the parameters and columns of the parent sql wrapper it belongs to
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/sql-wrappers/columns.html and https://help.lemonedge.com/help/enterprise-data-tools/reporting/sql-wrappers/parameters.html for more information
ISQLWrapper
The system entity for a sql wrapper, which wraps custom (or system generated) sql and defines its schema both of parameters and results for integration and use with our query tools
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/sql-wrappers/intro.html for more information
ISQLWrapperChain
ISQLWrapperChainLink
ISQLWrapperDependant
ISQLWrapperResult
The default complex type that can always be used for executing any SQL Wrapper and retrieving the results
The helper class SQLWrapperInterpretor can be used to evaluate and interrogate the results held in this class
Any sql wrapper can be executed using GetSQLResults<T>(Guid, string, string)
ISQLWrapperStat
IVennSet
The system entity for a VennSet, which is used for dynamically combining multiple sets of data together
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/venn-sets/intro.html for more information
IVennSetQueryableItem
The system entity for a VennSet Queryable Item, which belongs to a IVennSet
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/venn-sets/queryable-items-view.html for more information
IVennSetQueryableItemFieldInfo
The system entity for a VennSet Queryable Item field, which belongs to a IVennSet and IVennSetQueryableItem
This ties a field from a queryable item to its definition in a ISQLTypeWrapper against the SQL Wrapper for this vennset. This way the system knows which queryable item field should be described by which result column in the sql
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/venn-sets/columns-view.html for more information
IVennSetQueryableItemParam
The system entity for a VennSet Queryable Item Param, which belongs to a IVennSet and IVennSetQueryableItem
See https://help.lemonedge.com/help/enterprise-data-tools/reporting/venn-sets/queryable-items-view.html for more information
IWrapper
Indicates this item wraps another entity, held by WrappedItem
This is used for entities that want to display a pivot of options within a grid. The logic for this is all taken care of using this and EntityHasPivotAttribute
See API.Entities.IGLAccount for an exampleEnums
ChartCombine
ChartSeriesFrom
ChartTotalPosition
ChartType
DataSetSetOperatorMethod
DataTemplateType
The types of templates that IDataTemplate supports
DatasetShorcutAvailability
ExpressReportExportFormat
FilterLogicalCompositeOperator
PivotAxis
PivotFieldDateFormat
PivotFieldType
QueryRunnerMergOption
QueryRunnerStepDocument
QueryRunnerStepStorage
SQLFunctionType
The types of sql functions that ISQLFunction supports