[FEA]: Add query parameter to get all tenant accounts endpoint

[nvlitagaki]

Is this a new feature, an improvement, or a change to existing functionality?

Improvement

How would you describe the priority of this feature request

Low (would be nice)

Please provide a clear description of problem this feature solves

Admin users on sites with large numbers of tenant accounts may have trouble sifting through large lists of results.

Feature Description

The vast majority of existing list endpoints allow users to search records that match a query string in any of a couple of key fields -- typically name and description. The endpoint to fetch the full list of tenant accounts has no such option to filter results.

Describe your ideal solution

Add a new query parameter on v2/org/{org}/carbide/tenant/account that is used to restrict to the returned tenant accounts to values that match on the tenant account account number as well as both the name and display name of the associated tenant org.

Describe any alternatives you have considered

No response

Additional context

No response

Code of Conduct

• I agree to follow Carbide's Code of Conduct
• I have searched the open feature requests and have found no duplicates for this feature request

[WinterCabbage]

Hi, I’d like to take this on. One clarification before I start: when you say “tenant org name/display name,” do you mean filtering tenant accounts by account_number, tenant.org, and tenant.org_display_name?

[nvlitagaki]

Hi, I’d like to take this on. One clarification before I start: when you say “tenant org name/display name,” do you mean filtering tenant accounts by account_number, tenant.org, and tenant.org_display_name?

I mean filtering by account_number, tenant_org (It looks like this is a column is actually duplicated on the tenant_account table, no join required), and tenant.org_display_name. Thanks!