How to create a view with object ID

Question

Hello all, 
 I have question that I've been struggling with for some time. Hope you can help. 
 We have customers, projects and many other object types imported from our ERP. In M-Files the ID of a project is the project number in our ERP. I can create views with project name as a grouping level easily enough. But in certain cases it would be more convinient to use the project number as a grouping level in a view, which is the ID of the "project" object type. How to achieve this? Need a make new property somehow? Can just make some reference in the view properties? 
 I'm happy give more info, if somebody is willing to help. Thanks.

Joonas Linkola · Accepted Answer

One way that I think should work is to indeed add a new text property and under Automatic Values you can set it to use the %OBJID% placeholder like below (you can call the property for instance "Project number"). This should fill the external ID into that property automatically. 
 If you then add this property to the Project class and use the Recalculate option in M-Files Admin it should fill the property for all the existing projects in the vault. 
 Make sure you also check the "Allow this property to be used as a grouping level in views" option on the General tab.

Joonas Linkola · Answer

You need to select Text in Group by since it's a text property and after that you should be able to select the Project no property under Project . I tested this quickly with Customer instead of Project and this worked:

How to create a view with object ID

Top Replies