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 ?

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

Hi all, looking for a little help on usings $FIELD$, the saved search is created but the " " or come combination of characters seams to pull an extra LIKE into the outcome of the saved search.  I'm using 23.0.5.0 but seems to the same in earlier builds.

what's shown in search builder in PW, LIKE '$FIELD$ LIKE '%.dgn' OR $FIELD$ LIKE '%.7z''

Also, important, is this approach still limited to 255 chars on filters? The outcome I'm looking for is a targeted specific file name list, less wildcards.

Please correct me if I'm missing something here, seems no matter how I adjust the input to the saved search is not formed correctly.

NEW-PWLogin

$FilterperArguments = @{
SearchName = 'Test4'
Description = $userFIELD
FileName = "`$FIELD`$ LIKE '%.dgn' OR `$FIELD`$ LIKE '%.7z'"
SearchFolder = 'PEDC-0085\'
SearchSubFolders = $true
ReplaceExisting = $true
}

Add-PWSavedSearch @FilterperArguments -Verbose

Close-PWConnection

Craig,

$FIELD$ expressions are esoteric functionality.  Until we perfect it, please consider using the Add-PWSavedSearchOrGoup cmdlet to create saved searches in PowerShell with or conditions.   

To log out of a database, use Undo-PWLogin.  There is no Close-PWConnection cmdlet to my knowledge.

Hope this helps,

Mark Weisman | Bentley Systems

Thanks for the reply, one last question.  Can the saved search be added to?  Meaning after creation, can an 'Or' Group be added in a second step?  Also, Close-PWConnection is listed as a base function in pwps from what I see.

I would recommend using the Undo-PWLogin cmdlet. It's included in the pwps_dab module, which can be run in 64 bit mode. 

You can use the 'Add-PWSavedSearchOrGroup' cmdlet to add an 'OR' to your saved search.

I would recommend using the Undo-PWLogin cmdlet. It's included in the pwps_dab module, which can be run in 64 bit mode. 

You can use the 'Add-PWSavedSearchOrGroup' cmdlet to add an 'OR' to your saved search.