Getting a contact with a specific AccountStatusID using K# Macro

Paul Truman asked on May 19, 2023 17:50

Hi, I'm trying to use the following Macro to identify contacts that are part of an Account with a specific Account Status:

Contact.Accounts.ItemsAsFields.AccountStatusID.EqualsAny("5")

When I try Contact.Accounts.ItemsAsFields.AccountStatusID, I get the correct account. But when I try to choose only selected ones, I keep getting null. Does anyone know what I'm doing wrong? When I try "Contact.Accounts.ItemsAsFields.AccountStatusID" in the Macro console, it give me a "5" back for the current user, so the data value is resolving correctly.

   Please, sign in to be able to submit a new answer.