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

Question

Question

Search Syntax to limit search area

asked on August 26, 2024

I inherited a repository with a poorly designed structure.  I'm trying to do some cleanup and reorganization in a repository that already contains hundreds of thousands of folders and documents. 

I would like to search to return any documents that exist so that I can move them to their final destination.  The current folder structure looks like this   STUDENTS > FILE ROOM > STUDENTS.  From there, the folders should proceed down by school year, like this...

But someone made a mistake years ago and now I'm trying to clean it up.  They had a form that filed in the repository.  They intended it to be named using the convention LastName, FirstName Identifier#.  But they left off the LastName and FirstName.  So they all filed with a comma followed by a space and then the identifier #.  Under each of those folders is a folder called Registrar.  So they look like this...

There are almost two thousand of those...too many to go through by hand.  

I'm having no success at creating a search syntax to retrieve any documents from the Registrar folders.  I feel like I need to use some type of wildcard for the misnamed folders but I can't get it to work.  Can someone help me figure out the search syntax to retrieve any documents remaining at the Registrar level without including any documents from the folders named using school years?

 

 

0 0

Answer

SELECTED ANSWER
replied on August 27, 2024

There are no search criteria for path contains or matches regular expression in the LF Client.  So instead, you need to create a search that returns all that you need in an easily sortable manner to get the items you are looking for grouped together.  Try this advanced syntax to return documents that are in a Registrar folder.  Then add the Path column to the Search Results pane and order by Path.  All the documents in a parent folder that is not filed by year and missing the name should be above those that are filed into the year folders.

({LF:Name="*", Type="D"} & {LF:LOOKIN="\STUDENTS\FILE ROOM\STUDENTS"} & {LF:ParentName="Registrar"})

0 0

Replies

replied on August 27, 2024

Thanks Bert!  I had not thought of using the parent folder name.  Including that narrowed it down to a little over 79k documents.  Laserfiche didn't seem too happy about handling all those records at once.  But I finally got it to sort on the path name and grouped the records together that I needed.

 

If anyone from Long Beach is paying attention, it would be great if somehow we could include wildcards in the folder search criteria.  

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

Sign in to reply to this post.