Add-PWSavedSearch syntax for $FIELD$ search

According to the change log, support for $FIELD expression was added in PWPS_DAB version

using the following powershell code:

$AuditUser = 'thbn'
$SearchField = "`$FIELD(10)`$ = (SELECT DISTINCT o_userno FROM dms_user WHERE o_username in ('$AuditUser'))"
$AuditSkabelon = 'Innovationsprojekter\Test_THBN\'
$SearchFolder = 'Større anlæg\7x\'

Get-PWRichProjects -FolderPath $AuditSkabelon -JustOne | 
Add-PWSavedSearch -SearchName 'CAD-files' -Environment 'Dokument' -DocumentName $SearchField -SearchFolder $SearchFolder -SearchSubFolders -UpdatedAfter 10/10-2020 -ReplaceExisting -Verbose

Gives the following in the search builder:
='$FIELD(10)$ = (SELECT DISTINCT o_userno FROM dms_user WHERE o_username in ('thbn'))'

however, this was the expected search result:
$FIELD(10)$ = (SELECT DISTINCT o_userno FROM dms_user WHERE o_username in ('thbn'))

Do we have any examples for writing the $FIELD expression ?

  • 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 '' 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 '' OR $FIELD$ LIKE '%.7z' OR $FIELD$  LIKE '%.rar''
    And not the expected:
    $FIELD$  LIKE '' OR $FIELD$ LIKE '%.7z' OR $FIELD$  LIKE '%.rar'

    I dont know if it is related, but i in pwps_dab version 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 ?

  • Add-PWFolderSavedSearch should now be working in the new 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 



    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.  

Reply Children