How to delete file link whose destination is NULL?

[deepak1987]

Hi,

I want to delete all file links whose destination is NULL. I tried through Lucene query to get all Links which is:
TYPE:"app:filelink" AND ISNULL:"cm:destination"

The above query doesn't work for me. It returns 0 rows.

The other approach is get all file links by TYPE:"app:filelink" in ResultSet and do iteration using for loop to check if destination is null, which is not the best way.

Please help me on this.

[mitpatoliya]

This will server your purpose I guess.

TYPE:"app:filelink" NOT ISNOTNULL:"cm:destination"

[deepak1987]

Hi Mittal,

Thanks for your reply. This query TYPE:"app:filelink" NOT ISNOTNULL:"cm:destination" didn't worked. 

[amandaluniz_z]

Hi,

I'm not really familiar with links, but having a glance to the models in Alfresco, the one with the cm:destination is not app:filelink, but cm:link…

So based on that, shouldn't the query look like the following?

TYPE:"cm:link" AND ISNULL:"cm:destination"‍‍‍

Regards,
Adei

[deepak1987]

Hi Adie,

Thanks for your reply.

My problem got resolved by creating fresh new indexes.   

The below query will also work because cm:link is parent for app:filelink. But this query will return all File links as well as Folder links. If you want only filelinks then, use TYPE:"app:filelink" and for folderlinks use TYPE:"app:folderlink"

TYPE:"cm:link" AND ISNULL:"cm:destination"‍

Type cm:link is defined in contentModel.xml file as:

         <type name="cm:link">         <title>Link Object</title>         <parent>cm:cmobject</parent>         <properties>            <property name="cm:destination">               <title>Link Destination</title>               <type>d:noderef</type>               <mandatory>true</mandatory>            </property>         </properties>      </type>‍‍‍‍‍‍‍‍‍‍‍‍‍

Type app:filelink & app:folderlink are  defined in applicationModel.xml file as:

      <type name="app:filelink">         <title>File Link Object</title>         <parent>cm:link</parent>      </type>            <type name="app:folderlink">         <title>Folder Link Object</title>         <parent>cm:link</parent>      </type>‍‍‍‍‍‍‍‍‍‍‍

So, to find all links whose destination is NULL, Execute any of the below queries:

// Returns only File links whose destination is NULL.1) TYPE:"app:filelink" AND ISNULL:"cm:destination"2) TYPE:"app:filelink" AND NOT ISNOTNULL:"cm:destination"3) TYPE:"app:filelink" AND ISUNSET:"cm:destination"// Returns only Folder links whose destination is NULL.1) TYPE:"app:folderlink" AND ISNULL:"cm:destination"2) TYPE:"app:folderlink" AND NOT ISNOTNULL:"cm:destination"3) TYPE:"app:folderlink" AND ISUNSET:"cm:destination"// Returns all File links & Folder links whose destination is NULL.1) TYPE:"cm:link" AND ISNULL:"cm:destination"2) TYPE:"cm:link" AND NOT ISNOTNULL:"cm:destination"3) TYPE:"cm:link" AND ISUNSET:"cm:destination"‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Thanks once again.

[amandaluniz_z]

True! didn't check the parent for the app:filelink…