ProjectWise search criteria question

I don't think you can do this from ProjectWise search tool, but  there is a command line tool called enumfolders.exe in the Bentley\ProjectWise\bin directory (it's new in V8i so this won't work with previous versions, it might also be an admin only tool).  It will dump a list of info about each folder, including it's complete path to the screen. Pipe these results to the find command and you can do a pretty good search for a folder name. You can also dump into a text file for import into excel for clean up.

enumfolders -d server:datasource -r | find /i "2006" |  find /i "\Electrical" | find /i /v "Electrical\" > import.txt

enumfolders -d server:datasource -r => dump all folders in a datasource (-r means recursively). Uses current users authentication to log in. do a enumfolders -? for other options

| => pipe symbol (vertical line). Means send results to the next command

find /i "2006" => Output all strings containing a 2006. /i means ignore case. stupid for a number but i type it by habit

| => another pipe, sending results from find to another find

find /i "\Electrical" => include results that have a directory starting with \Electrical

| => more piping of results

find /i /v "Electrical\" => /v means do NOT show results meeting this specification. When it's displaying a subfolder of a folder the folder name ends in a \ so we only are interested in the actual folder, not subfolders.

> => this means send the output to a file

import.txt => name of file to dump the contents of the file too

you can import the import.txt file into Excel and do some more clean up and send results to user.

(PW v8i) 

Ok, a user has me stumped here. Can anyone help me determine if this type of search can be accomplished?

We name our projects in ProjectWise with the following format: \<project #> - <Description> - <Year>\

for example \1234 - Furnace "A" Major Rebuild - 2005\

Then the projects contain subfolders for the various discipline drawings.

What the user is asking is this: Can I perform a search for all Projects (not drawings) started since 2006 which contain drawings for the electrical discipline?

The last part is the trick - Its easy to find projects or folders in a certain date range, either using our Project names or Created dates. It's also easy to find all Documents created since 2006 which reside in a folder called "Electrical". (would return thousands of results)

 But neither of those will do it. They want the results to contain only the Projects started since 2006, and ONLY those which contain drawings for Electrical. (Not every project includes every discipline)

Any thoughts on how this could be done? Thanks!