Maximo List View: Filter where field is null OR equals value?
I have a division field in Work Orders in Maximo 7.6.1.1.
I would like to filter the work orders in the List View where division is null or division = 'FORESTRY'.
Is it possible to do this in the List View?
Solution
I ran a few tests on 7.6.0/Oracle 12 and it appears that it's not supported, both on WILDCARD and TEXT search types. It seems that you can only use the ~null~ operator alone although it's not specified in the latest documentation. https://www.ibm.com/support/knowledgecenter/SSLKT6_7.6.1.1/com.ibm.mbs.doc/gp_ui/r_wildcard_operator_search.html
Your best bet is probably to use a saved query or to type it directly in the Where Clause Advanced search dialog.
- How do I low-pass and high-pass filter audio in Java using a double[] array
- How can I remove nulls in the process of unpivoting a polars dataframe?
- How to do paging in Angular manually
- Jhipster generator doesn't generate filter panel in UI
- Filter or map nodelists in ES6
- Drawing a circle in fragment shader
- How to filter for greater than on a datetime column while including Nulls?
- WordPress convert image to WebP format programmatically with GD image engine
- A query to show a list of customers with only 1 specific product
- Excel LET function to return filtered values of various size based on a criteria row by row
- Breakup List of file filters in FileOpenDialog
- Sum values from specific field of the objects in a list
- Django - Getting last object created, simultaneous filters
- Selecting unique rows of a dataframe when the duplicate values are swapped across multiple columns in R?
- SQL sorting , paging, filtering best practices in ASP.NET
- Find rows where pandas dataframe column, which is a paragraph or list, contains any value in another list
- Can I search github labels with logical operator OR?
- Multiple choice checkboxes as filters in JS but filters don't apply
- Javascript filter data array within array
- Wordpress Modified Date and Published Date Output
- Filtering column customer ID that has multiple product ID in SQL
- Multiply filter with PHP's GD library
- TypeError: DataFrame.drop() takes from 1 to 2 positional arguments but 3 were given
- Wordpress Yoast exclude posts from XML sitemap
- Get category ID inside "wp_list_categories" Filter
- How to filter files when using scp to copy dir recursively?
- Ansible: Combining dict into specific list item, nested in a dict
- Can't find a filter of a program in Procmon
- Filter nested object
- Query using two variable in two array