VERIFIED SOLUTION i

Resolving Portrait Dialogue issue when switching from SQL expression mode to SQL mode and vice versa

Product Feature: Selections
 

Issue

When using the Portrait Dialogue selection designer, switching SQL mode to expression mode deletes changes made in SQL mode.
If you switch a selection around from mode to mode (expression to SQL or SQL to expression), it doesn’t keep the changes made in the other mode.

Cause

This is normal behavior.
When you switch back and forth, going from SQL mode to Design mode, there is a pop-up saying "Current SQL statement will be lost. Continue?"
You will loose any changes you make in SQL mode, and you are warned that this is going to happen.

Resolution

UPDATED: April 30, 2018
If you switch to SQL mode, you should stay in SQL mode.