I would like to know if there is an existing Stored Procedure in IAM that can return me the Application alias that I am currently logged in?
Best answer by mperrott 26 April 2021, 14:48
I'm not sure for what purpose you want to use this information, but I'm also curious. For the Universal GUI we use a custom screen that has to do some http calls to Indicium. This http call need to point to the proper url containing the application ID or alias (e.g. indicium.tld/iam/customer-123/table). We currently set the application alias matching the database name, this value we pass to the url (db_name()). But having the application id available in the end product would be even better.
We are using the same DB for our various published Applications, and there are Tasks that are used in all published apps ( for Reuse).
Our Email functionality uses an email_queue and an email_template table. The templates are defined according to Type and the publishing application. By having a function that returns the application alias I can replace as an expression parameter of the TASK that is the calling app and select the correct template id.
This is to have available a more dynamic task, and simply when a new app is published to add the template to the table. This solves my issue in copying the task multiple times and hardcoding the template id per published app. We want to avoid hardcoding IDs and values in general.
Currently we don't have a standard way of retrieving the Application alias. What we could do is making this available through the SESSION_CONTEXT, like we do with the application language since the 2021.1.18 release of Indicium. Feel free to create an idea for this.
What you can do now is having a system_setting table that contains the Application alias. With that you can extract it and use it in the Process Flows. Would that suffice for now?
Yes that would be a solution to have it in the SESSION_CONTEXT.
I will raise an idea and post it also here in the comments.
I will check on the system_setting table idea and revert.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.