I has a dynamic number field ISExtDLActualTAT, where is the number from 1 to infinite. I try to use search with
ISExtDLActualTAT >=1
it then prompts “Relational operations are not supported in text fields”
When ISExtDLActualTAT is empty, notes will change it to text field. So that some documents ISExtDLActualTAT are number field, some are text field.
How can I solve it?
Subject: Relational operations are not supported in text fields
You need to make several modifications. First, make sure that the field(s) can never be empty – use a default value and an input translation formula to ensure that the user can’t leave the field blank.
Next, you’ll need to run an agent to put a numerical value into the field(s) if they contain empty strings.
Search the database design to make sure that fields with the same name but are not number fields don’t exist anywhere.
You will need to remove the existing full text index.
Finally, you will need to update the unique key (UNK) table. You may be able to do this with a copy-style compact, but be prepared to make a new copy of the database if necessary.
Finally, re-create the full text index.