Appreciate the community and apologies for not being able to articulate this question effectively.
The business need is - On a simple report with a textbox with a submit button - the customer should be able to type in the partial name of the account. This should initiate the database search to return matching account names and display this within a table.
Selecting an account should initiation another database call to fetch some details about that account and display them.
I would appreciate any pointers. Thanks a lot.
(There are several hundred thousand accounts and its not practical to load them all on the report load, hence this dynamic search).
To avoid loading the whole database with all accounts you can use a live connection. For filtering the user input in the database you can offer a string parameter to the user that is inserted to your custom sql:
Hi @NewToQuicksight,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.
