App Variant Creation: Needs Validation on Parameter Values

The customer reports that the "Lookback Days" field within the Assortment Advisor App's settings allows non-numeric or empty values. The "Run" and "Save" buttons remain active, enabling users to proceed with invalid input. When a variant is executed under these conditions, it results in a QueryStatus.FAILED_WITH_ERROR with the message: "001003: 1003: SQL compilation error: syntax error line 1 at position 77 unexpected ','".

What is happening or what is needed
The 'Lookback Days' field in the Assortment Advisor App's settings accepts non-numeric or empty values, leading to a SQL compilation error when the variant is run.
Walk us through it step by step
1. Go to My Apps > Assortment Advisor App > App Settings. 2. Click 'New Variant.' 3. In the 'Lookback Days' field, enter a non-numeric value (or leave it empty). 4. Notice 'Run' and 'Save' remain enabled. 5. Click 'Run' β€” the variant executes despite invalid input and fails with an error.

Please authenticate to join the conversation.

Upvoters
Status

Under Consideration

Board

My Apps

Date

11 days ago

Subscribe to post

Get notified by email when there are changes.