Search field with Run hash cookies

Questions related to using nuBuilder Forte.

Search field with Run hash cookies

Postby Janusz » Sat Jan 26, 2019 2:34 am

Hi,
On the edit form I have name field defined in which there is first and last name, ex.
con_name John Brown

and with (Run /Button)
I have (in Run tab) Filter defined as #con_name#
and it is equivallent to entering into the search field on browse form:
John Brown
is it possible to define the Run/Button/Filter code to be let say equivallent to:
" #con_name# "

I mean something what will finally generate followig:
"John Brown"
As the last one gives more accurate search result.
Janusz
 
Posts: 194
Joined: Fri Dec 28, 2018 10:11 pm
Location: Krakow, Poland

Re: Search field with Run hash cookies

Postby ARWEN » Fri Feb 01, 2019 2:19 pm

The developer does not seem to be much present in the forums these days.
Therefore try this "hack": Create a separate column in your Browse that contains the string without white spaces. Use REPLACE to get rid of spaces and CONCAT to join multiple fields.
Also remove the white spaces in the hash cookie with js replace function.
ARWEN
 
Posts: 48
Joined: Thu Nov 01, 2018 2:31 pm

Re: Search field with Run hash cookies

Postby Janusz » Sun Feb 03, 2019 7:21 pm

Hi,
Thanks for your reply.
After some more trials I foud that it is working with following notation:

\"#con_name#\"

placed directly in the Object/Run/Filter
Janusz
 
Posts: 194
Joined: Fri Dec 28, 2018 10:11 pm
Location: Krakow, Poland

Re: Search field with Run hash cookies

Postby kev1n » Sat Feb 09, 2019 2:30 am

Thank you for sharing your findings!
kev1n
 
Posts: 198
Joined: Mon Oct 15, 2018 2:13 am


Return to General



cron