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
What should I use as an identifier for multi-tenant? The ABA number

Does the Q2 Database stores user data, including accounts and transactions, partitioned by ABA number to ensure data isolation. Also, for multi-tenant How does Q2 distinguish between tenants when we call for instance GetAccountHistoryByIdWindowed?
Q2 uses ABA - American bankers association number that identifies the financial institution?

Posted 2 years ago
Votes Newest

Answers


Hello, there are three main ways we differentiate in multitenant situations: self.hq_credentials.aba(this is a unique value for each FI, the FI's staging and Prod environments will have this value set), self.hq_credentials.customer_key(This will be a unique value for each environment i.e. the FI staging and Production environments will be different), self.online_user.user_guid(this is a hash of the user_id and customer key so it will be a unique user id for every user assiociated with Q2).

So depending on which use case you are after depends on which tool you want to use.

Posted 2 years ago
Trey Teter
489 × 4 Administrator
0

If I want a single unique identifier for a given FI, but the FI has multiple routing numbers, then I obviously wouldn't use aba. But customer_key would be constant within a given environment correct? So there would be a separate customer_key for staging vs prod, but in a given env, customer_key will stay the same even if the aba associated with the current user changes - is that correct?

— Terren Suydam   one year ago
129 Views
1 Answer
2 years ago
2 years ago