A Custom Menu item should only be enabled/visible when a specific field genuinely has a value, but standard SQL-style conditions like `MINIMUM_QTY IS NOT NULL` or `MINIMUM_QTY <> NULL` aren't accepted as valid Custom Menu condition syntax.

Q: A Custom Menu item should only be enabled/visible when a specific field genuinely has a value, but standard SQL-style conditions like `MINIMUM_QTY IS NOT NULL` or `MINIMUM_QTY <> NULL` aren't accepted as valid Custom Menu condition syntax.

Use a wildcard-match condition instead: MINIMUM_QTY % — a bare field name followed by a percent sign, with no equals sign — to mean 'this field matches any value.' This achieves the same 'only show this menu item when the field has a value' behavior, just using the Custom Menu condition mechanism's own specific wildcard-based syntax rather than standard SQL NULL-comparison operators, which aren't supported in this specific context.

Answer

Use a wildcard-match condition instead: MINIMUM_QTY % — a bare field name followed by a percent sign, with no equals sign — to mean 'this field matches any value.' This achieves the same 'only show this menu item when the field has a value' behavior, just using the Custom Menu condition mechanism's own specific wildcard-based syntax rather than standard SQL NULL-comparison operators, which aren't supported in this specific context.

← Browse Developer Studio, deployment, and upgrades questions