Add-PWSavedSearch syntax for $FIELD$ search

Thank you for bringing this to our attention.  Your field syntax is correct.  This should work better next release.

Mark Weisman | Bentley Systems

Thanks for the quick response - the code above is now working.
However, i am facing issues with FIELD-searches like:

#Search Filtyper
$FiltyperArguments = @{
  SearchName = 'Filtyper'
  Description = $userFIELD
  FileName = "`$FIELD`$  LIKE '%.zip' OR `$FIELD`$ LIKE '%.7z' OR `$FIELD`$  LIKE '%.rar'" 
  SearchFolder = 'Større anlæg\7x\'
  UpdatedAfter = $AuditDate.AddMonths(-3)
  SearchSubFolders = $true
  ReplaceExisting = $true
}
$AuditProjekt | Add-PWSavedSearch @FiltyperArguments -Verbose

Gives the following search value:
LIKE '$FIELD$  LIKE '%.zip' OR $FIELD$ LIKE '%.7z' OR $FIELD$  LIKE '%.rar''

And not the expected:
$FIELD$  LIKE '%.zip' OR $FIELD$ LIKE '%.7z' OR $FIELD$  LIKE '%.rar'

I dont know if it is related, but i in pwps_dab version 2.1.22.0 i am also getting error running the cmdlet Add-PWSavedFolderSearch. Stating that it can not find 'CreateFolderSearch' in 'PWSearchWrapperX64.dll'

is FIELD-searches also supported in the cmdlet Add-PWSavedFolderSearch ?

Reviewing the change log, it states that we added support for $field$ expression to Add-PWSavedSearch.  We will extend that support to other cmdlets as time allows.  We will also look into the trailing single quote issue.   Fixing Add-PWSavedFolderSearch will be our highest priority.

Thanks,

Mark Weisman | Bentley Systems

Reviewing the change log, it states that we added support for $field$ expression to Add-PWSavedSearch.  We will extend that support to other cmdlets as time allows.  We will also look into the trailing single quote issue.   Fixing Add-PWSavedFolderSearch will be our highest priority.

Thanks,

Mark Weisman | Bentley Systems

Add-PWFolderSavedSearch should now be working in the new 2.1.23.0 release.  It does not as of yet support $field$ expressions.

Mark Weisman | Bentley Systems

Hi

related to Add-PWFolderSavedSearch

i am getting the same date when using the parameters -UpdatedAfter and -UpdatedBefore in the same search.

i am getting "unknown criterion" when using the parameters -ProjectProperties and -ProjectType 

As for you first inquiry, please explain why you want to use -UpdatedAfter and -UpdatedBefore in the same search.

As for you second, I used Example for in the example datasource that you can create with ProjectWise Administrator:

 Add-PWSavedFolderSearch -SearchName "00 Search from PS 8E" -ProjectType General -ProjectProperties @{PROJECT_Project_Name = "PRJ%"} -verbose

The search worked.  I did create a work area with the Project Type of General and set the Project Name property to PRJ99 before running it.

To see exactly how to specify the project property names you can use the command 

Get-PWRichProjectProperties -ProjectType <ProjectType>

For example

Get-PWRichProjectProperties -ProjectType General 

yields 

PROJECT_Budget
PROJECT_End_Date
PROJECT_Owner
PROJECT_Percent_Complete
PROJECT_Project_Description
PROJECT_Project_Location
PROJECT_Project_Manager
PROJECT_Project_Name
PROJECT_Project_Number
PROJECT_Project_Status
PROJECT_Start_Date
ProjectTypeId

Hope this helps,

Mark Weisman | Bentley Systems

Apologies for the late response.

The -UpdatedBefore is used to limited the search result to a specific timeframe, as the audit we are performing applies to that specific timeframe – and not documents created outside of that time frame. It is a minor issue – we have work arounds for it.

I am still not able to perform a saved search for folders with ProjectProperties – see image.

I think this would be like a between, ie documents created between 1/1/2023 and 2/1/2023.