06-24-2015 01:29 PM
When buidling an Advanced Query using the status field i have to enter the search as number 0 through 3 instead of Open, Closed Won, Closed Lost, or Inactive. Is this normal? We are using v17.
06-24-2015 01:34 PM
Yes, why store alpha when a number is simpler. The same reason that False is stored as 0 and True as -1.
06-24-2015 01:38 PM - edited 06-24-2015 01:39 PM
Just wanted to confirm as on our previous ACT 2008 version it was still using the full text for the status field.
06-24-2015 01:40 PM
No it wasn't, that was just a program interpretation of the numeric value.