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?