cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Loading Database Thing Dynamically in the Mashup

SOLVED
Level 7

Loading Database Thing Dynamically in the Mashup

Hi All,

I am new to ThingWorx Composer. I need to load the database thing dynamically into the mashup based on the user organization permission.

For example:

I have two things name called Factory1 and Factory2.

Factory1 and Factory2 have the same services and properties but different database configuration.

If User1 Login, the application needs to load the Factory1 Thing in the Mashup.

if User2 Login, the application needs to load the Factory2 Thing in the same Mashup.

 

Please suggest me on the same.

 

Tags (2)
1 ACCEPTED SOLUTION

Accepted Solutions

Re: Loading Database Thing Dynamically in the Mashup

According to your request, build a infotable with column User and DatabaseName, use GetCurrentUser service (CurrentSessionInfo Resources) to get the user name, and bind the related name to previous mentioned dynamic service.

5 REPLIES 5

Re: Loading Database Thing Dynamically in the Mashup

1. Add new service to a Thing

2. Enable "Dynamic", for entities choose "DataTable" Thing Template

3. Type in the services you want in the script field, Complete

4. The new service will have an input for entity name.

Re: Loading Database Thing Dynamically in the Mashup

According to your request, build a infotable with column User and DatabaseName, use GetCurrentUser service (CurrentSessionInfo Resources) to get the user name, and bind the related name to previous mentioned dynamic service.

Re: Loading Database Thing Dynamically in the Mashup

Hi @snoor.

 

If one of the previous responses answered your question, please mark the appropriate one as the Accepted Solution for the benefit of others with the same question.

 

Regards.

 

--Sharon

Re: Loading Database Thing Dynamically in the Mashup

Hi @slangley ,

 

I got the idea from the above answers,  but I have not tried still due to priority on my task list. Once I tried with the above solution, I will accept the appropriate one.

 

Thanks for the guidance. 

Highlighted

Re: Loading Database Thing Dynamically in the Mashup

@zyuan1  I have tried the suggested approach and its working thanks for the solution.