Contains Vs Is operator in Reports Filter
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-22-2018 08:13 AM
In the Create Report page, we were working on a Table and wanted to compare a field of type numeric using “is” operator. Though there are duplicate records found with “contains” operator, but zero results returned with “is” operator. As this field's data can be of various lengths and hence “contains” is not a reliable operator (i.e. with "contains" there can be false positives and hence we want to look for an exact match). Now question is -
Is there a reason, why “is” operator is not working for this field comparison? (I don’t think database stores this field with leading zeros or blank space characters which may be causing this behavior).
Operator “is” is working just fine for other fields of this table so it’s puzzling as to why it’s not working for this particular field. I am sure there is something special about it but that nothing that I know of. Do you know the conditions, when an “is” operator won’t work?
Any help is appreciated!
- Labels:
-
Analytics and Reports
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-22-2018 10:44 PM
Are you reporting on sys_dictionary ? i mean to whom the type belongs ? a field or variable ..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-23-2018 04:26 AM
Thanks for your reply, Gurpreet! This is for a user defined table as the name starts with "u_". I don't know if it extends any table at all, and if it does, which table. This is because I am not an admin. And the field I am talking about it's one of the columns in the table. So I say it's a field and not a variable.
