How to find a partial match on FTITLE with PublicationOutput 2.5 Find

Question

I am trying to search on an FTITLE using the PublicationOutput Find API.

The search works fine when I use a filter on a specific title.

But I'd like to search for a title that contains a string. For example, something like this:

metadataFilter = "<ishfield name=\"FTITLE\" level=\"logical\" ishoperator=\"in\">Part_of_the_title</ishfield>

This does not work and returns 0 hits.

I have also tried wildcards before and after the search term, and also receive 0 hits.

Is there a way to approximate a "contains" function with this API call?

Or should I be using the Search API instead?

Dave De Meyer · Accepted Answer

Hi Mark, 
 As FTITLE is a string field, you could use Find ishoperator "like". See SDL Documentation (rws.com) . The like operator is case-sensitive, and causes the slowest kind of query in the database. The wildcard operator is "%". The ishoperator "in" is for multi-value fields, something as resolution in Low and High. 
 A Search on PublicationOutputs is not possible, they are not indexed in the Full Text Index. 
 So in PowerShell ISHRemote this would look like Find-IshPublicationOutput -MetadataFilter (Set-IshMetadataFilterField -Level Logical -Name FTITLE -FilterOperator Like -Value "MP330%") 
 -Dave

Tridion Docs > 01 - General Discussion Forum

How to find a partial match on FTITLE with PublicationOutput 2.5 Find

Top Replies