WebSite X5Help Center

 
F L.
F L.
User

I want to use the database viewer to show only the data of the logged in user  en

Author: F L.
Visited 2674, Followers 1, Shared 0  

I want to use the database viewer to show only the data of the logged in user.

I.e. User2 is logged into the Restricted area, now the "Dattabase Viewer" should show only the details of User2 not user4,5,129 ...

Or can i create a custom view for the "DB viewer" instead of showing one whole table?

Posted on the
6 ANSWERS
John S.
John S.
User

Hello F L

This is not possible with the database-viewer.

There are more solutions to do what you want.

Use a database tool like Appgini where you can create your own tables and set user-permissions for tables ( create, view, edit, delete records). The tool is very easy to use and databases/tables can be created in few hours.

If it must be on existing tables, then you could use custom code for viewing a table, and where you use the log-in information from X5. There is a lot of code on the internet for this purpose.

You could also use the free REPORTICO report designer. This is a very powerful tool for making views from tables. You can join tables. And the system has the ability to use login information from other systems. This way you can have a report showing only data for person1 if user is logged in as person1, only data for person2 if user is logged in as person2, and no data will be shown if user is not logged in. The system also has its own log in system with users and user groups. So you can choose to use the login from X5 or the login in REPORTICO.

Read more
Posted on the from John S.
John S.
John S.
User

See also this very old post : https://helpcenter.websitex5.com/en/post/162656

Nothing has changed in the database viewer since it was released. At least they could make the email-form have a possibility to "save" the login id ( email ) and then let the database viewer have an option :

Check user-login-id for field xxxxxxxxx.

Read more
Posted on the from John S.
F L.
F L.
User
Author

Your 2nd Post would help already.. :-)

Guess not enough people using the Program into depth.. :-)

Read more
Posted on the from F L.
F L.
F L.
User
Author

Thx for the rest, i will have a look into it.

Read more
Posted on the from F L.
John S.
John S.
User

If you are interested in AppGini, I could make an example for you. You could tell something about what a table should contain. I could create the example, and if it is useful, you could have an installation-file, and create the databse on your own server.

As this will not be a X5 issue, you could contact me via this : http://calendarforum.dk/contact.html

If you prefer one of my other suggestions, then I will maybe not be of any further help, as it will then be on your database and server.

Read more
Posted on the from John S.