i want to show on an incident window tab other incidents where category1 OR category2 (both on the incident window) match the current incident.
i have created a filter for an incident window tab, returning incidents and using the two incident attributes as filter criteria:
category1 equals category1
OR category2 equals category2
this works if both category fields on the current incident are not null. so if one the two fields matches the corresponding category field on other incidents, these incidents are returned by the filter on the window tab.
however, if one of the two category fields is left blank (null) on the current incident, the tab does not return any results although the other category field matches other incidents categories.
is this supposed to work somehow, or a known limitation? explanations? ideas?
You might want to check for the title of the fullname for the category not being null as one of the conditions. So a more complex condition using the advanced button in QD will probably be needed. Depending on your version, ORs will not work in WebDesk. 7.4 is safer than 7.3 for that