Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025

 


Article

Query to determine private list views

« Go Back

Information

 
Article Number000091175
EnvironmentProduct: Rollbase Private Cloud
Version: 5.x
Question/Problem Description
Please provide the query to determine private list views created by Users.
Steps to Reproduce
Clarifying Information
Error Message
Defect/Enhancement Number
Cause
Resolution
Please run the below query on System Console >> Database >> Query Database.
 
SELECT t1.CUST_ID, t2.LOGIN_NAME, t3.SINGULAR_NAME as OBJ_NAME, t3.OBJ_DEF_ID as OBJ_ID, t2.STR0 AS EMAIL, t1.LIST_VIEW_ID as LIST_VIEW_IDs, t1.VIEW_NAME 
FROM RB_LIST_VIEW AS t1 
INNER JOIN 
RB_USER_DATA AS t2 ON t1.CREATED_BY = t2.OBJ_ID 
INNER JOIN 
RB_OBJ_DEF as t3 ON t3.OBJ_DEF_ID = t1.OBJ_DEF_ID 
WHERE t1.PROPERTIES LIKE '%isPrivate=true%';
The above query will return the Customer ID, Login Name, Object Name, Object ID, Email address of the User and List View Id along with List View Name.
 
Workaround
Notes
Attachment 
Last Modified Date8/23/2018 5:07 PM