Partial/Wildcard Searches in Fluid Real-Time Search
We have recently started actively building and designing fluid components however we are stuck with the three options of building a Fluid Component Search: Keyword (SES), Real Time (Pivot) or Build our own search page.
With Keyword search you can use partial search/wildcard searches however with Real-Time you are stuck with Key Fields and exact values/prompts. Has anyone found a way to use the Pivot Search to use partial searches for key fields or searchable fields?
For example, you want to search for a Person and perform a transaction against them. in classic you would design a search view with EMPLID (KEY), FIRST_NAME, LAST_NAME, DISPLAY_NAME etc. with these additional fields set as alternate search fields. You could search on any partial name and whole name and expect to find someone. In Fluid Real-Time search you don't get that option. You cannot search for say "John" and expect to find "Johnston" as a surname... you would actually need to search for "Johnston"