Jump to content
neti_treves

search additional fields

Recommended Posts

Hi all,

I've created some more db fields for my products.

How can I have the search query go through these new fields as well?

Thanks

Share this post


Link to post
Share on other sites

Ooops! I lost track of this project.

Several versions back, I created a Code Snippet that adds the fields to the searchable collection of fields. I need to double check that it still works for CC625.

If you want to verify if, in the snippet's current version, works for you, send me a Private Message with your email address.

Share this post


Link to post
Share on other sites

Well, it's not what I thought it was.

But I will keep working on a solution.

Share this post


Link to post
Share on other sites

In /classes/catalogue.class.php, the public function searchCatalogue(), has the code to take the search terms, incorporate other search criteria, builds the JOINs of other tables, if necessary, and builds the WHERE clause, and sends the query to the database.

This function is attempted up to three times, each using a different database search mechanism: FULLTEXT (will not work with other than fulltext indexes), then if nothing found uses RLIKE (regular expressions), then if nothing found uses a more lenient LIKE (simple wildcards).

 

Edited by bsmither

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...