Order Express Formulas - Revision history

Gwilliams at 21:28, 2 February 2021

2021-02-02T21:28:00Z

2019-05-03T13:33:31Z

‎Product Token Value

2019-05-03T13:31:32Z

‎Products

2018-05-04T12:23:09Z

‎Special Style Options for a Given Category

2018-05-04T12:12:50Z

‎Style Option Selection Count

2018-05-04T12:12:21Z

‎Special Style Options for a Given Category

2018-05-04T11:06:48Z

‎Special Style Options for a Given Category

2018-05-03T22:06:33Z

‎Special Modification

2018-05-03T22:00:51Z

‎Special Style Options for a Given Category

2018-03-19T15:29:11Z

‎Number (Decimal)

← Older revision		Revision as of 21:28, 2 February 2021
Line 68:		Line 68:

	The value for <code>[atoms]</code> is a comma separated list of atoms to test against. Returns the number <code>[atoms]</code> that return true. The value of <code>[count_greater_or_equal_to]</code> changes the return type of this atom into a boolean, where the result is true if the number of <code>[atoms]</code> is greater or equal to the value supplied. Atoms that use the <code>TOKEN:(,)</code> format are not supported in the list of atoms.		The value for <code>[atoms]</code> is a comma separated list of atoms to test against. Returns the number <code>[atoms]</code> that return true. The value of <code>[count_greater_or_equal_to]</code> changes the return type of this atom into a boolean, where the result is true if the number of <code>[atoms]</code> is greater or equal to the value supplied. Atoms that use the <code>TOKEN:(,)</code> format are not supported in the list of atoms.
		+
		+	==== Length ====
		+
		+	Tokens: <code>LENGTH:</code>, <code>(</code>, <code>,</code>, <code>)</code>
		+
		+	Format: <code>LENGTH:([atoms])</code>
		+
		+	The value for <code>[atoms]</code> is a comma separated list of atoms lengths to add together.

	==== Maximum Value ====		==== Maximum Value ====

@@ Line 339: / Line 339: @@
 Format: <code>P:[token]:[value]</code>
-When evaluating against a <code>QuoteProductMod</code>, gets the result from the product the modification is attached to by evaluating the <code>[token]</code> and <code>value</code> specified.
+When evaluating against a <code>QuoteProductMod</code>, gets the result from the product the modification is attached to by evaluating the <code>[token]</code> and <code>[value]</code> specified.
 === Product Lines and Options ===

← Older revision		Revision as of 13:31, 3 May 2019
Line 332:		Line 332:

	The value for the <code>[modification_category_display_id]</code> parameter should match the <code>ModificationCategoryDisplayID</code> in the <code>ModificationCategories</code> table. Returns true of the product being evaluated has any modifications attached to it which match the specified modification category.		The value for the <code>[modification_category_display_id]</code> parameter should match the <code>ModificationCategoryDisplayID</code> in the <code>ModificationCategories</code> table. Returns true of the product being evaluated has any modifications attached to it which match the specified modification category.
		+
		+	==== Product Token Value ====
		+
		+	Tokens: <code>P: :</code> or <code>Product: :</code>
		+
		+	Format: <code>P:[token]:[value]</code>
		+
		+	When evaluating against a <code>QuoteProductMod</code>, gets the result from the product the modification is attached to by evaluating the <code>[token]</code> and <code>value</code> specified.

	=== Product Lines and Options ===		=== Product Lines and Options ===

@@ Line 395: / Line 395: @@
 ==== Special Style Options for a Given Category ====
-Tokens: <code>S: and A:</code> or <code>StyleOption: and Special:</code>
+Tokens: <code>S: and A:</code> or <code>StyleOptionCategory: and Special:</code>
 Format: <code>S:[style_option_category_display_id]:A:?</code> or <code>S:[style_option_category_name]:A:?</code>

@@ Line 427: / Line 427: @@
 Format: <code>N:[style_option_category_display_id]</code> or <code>N:[style_option_category_name]</code>
-The value for the <code>[style_option_category_display_id]</code> parameter should match the <code>StyleOptionCategoryDisplayID</code> in the <code>StyleOptionCategories</code> table. The value of <code>[style_option_category_name]</code> should match the <code>Name</code> in the <code>StyleOptionCategories</code> table.
+The value for the <code>[style_option_category_display_id]</code> parameter should match the <code>StyleOptionCategoryDisplayID</code> in the <code>StyleOptionCategories</code> table. The value of <code>[style_option_category_name]</code> should match the <code>ShortName</code> in the <code>StyleOptionCategories</code> table.
 === Tags ===

@@ Line 399: / Line 399: @@
 Format: <code>S:[style_option_category_display_id]:A:?</code> or <code>S:[style_option_category_name]:A:?</code>
-To check if a special style option is selected for a given category, use the format <code>S:[style_option_category_display_id]:A:?</code> or <code>S:[style_option_category_name]:A:?</code>. The value of <code>[style_option_category_name]</code> should match the <code>Name</code> in the <code>StyleOptionCategories</code> table. In the context of pricing, this will always be false, since the quote item being run through the formula helper is a product or a mod, and not a style option.
+To check if a special style option is selected for a given category, use the format <code>S:[style_option_category_display_id]:A:?</code> or <code>S:[style_option_category_name]:A:?</code>. The value of <code>[style_option_category_name]</code> should match the <code>ShortName</code> in the <code>StyleOptionCategories</code> table. In the context of pricing, this will always be false, since the quote item being run through the formula helper is a product or a mod, and not a style option.
 === Style Options and Selections ===

@@ Line 387: / Line 387: @@
 ==== Special Modification ====
-Tokens: <code>A:P:</code> or <code>Special:Modification:</code>
+Tokens: <code>A:D:</code> or <code>Special:Modification:</code>
 Format: <code>A:D:?</code>

@@ Line 571: / Line 571: @@
 <code>%</code> - Modulo
-<code>*U</code> - Multiply and Apply Ceiling on the Product
+<code>*U</code> - Multiply and Apply Ceiling to the Product
-<code>/U</code> - Divide and apply Ceiling on the Quotient
+<code>/U</code> - Divide and Apply Ceiling to the Quotient
 <code><</code> - Less Than
@@ Line 592: / Line 592: @@
 <code>??</code> - Second Value if First is Less Than or Equal To Zero
 === Boolean ===