Solved

Table name of users company and site

  • 15 November 2021
  • 4 replies
  • 205 views
Link
Rank
Userlevel 7
Badge +22
  • Link
  • Superhero (Customer)
  • 943 replies

Hello,

does anybody know the table or view name of the company and site?

 

 

Thank you

icon

Best answer by ShawnBerk 15 November 2021, 15:50

View original
Kind regards
This topic has been closed for comments

4 replies

Thiwanka Sandaruwan
Rank
Userlevel 4
Badge +9

Hi @Link ,

 

Just try below statements.

 

Tables:

 

SELECT * FROM company_tab;

SELECT * FROM site_tab;

 

Views:

 

SELECT * FROM company;

SELECT * FROM site;

 

Best Regards,

Thiwanka

 

Link
Rank
Userlevel 7
Badge +22

Hi @Link ,

 

Just try below statements.

 

Tables:

 

SELECT * FROM company_tab;

SELECT * FROM site_tab;

 

Views:

 

SELECT * FROM company;

SELECT * FROM site;

 

Best Regards,

Thiwanka

 


Hi Thiwanka,

I need the table or view with all users, companies and sites.

If I activeate these checkboxes the user must be saved in a table. I am I right?

Thank you a lot.

 

Kind regards

 

Kind regards
S
Rank
Userlevel 7
Badge +28

You are looking for User_Allowed_Site and User_Finance which is a child table to Company_Finance.

Link
Rank
Userlevel 7
Badge +22

You are looking for User_Allowed_Site and User_Finance which is a child table to Company_Finance.


Yes, that is true.

Thank your very much.

Kind regards
Terms & ConditionsCookie settings