Step 1 :
Go to Login From And Create User "Supper-Admin". Don't Any Company Select.
Step 2 :
Create New Page And Create Two Region
1- All Company
2- My Company
👉1- All Company
Type : Classic Report
SQL Query :
SELECT ID , NAME , ADDRESS From SETUP_COMPANY ;
Server-side Condition :
Type : Item is in colon delimited list
Item : GUSER_ID
List : 31 ---- (Supper-Admin User Id Number)
-----> NOTE : This Region Show All Company In the Database. Only for Supper-Admin
👉 2- My Company
Type : Classic Report
SQL Query :
SELECT ID , NAME , ADDRESS From SETUP_COMPANY
where ID=GET_COM_ID(:GUSER_ID)
Server-side Condition :
Type : Item is Not in colon delimited list
Item : GUSER_ID
List : 31 ---- (Supper-Admin Id Number)
-----> NOTE : This Region Show User Wise Company In the Database
Example :
Note : You Must be Select Page Template : Minimal (No Navigation)
