topic Re: Filter showing nodes with missing mandatory properties in Alfresco Archive

Filter showing nodes with missing mandatory properties

billerby — Thu, 15 Sep 2011 09:47:06 GMT

I need to develop a new Share filter for the Document library. My intention is that the filter will show all nodes in a site with missing values for mandatory properties. Is it possible to ask Lucene for nodes with missing mandatory values in any way? If thats not possible my only idea is to use the

Re: Filter showing nodes with missing mandatory properties

loftux — Thu, 15 Sep 2011 09:53:44 GMT

in filter.lib.js

         case "incomplete":
             filterQuery = "+PATH:\"" + parsedArgs.rootNode.qnamePath + "//*\"";
             filterQuery += " AND (ISUNSET:\"{http://www.example.com/model/content/1.0}agreementNumber\"";
             filterQuery += " ISUNSET:\"{http://www.example.com/model/content/1.0}myCompany\"";
             filterQuery += " ISUNSET:\"{http://www.example.com/model/content/1.0}party\"";
             filterQuery += " ISUNSET:\"{http://www.example.com/model/content/1.0}expirationDate\"";
             filterQuery += " ISUNSET:\"{http://www.example.com/model/content/1.0}noticeTime\"";
             filterQuery += ") "
             break;
  ‍‍‍‍‍‍‍‍‍‍

More to find here http://wiki.alfresco.com/wiki/Full_Text_Search_Query_Syntax#Fields
You probably just have to query a one of the properties if it is unset if they are on the same form, since you get an all or nothing situation.

Re: Filter showing nodes with missing mandatory properties

mrogers — Thu, 15 Sep 2011 10:55:33 GMT

A missing mandatory property should not be possible. If the data model specifies the field as mandatory then a value must be specified.

Re: Filter showing nodes with missing mandatory properties

loftux — Thu, 15 Sep 2011 11:09:08 GMT

A missing mandatory property should not be possible. If the data model specifies the field as mandatory then a value must be specified.

True, but if you have a custom type, and convert cm:content to that type, and forget to visit edit metadata page, you have document with mandatory properties not set. And those are the ones you want to find. Especially if you enable setting the document type in the upload dialog, and upload many documents at the same time.

Re: Filter showing nodes with missing mandatory properties

billerby — Tue, 27 Sep 2011 12:03:19 GMT

Hi again,

I have another idea that seems more general. It seems like Alfresco applies the aspect sys:incomplete on a node whenever the node have unset mandatory properties. Then it should be possible to filter out all nodes in a site with this aspect set?

This way I do not have to update my filter every time a new mandatory property is added in my data definitions.

Regards
/Erik