PRESCRIBE

The PRESCRIBE function evaluates answer rules and returns items based on these rules.

Syntax

PRESCRIBE(table, [rowsSelector, colsSelector, condition, out])

Argument name	Description
table Required	Table to evaluate containing the prescription rules. See below.
rowsSelector Optional	Selector of rows. All rows by default.
colsSelector Optional	Selector of columns. All columns by default.
condition Optional	matchall Only adds an item if it is contained in all matching rows. matchany (default) Adds an item if it is contained at least in a matching row.
out Optional	Also includes the results in a list.

Table syntax:

Column name	Description
answer Required, Multiple	Answer rules to evaluate.
mode Optional	include (default) Includes the items (if not excluded). exclude Excludes the items.
weight Optional	Assigns points to items that will be used to order them.
rule Optional	Selects items based on attribute rules.
<other columns> Required	Any other column is treated as items holder.

Examples

Example 1

mytable

PRESCRIBE(mytable) If a1 is true, returns sku1 If a2 is true, returns sku2 and sku3 If a1 is true and a2 is true, returns sku1, sku2, sku3

Example 2

mytable

PRESCRIBE(mytable) If a1 is true and a2 is true, returns sku3, sku1, sku2. Note sku3 is returned in the first place because it has more weight as it appears in two matching rules.

Example 3

mytable

We can also use formulas that will be evaluated.

Example 4

mytable

We can use multiple answer columns. In this case, answer columns in each row have to be evaluated as true for the rule to be met.

PRESCRIBE(mytable) If a1 is true and a2 is true, returns sku2 If a1 is true and a3 is true, returns sku1

Example 5

mytable

PRESCRIBE(mytable) If health_bones is true and heath_sleep is true, returns sku2 and sku1. Note sku2 has more priority because of its assigned weight. If health_bones, heath_sleep, and allergy_fish are true, returns only sku2 because sku1 will be excluded according to rule 3.

Example 6

mytable

PRESCRIBE(mytable, ':', ':', 'matchall') If a1, a2, and a3 are true, it returns sku2 because it is the unique item that appears in all matching rules according to the matchall condition. If a1, and a4 are true, it returns nothing because there are no items that appear in all matching rules.

Example 7

PRESCRIBE(mytable, ':', ':', 'matchall') If a1 and a3 are true, it returns those products with tag cleanser that have size greater than 10. If a2 and a3 are true, it returns those products with tag serum or essential oil, that have size greater than 10.