topic Re: Change URL link depending on login environment in App Development

Change URL link depending on login environment

jmialoundama — Wed, 15 Feb 2023 14:59:50 GMT

Hello,

I want to change the url link of a board based on my login:

I have an Integration connection and an ODBC connection for data in Production.

When I am in integration my URL link is the following:
https://int-test-data/cars/index.php?=controller=....

When I am in production the URL link is the following:
https://prod-data/cars/index.php?=controller=....

How can I do in my Qlik Sense application to put the right URL link according to the ODBC connection I am on.

Thank you in advance for your help

Re: Change URL link depending on login environment

Qlik_Eric_Thomas — Wed, 15 Feb 2023 15:50:19 GMT

Maybe something combining the if() control statement with the ComputerName() Function?

Something like:

IF(wildmatch(ComputerName(),<Your Prod Server Name>),'<prod URL>','<int URL>')

You can use the ComputerName() Function in a KPI on each environment to verify what the value will look like

Re: Change URL link depending on login environment

jmialoundama — Fri, 17 Feb 2023 11:23:52 GMT

Hi @Qlik_Eric_Thomas ,

Thanks you for your feedback.

I create this little script to solve my problem :

/*We come to retrieve the name of Qlik Sense server*/ LET v_Project_Environnement = IF(ComputerName()='name_of_server', 'INTEGRATION', 'PROD'); /*URL integration*/ LET v_Serveur_INT = 'URL_INTEGRATION'; /*URL Production*/ LET v_Serveur_PROD = 'URL_PRODUCTION'; LET v_URL_Path = IF('$(v_Project_Environnement)'='INTEGRATION', '$(v_Serveur_INT)', '$(v_Serveur_PROD)'); TRACE 'l_urlPath=$(l_urlPath)';