Using partial search in search mode as default?

[evance]

Hi there,

at first I was struggling to find some data which I knew was present and couldn't figure out why...

Data in text field (real example):

• A 0111
• B0111
• B0116
• TZ0113
• [...]

Search string (quotes not part of search):

"0111" finds "A 0111" but not "B0111" etc.

But I figured out how to adjust my search so FileMaker will pick up these records accordingly by wrapping it in stars like *TERM* so it performs partial matching:

"*0111*" finds "A 0111" and "B0111"

Now my question is: How can make this the standard search mode / feature without extensively writing scripts for every layout?

I am working with a search layout which includes a lot of fields and I would like to just be able to set "partial search" as default for selected fields or – if that's not possible – for all fields on the search layout, knowing that this can be achieved by using a search script which wraps every input in "*" but that seems kind of over the top.

Thanks for your input!

[Lee Smith]

Hi evance and welcome to the FM Forums,

IIUC, FileMaker will remember a search performed manually. So perform your search manually and then immediately create the script Perform Find.

Lee

 

[evance]

Hi Lee,

thanks for welcoming me and replying to the question!

11 minutes ago, Lee Smith said:

So perform your search manually and then immediately create the script Perform Find.

Guess this won't be feasible as a server-sided approach, or how do you mean that? I'd need a general solution for all users / devices regardless of which field is being searched in, I thought of a "layout-based" setting...?

It's OK if this cannot be done natively and I have to use some script step(s) to do so but I wanted to inquire first.

[evance]

Just for reference's sake / if anybody else is searching for this:

I've put together a simple script which is being called by a script trigger on my input fields in search mode – I adjust the user input so that FileMaker uses partial search if applicable (single word, string not empty).

Set Variable [ $field_context; Value:Get ( ActiveFieldTableName ) ]
Set Variable [ $field_name; Value:Get ( ActiveFieldName ) ]
Set Variable [ $field_content; Value:Get ( ActiveFieldContents ) ]
Set Variable [ $field_length; Value:Length ( $field_content ) ]
Set Variable [ $field_wordcount; Value:WordCount ( $field_content ) ]
Set Field By Name [ $field_context & "::" & $field_name; If ( $field_length = 0 OR $field_wordcount > 1;
$field_content; "*" & $field_content & "*" ) ]

Regards!