Filter XML query with linked entity not returning data
I have a custom table that has a field referencing the system Account table: Table: Client Company Name: ccc9_client_company Field : Client Account Name: ccc9_client_account Data type: Unique Identifier
Field: Name Name: ccc9_client_account_name Data type: String
So, for each Account defined, there will be an entry in the Client Company table for the account.
Now, when a logged in user views a page, I want to show the Client Company details for the Account assigned to the current logged in user.
So far, I have tried a number of queries that all have not worked: