The condition builder options allow you to create and use dynamically predefined values for the specified types of columns, fields, tables, or condition operators.

The main use case of this functionality is filtering by date and time. The options facilitate filtering by using predefined values, such as "Yesterday", "Last Week", "Next Month" and others.

In the URL, options are displayed as opt:{option_id}.

Create an option

To create a new option, complete the steps below:

  1. Navigate to System Settings → Condition Builder → Options.
  2. Click New and fill in the fields.
  3. Click Save or Save and exit to apply the changes.

Condition Builder Option form fields

FieldMandatoryDescription
TitleY

Specify the option name. It will be displayed in the condition builder values choice list.

ActiveNSelect this checkbox to make the option active. If not selected, this option is not displayed in the condition builder values choice list.
Field typeYSpecify a column type to which this option is applicable. If not specified, then the option will be applicable to all field types created in the system.
Refer to tableN

Specify the table that the selected field in the condition builder will refer to.

This field appears when the Field type field value is Reference or List.

Use for fieldNSpecify a field to which this option is applicable. If not specified, then the option applies to all columns.
Use in tables NSpecify tables to which this option is applicable. You can specify more than one table. If not specified, the option applies to all tables.
Use with operatorsN

Specify condition operators to which this option is applicable. You can specify more than one type. If not specified, the option applies to all operators supported.

To find a list of operators supported by options, navigate here:

System Setting → Condition Builder → Operators

To add new operators to this list, contact the vendor.

OrderNSpecify an option order. If more than one similar option are created, they will be applied according to the specified value in ascending order.
ScriptN

Specify a script implementing the option logic.

You can use Script Include when defining option logic. To do so, complete the following steps:

  1. Create a script include.

    dateWeekAfter
    function getDateWeekAfter() {
	const simpleDateTime = new SimpleDateTime();
	simpleDateTime.addDays(7);
	return simpleDateTime.getDate();
}
  2. Import it using the ss.importIncludeScript(name) method.
Importing Script Include
ss.importIncludeScript('getDateWeekAfter');
setResult(getDateWeekAfter());

  • No labels

1 Comment

  1. Dina Baksheeva

    See the Options for the Date and Time Fields article for the full list of the such options delivered out-of-the-box.
    3

© 2019-2024, SimpleOne

https://simpleone.ru