Hi

Since nobody seems to react, maybe I should be clearer:

In the previous versions of Seblod we could use the BEFORE RENDER code field to populate the fields in the the search form with pre computed SQL queries.

This way we could mimic some JOIN searches. However the new 3.2.2 version behaves differently and whatever you write in the before render code field is NOT taken into account!!

For example:
you have a search form with the ART_TITLE field and
a before render code field in which you write $fields['art_title']->value = "toto";

When you display your search form the ART_TITLE field is NOT filled with the value "toto"

With the 42 field we did't find either how to pre fill some fields with PHP/SQL code

If we are right, this would be a MAJOR flaw in the seablod search since it forces you to put all the custom queries in the template, after the seblod search.

So does someone know how to perform custom searches in the search tab ?

thanks

cyril

Hi -- I was thinking of buying the Code Pack plugin (http://www.seblod.com/products/1854) for a project, but are you saying the Before Render feature currently doesn't work?
Thanks!

Hi,

have you tried using this plugin http://www.seblod.com/products/1854 ? 

Hi 

Of course, this is what I wrote ! The code field is no longer taken into account in a search form.

Now the code field is read AFTER the seach is performed!

cyril

Hi again 

the answer was http://www.seblod.com/products/922 !!

Hi

I come back to this topic because there are cases where there is MORE than a joint in the SQL query.

What is the right way to customize the search form with a custom SQL query ?

What we need is a SQL FIELD that will allow us to write our own query based on fields that we already put in the search form

for example you put :

• field1
• field2
• field3
• SQL field