...
- Files that contain one or more rules
- Sub folders containing individual or bundled rules
Rules File Naming Conventions
Give each rule a short, meaningful name. All rules files must have a .drl file extension. Rule files without the extension are not picked up for forecasting.
| No Format |
|---|
<rule_name>.drl |
Where Rules Are Applied
Rules are available to be applied during packing and during each phase of the forecasting process.
Script File Extension Requirements
Rules only check SQL scripts with the following extensions by default: .sql, .dml, .ddl
To optionally add other SQL script extensions for other file types to be checked by SqlRules, change the sqlRules.supportedScriptExtensions property in the daticaldb.properties file, which is located in the root directory for the project (<project>).
...
| Code Block |
|---|
sqlRules.supportedScriptExtensions=.pkg,.trg,.prc,.proc,.ddl,.sql,.dml |
Where Rules Are Applied
Rules are available to be applied during packing and during each phase of the forecasting process.
Packaging Rules
Rules in the SqlRules directory are applied by Deployment Packager when packaging SQL scripts into changesets. They are not part of the forecasting process.
...
If you have many projects that all use the same set of rules, you can optionally centralize the rules by creating a rules repository in source control.
See this page for more details: How to Create a Common Rules Repository