AnsweredAssumed Answered

Wildcard Find

Question asked by silverglyde on Dec 26, 2017
Latest reply on Dec 26, 2017 by philmodjunk

Entering "*144" in find mode ProjectNumber field finds two records:  144 and P000144

(ProjectNumber is a Text field.)

 

Entering  "*144" in global field FindThis finds zero records??

FindThis has OnObjectExit script trigger, which fires.

The script enters Find Mode, sets the ProjectNumber field to the FindThis field (displayed value is indistinguishable from the manually entered) and then performs the find.

Have also tried adding asterisk to entered "144" via Set Variable and using that to set the ProjectNumber field (which is actually the behavior I'm after)...also nothing (finds no records).

 

By the way, I want to find any occurance of 144 (*144*?)

 

Thanks in advance!

Outcomes