Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
my problem is the following:
My customers are different companies, which use one of our programs. The data of this program is stored separate MS SQL - Databases for each company. All of those databases are located on our server. So it looks something like this:
Company A -> Database A
Company B -> Database B
Company C -> Database C
.....
I've already created a QV-Application, into which I load the data from one of the databases.
Now I want to create a qvw-File for each company (or database), which looks exactly the same apart from the loaded data.
So I would like to have the same number of qvw-Files as there are companies.
Company_A.qvw -> Data from Database A
Company_B.qvw -> Data from Database B
.....
This way, employees of every company would only see their own data.
The big problem is, when I apply changes to a qvw-File, it does not affect the others. For example, if I want to add a new object, I have to do this for each qvw-File seperately.
Is there a way to create multiple qvw-Files, in which only the script (or the source of the data) is different?
Otherwise I would have to load all data into a single qvw-File and create filters or something like that ...
Thank you!
You would want to create 1 master qvw with all the data in it. This will be the one you make updates too and maintain.
Then you would either:
1) Use section access to limit your customers' visibility to data to only their accounts. See A Primer on Section Access
or
2) Use the Loop and Reduce capability on the server side to create a separate QVW for each customer.
You would want to create 1 master qvw with all the data in it. This will be the one you make updates too and maintain.
Then you would either:
1) Use section access to limit your customers' visibility to data to only their accounts. See A Primer on Section Access
or
2) Use the Loop and Reduce capability on the server side to create a separate QVW for each customer.