I want to use the database viewer to show only the data of the logged in user 
Автор: F L.
Просмотрено 2599,
Подписчики 1,
Размещенный 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?
Размещено
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.
See also this very old post : https://helpcenter.websitex5.com/ru/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.
Автор
Your 2nd Post would help already.. :-)
Guess not enough people using the Program into depth.. :-)
Автор
Thx for the rest, i will have a look into it.
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.
Hello guys,
Into my WSX5 demo website: https://wsx5.afsoftware.fr/viewforum.php?f=111 there is a lot information about database viewers & code /tips to create your own requests
Enjoy
https://wsx5.afsoftware.fr