INCL/EXCL filter function and object field format compatibility

Document ID : KB000045410
Last Modified Date : 14/02/2018
Show Technical Document Details

Symptoms: 

INCL/EXCL filter function and object field format compatibility

SRM-VAN-0523: Invalid Filter: INCL/EXCL request invalid (not a character field)

Pop up error when trying to define a filter

Environment:  

Vantage Windows Client, Object definition window

Cause: 

Object fields are set in different formats depending on the field contents. Some filtering functions only work with certain formats. INCL/EXCL is a common filtering function that will not work with the Hex field format. And if used will result in an error similar to the popup error above.

Resolution:

Youll need to use the pattern masking filter statement method.
For example instead of:

CUAx EXCL 7/

Use:

CUAx < 7000 AND CUAx >= 8000

 

File Attachments:
TEC1301055.zip