View | Details | Raw Unified | Return to bug 31028
Collapse All | Expand All

(-)a/koha-tmpl/intranet-tmpl/prog/js/datatables.js (-6 / +11 lines)
Lines 584-595 jQuery.fn.dataTable.ext.errMode = function(settings, note, message) { Link Here
584
                                        var part = {};
584
                                        var part = {};
585
                                        var attr = attributes[i];
585
                                        var attr = attributes[i];
586
                                        let criteria = options.criteria;
586
                                        let criteria = options.criteria;
587
                                        if ( value.match(/^\^(.*)\$$/) ) {
587
                                        if ( value === 'special:undefined' ) {
588
                                            value = value.replace(/^\^/, '').replace(/\$$/, '');
588
                                            value = null;
589
                                            criteria = "exact";
589
                                            criteria = "exact";
590
                                        } else {
590
                                        }
591
                                           // escape SQL LIKE special characters % and _
591
                                        if ( value !== null ) {
592
                                           value = value.replace(/(\%|\_|\\)/g, "\\$1");
592
                                            if ( value.match(/^\^(.*)\$$/) ) {
593
                                                value = value.replace(/^\^/, '').replace(/\$$/, '');
594
                                                criteria = "exact";
595
                                            } else {
596
                                               // escape SQL LIKE special characters % and _
597
                                               value = value.replace(/(\%|\_|\\)/g, "\\$1");
598
                                            }
593
                                        }
599
                                        }
594
                                        part[!attr.includes('.')?'me.'+attr:attr] = criteria === 'exact'
600
                                        part[!attr.includes('.')?'me.'+attr:attr] = criteria === 'exact'
595
                                            ? value
601
                                            ? value
596
- 

Return to bug 31028