CIAI and ROW_ID
Our client uses S_CASE.ROW_ID for case references, as opposed to CASENUM.
They want to be able to query by S_CASE.ROW_ID, which is fine, but they'd like to do so in a case insensitive manner.
It would appear that the CIAI Wizard doesn't allow this: "Columns of functional type 'System' are not supported". I used the following CSV to feed into the wizard:
S_CASE | ,ROW_ID | ,Database | ,None | ,On |
Any thoughts on how to allow case insensitive search across ROW_ID?
Thanks!