Hello,

For detailed documentation on view model properties, please refer to the following link:

Data handling basics

Anybody have any experience of working with such a setup?

It would be great to have the view be able to inherit permissions from some object that the view has as a lookup column. However, I don't believe that is possible. What I typically do is this:

1. Create a view and include as a column some other object that has permissions (for example, if the view includes an Opportunity lookup column and the account has permissions)
2. Anywhere the view is used, include a filter condition that some column on that related object is not null (that would never be null). Plus it cannot be the Id or the column used as the display value. Example, if my view has a lookup for Opportunity, I could use Opportunity.Stage is filled in.
3. Using this approach, the user will only see the rows corresponding to the related record that they have access to, since if they cannot view the related opp the Stage will return a null value. 

It's not ideal and definitely not secure, but it does limit the view rows to what the user can see on the related object.

Ryan

Yeah that's a clever workaround, many thanks Ryan! Agreed about the security aspect, but for the the cases where it's just about having those record permissions used to define non-security visibility as I currently have for the base entity it will work for now.

It would definitely be good for the view entities to be able to inherit permissions from lookup columns though, and feels like it would be a relatively quick win for Creatio to add, as most of the functionality around that would already exist. It could even be done in a no-code way by enabling the creation of these view-based entities directly in the config, effectively adding a logical layer to the platform which would be great for filtered views into the data and adding virtual calculated fields. So much utility to be had with such a logical layer.

Hello Rikesh,

Hope you're doing well.

Please try to generate and compile the application, additionally, the pool can be restarted, and perform flushing the Redis. If it didn't help, please check if all the necessary columns (Id, CreatedById, ModifiedById, ModifiedOn, etc.) were added to the view object. Possibly next Community posts will be helpful for solving the issue you have faced:

• https://community.creatio.com/questions/how-create-view-object-bpm-onli…
• https://community.creatio.com/questions/setup-columns-view-relationships

In case after performing the mentioned operations and checking the issue still persists for you, please open the web developers console (in Google Chrome just need to press F12) before opening the detail record and check if there are any specific error notifications that can point at some missed configurations for the needed detail.

Best regards,

Roman

You view do not return Inhrerited columns (

Such as this: id, createdOn, createdBy....) 

Hi Grigoriy,

Thanks for your reply, any suggestion how I can fix this

Fulgen Ninofranco,

In order to create a view in the system you need to do the following:

1. Create a new object in the system configuration. Give it the same name as view. Set "Represents Structure of Database View" option to true (put a tick); The object should include all columns, that you will add to the view.

2. Run a script to the database to create a view with needed columns.

Please take into account, that structure of columns in the view should match the object columns structure. 

Based on your screenshot I can tell, that in the object for the view Contact and Account fields will be lookup type columns and will be referred as [Column name]+Id e.g. UsrContactId, UsrAccountId. However, in the view, you have named them simply UsrContact and UsrAccount.  Please check the naming.

Also, as you open dashboards, please open developers console as well (F12). You will see errors indicating which column cannot be found. This will help you to determine the issue.

Regards,

Anastasia