CONNECTOR_SELECT_FILTER_STRICT ??

Suite and Optimus Suite 5
#1

“STRICT” does not work with connector?

Best regards

#2

Unfortunately there is no such filter in connector.
You will have to create your own filter using beforeFilter event

#3

Can you please give me a little example? :blush:

#4

Please, try to have a look at the following tutorial with a simple sample of the usage:
docs.dhtmlx.com/doku.php?id=dhtm … forefilter

#5

filter function (want to have a custom filter on ‘gesl_disponent’ --> WHERE gesl_disponent = id):

function custom_filter($filter_by){
    $index = $filter_by->index("gesl_disponent");
    if ($index!==false)
    $filter_by->rules[$index]["operation"] = "=";
}

Code:

$res  = mysql_connect($mysql_host, $mysql_user, $mysql_pasw);
mysql_select_db($mysql_db);
     
$grid = new GridConnector($res, "MySQL");

if($_GET['id'] == "7") {
   $disponent = new OptionsConnector($res);
   $disponent->render_sql("SELECT id AS value, ma_nachname AS label FROM sk_mitarbeiter WHERE (ma_job = 3 OR ma_job = 99) and ma_x = 0 ORDER BY label ASC","id","id(value),label(label)");   

   $grid->dynamic_loading(100);
   $grid->set_options("gesl_disponent", $disponent);
   $grid->attach->event("beforeFilter","custom_filter");

   $grid->render_sql("SELECT gesl_wonr, wonr_um, kdnr, excel_date, wo_typ, wo_abt, wo_stat, wo_gebiet, gesl_techniker, gesl_disponent, gesl_termin, wo_start, wo_ende, wo_done, kw, kst, abbruch_id, storno_id, storno2_id, folgeticket_id, anlnr_intern, wartung, gesl_spin_gemeldet, gesl_spin_summe, adr_up, name, kd_strasse, kd_hsnr, kd_hsnr_zus, kd_plz, kd_ort, gesl_arbeiten, gesl_memo, gesl_abbruch FROM sk_gesamtliste AS A INNER JOIN sk_auftraege AS B ON A.gesl_wonr = B.wonr_intern INNER JOIN sk_kundenstamm AS C ON A.gesl_kdnr = C.id WHERE B.gesamtliste = 1 AND YEAR(upload_date) = ".$_GET['jahr']." ORDER BY gesl_wonr DESC","gesl_id","gesl_wonr, wonr_um, kdnr, excel_date, wo_typ, wo_abt, wo_stat, wo_gebiet, gesl_techniker, gesl_disponent, gesl_termin, wo_start, wo_ende, wo_done, kw, kst, abbruch_id, storno_id, storno2_id, folgeticket_id, anlnr_intern, wartung, gesl_spin_gemeldet, gesl_spin_summe, adr_up, name, kd_strasse, kd_hsnr, kd_hsnr_zus, kd_plz, kd_ort, gesl_arbeiten, gesl_memo, gesl_abbruch"); 
}

My grid is always empty :frowning:

#6

Unfortunately the issue cannot be reconstructede locally.

Please, provide a demo link where the issue can be reconstructed.

#7

Wrote you a PM with a link where you can check the grid.
I also get the message seen on the attachment: