Individual skill
orchardcore-data-formulas
Skill for the formula language and filters of Orchard Core Data Pipelines Core. Covers formula syntax, operators and precedence, missing values and type rules, the full catalog of data pipeline formula functions (text, number, date, logical and aggregate) with signatures, using formulas from code with ExpressionCompiler, CompiledExpression, Aggregates and DataPipelineFormulas, adding or replacing formula functions with ExpressionFunction.CreateScalar, CreateAggregate, AddExpressionFunction, IExpressionFunctionProvider and IExpressionFunctionCatalog, the DataFilterOperator filter operators, the Filter rows transform, source-side row filtering, DataFilterPredicates, and how a data source applies query conditions with DataCondition, DataConditions.Keys, DataConditions.DateRange and IsJoinKey. Use it for data pipeline formulas, calculated fields, custom formula functions, data source filters, or pushing filter conditions into a custom data source.
src/CrestApps.AgentSkills/orchardcore/orchardcore-data-formulas/SKILL.md
Source commit d86d04f234b1b2bd8145368a2544490f9d557596
What was checked
- Matches the observed repository HEAD
- Yes
- Scanner rules are current
- Yes
- Repository scan complete
- No
- Skill scan complete
- No
- Observed behavior
- Instructions only
- Last checked
- Nov 6, 2026
These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.
Install this skill
Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.
An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.
Repository context
- Repository stars (not skill ratings)
- 13
- Repository last updated
- Oct 21, 2026
- License
- MIT
Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.
- agent-skills Repository topic
- ai Repository topic
- ai-agents-framework Repository topic
- dotnet Repository topic
- mcp Repository topic
- mcp-server Repository topic
- orchardcore Repository topic
- data Derived category
Files and excerpt
File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.
Browse files
Read excerpt
# Orchard Core Data Formulas and Filters
The Data Pipelines Core feature (Orchard Core 4.0) includes a formula language, used by the **Filter rows** and **Add calculated fields** steps of data pipelines (see `orchardcore-data-pipelines`) and by features such as reports, and the filter operators that consumers offer to data sources (see `orchardcore-data-sources`). A formula computes a value from a row, such as `[Price] * [Quantity]` or `UPPER(TRIM([Country]))`.
Code lives in the `OrchardCore.DataSources.Expressions` and `OrchardCore.DataSources` namespaces (packages `OrchardCore.DataSources.Core` and `OrchardCore.DataSources.Abstractions`, version `4.*`). Register functions in a module that depends on `OrchardCore.DataPipelines.Core`, or in a `[RequireFeatures("OrchardCore.DataPipelines.Core")]` startup.
## Syntax
| Element | Syntax |
|---------|--------|
| Field | Technical name in brackets, `[TitlePart.Title]`. A `]` in a name is doubled: `[Size [cm]]]` for `Size [cm]`. |
| Text | Single or double quotes, `'CA'` or `"CA"`. Double a quote to escape it: `'It''s'`. |
| Number | Digits with a dot, `42`, `0.25`. Without a dot it is an integer. |
| Constants | `TRUE`, `FALSE`, `NULL` |