Ok this works.
I added default where clause but had to manualy fix it in code
"$WADbSearch1_DefaultWhere = "idsct_cmp = ".$_GET["S_idsct_cmp"];"
because i need to get the parameter also from the get (initial filtering without user interactin). But if i put the .$_GET["S_idsct_cmp"] the behavior stops showing on the DWCS4 panel. Minor problem but still its a small bug. I supposse DWCS4 wants some stuff in specific ways so probably need to work it as DW parameters code and then use it in there but im not a DW code expert your tech guys should know why and how to fix it to a next release.
But ... there is a problem with INCLUDE in search engine. I got a column named name_suf and im using a text field(edit in search behavior) using the "INCLUDE" option to search in it.
It just doesn't work. I even fixed a FULL-TEXT index in my db on that column in case it is required.
example : search function passes the above line
?S_municipality_cmp=&S_idsct_cmp=28&S_name_cmp=pk
S_name_cmp is the field/attribute that gets the users input from the text box. Here the user typed "pk" and the search engine should search in my table the appropriate column for the text "pk" inside it. i don't know what it does but it is not working.
Here is the code on top at php portion
$WADbSearch1->addComparisonFromEdit("name_cmp","S_name_cmp","AND","Includes",0);
so it should be passed ok in the search.
Need it to work asap please.