nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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.

Find more posts tagged with

Comments

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:

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

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

 
&nbsp;&nbsp;&nbsp;&nbsp; <type name="app:filelink">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <title>File Link Object</title>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <parent>cm:link</parent>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </type>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <type name="app:folderlink">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <title>Folder Link Object</title>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <parent>cm:link</parent>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </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…