AML Search Query - If name exists in any field, do not display in results
I am trying to look up work orders where the specified name is not anywhere on the distribution. Currently the way it is set up, it will display work orders where "John Doe" is included because there are more than one lines on distribution and while it finds the name on one line, it won't find it on another. So is there a way to create a search where it searches all names on distribution, if it shows up even once to not display that work order in results? Any help is welcomed! Thank you! <Relationships> <Item type="Work Order Distribution" action="get"> <_assigned> <Item type="Identity" action="get"> <NOT> <keyed_name condition="like">John Doe</keyed_name> </NOT> </Item> </_assigned> </Item> </Relationships>