You are viewing limited content. For full access, please sign in.

Question

Question

How do you search for folders that are not assigned a specific volume?

Laserfiche
Updated October 22, 2021
asked on October 15, 2021 • Show version history

I am using the syntax

({LF:VolId<>"6"})

It returns folders that are assigned any other volume, but is missing folders which do not have a volume assigned at all.

I am trying to search for all folders not in a specific volume, to be not in a volume at all is also to be not in the volume and I want to include those as well.

0 0

Replies

replied on October 15, 2021 
{LF:Name="*", Type="F"}&{lf:volid = 0}

Keep in mind that any search through the client is subject to the security access of the currently logged in user. If you want ALL folders, you may want to go directly through SQL:

SELECT name, tocid
  FROM toc
  WHERE vol_id IS NULL AND etype = 0 AND tocid <>2

 

1 0
replied on October 18, 2021

How is volid = 0 different than volid <> 6?

0 is less than 6

0 0
replied on October 22, 2021

<> 6 is not supported in searches by volume ID. = 0 is translated in the backend as a search for entries without a volume ID set.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...