<div class="form-container">
View this form in the client console
1. Select one or more modules
This required form control is used to determine which attributes to display in the condtion builder below. It may either contain SiteMap.DataId or NavigationItems.SystemName values.
2. Build your conditions
The condition builder script below generates SQL which can be processed into any module that accepts it. The IN and NOT IN operator expects a comma-space separated list of values. SQL should be written or reviewed by qualified professionals. This dynamically generated SQL may not perform well and could cause problems for the entire site or even other sites on the same server. The [cp:scripting key='FormState' id='ConditionBuilder' rawdata='true' /] must be used in processing to populate the attribute used in the DefaultValue parameter of this script for the form to support updates.
[cp:scripting key='FormConditionBuilder' id='ConditionBuilder' RequiredFieldErrorMessage='Required!' DefaultValue='cpsys_Constant:FormInfo:ConditionBuilderRawData' ModulesFormItemId='NavItemSystemNames' resultstype='sql' /]
3. Submit to generate SQL
Forms</div>