Examples: query, "exact match", wildcard*, wild?ard, wild*rd
Fuzzy search: cake~ (finds cakes, bake)
Term boost: "red velvet"^4, chocolate^2
Field grouping: tags:(+work -"fun-stuff")
Escape special characters +-&|!(){}[]^"~*?:\ - e.g. \+ \* \!
Range search: properties.timestamp:[1587729413488 TO *] (inclusive), properties.title:{A TO Z}(excluding A and Z)
Combinations: chocolate AND vanilla, chocolate OR vanilla, (chocolate OR vanilla) NOT "vanilla pudding"
Field search: properties.title:"The Title" AND text
 
Answered
How to tell if an account is linked to the logged in user (not joint)?

I've examined the account.link_type attribute and see two values, either 'A' or 'C'. I currently don't know what either of these values mean or if I'm even looking in the right area.

In my Dev Box I have created a new Online User and created a checking account for that user. I then used the Q2 DB command to link the account to my retail0 user. When viewing the link_type attribute for that account it has a value of 'A' which about half of the other accounts (that are not linked) also have.

The current extension I'm developing requires me to gather a list of primary and joint accounts but excluding linked accounts.

Thanks!

Votes Newest

Answers 2


Thank you for the detailed response, Paden. I will take this back to my team and take appropriate action.

Much appreciated!

Posted 4 years ago

The short answer to this is Q2 does not store, or have a concept of account relationship. You may have to go to the core to get this information.

The link type that you are looking at is describing how the account is linked to the end user. Link type C means the account is linked via the primary cif and is probably part of a group of accounts that all have the same primary cif value. A link type of A means the account is linked via the account id (Host Account ID) and someone had to directly say "the end user should be able to have some sort of access to this account specifically".

There is a way to guess at the relationship in an extension. If you compare the self.online_user.user_primary_cif value of the end user to the account.cif_internal_unmasked value on each account. Every account that matches the users primary cif should be a "primary" account. This depends on the validity of the primary cif value on the user, as that doesn't always match the expected account cif values.

Posted 4 years ago
Paden Rose
77 × 1 Administrator