Welcome, Guest
Username: Password: Remember me
Pleas keep in mind that SPAM will be deleted instantly
  • Page:
  • 1

TOPIC:

Remove All fields option from searchbox 5 years 2 months ago #4016

  • maplevegisa.yahoo
  • maplevegisa.yahoo's Avatar Topic Author
  • Offline
  • Posts: 8
  • Thank you received: 0
Hello I am looking the way to accomplish that the searchbox only perform search by entering a value for specific field PIN.
In catalog-template I have:

{joodb searchbox| PIN}

How can I remove the All fields option from Search box?

This is the link of my project.

demo-hits.com/demo4/index.php/coope-online

Thank you in advance for your help!

Please Log in or Create an account to join the conversation.

Remove All fields option from searchbox 5 years 2 months ago #4019

  • Dirk
  • Dirk's Avatar
  • Offline
  • Posts: 1185
  • Karma: 21
  • Thank you received: 224
It's no problem besause you owe the PRO-Version.
The pro version has a command called SEARCHFIELD

Use {joodb searchfield|PIN}

instead of searchbox!
See
/support/documentation.html?search=searchfield

Please Log in or Create an account to join the conversation.

Last edit: by Dirk.

Remove All fields option from searchbox 5 years 2 months ago #4023

  • maplevegisa.yahoo
  • maplevegisa.yahoo's Avatar Topic Author
  • Offline
  • Posts: 8
  • Thank you received: 0
Thank you! That helped me to reduce the search to 1 field. My goal is that the searchfield returned just the PIN number that is typed.

Something like this:

SELECT * FROM TABLE1

WHERE searchfield entry = PIN

I want to avoid that by leaving the searchfield in blank or just typing 1 or 2 digits of the PIN (PIN consist in 8 digits) returns any row.

I tried the SQL-WHERE Expression option included in the menu by adding PIN = PIN but do not work.

Please take a look here:

demo-hits.com/demo4/index.php/coope-online

Thank you in advance for all your help.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Moderators: Dirkjoest