PB 12.5.1 visible property expression breaks querymode
I found that querymode will totally ignore a column in querymode (won't include it in the changed where) if the column has an expression on the visible property where the else results in a 0
Example:
if this expression is on the visible property of a column field:
if( htype = "S" OR upper(left( describe('datawindow.querymode'),1))='Y', 1, 0)
and i type a value in the column field when in querymode, querymode will not include the column and value when the retrieve is done.
To 'fix' - change the visible expression to:
if( htype <> "S" AND upper(left( describe('datawindow.querymode'),1))='N', 0, 1)
now when i type a value in the column field when in querymode, querymode WILL include the column and value when the retrieve is done.
I wasted several hours rebuilding the datawindow trying to figure out why this wasn't working. Hopefully this post will save someone else some time.
I have no idea whether this bug was fixed in 12.5.2 or 12.6.xxxxx
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
12 | |
5 | |
5 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |