Search results for query: *

No, it's when the specified address type doesn't exist for a person that the entire record (entity and all people with their addresses) is omitted.

I'm trying to print a profile of the entity displaying all of the positions and their contact details (or in the case of positions that aren't filled, highlighting that fact) but want to make sure that the address details that we use are the ones displayed. The different address types are work...

Nice one! Thank you - that seems to have done the trick for the vast majority of the records, though where the address type isn't possible, I still lose record. e.g. (isNull({thirdleaderaddresstype}) or {thirdleaderaddresstype} = "work") Where there isn't a work address type for someone (say...

The problem is that when I specify criteria for a field in a table that has a left outer join, that join behaves like an an equal join. Here’s the scenario: I have an entity for which there are several named contacts. Each contact can have multiple addresses which are assigned a ‘type’...