Negation doubled when using setRulesFromSQL

[ben-luck]

There seems to be an issue when using the setRulesFromSQL with the not-group plugin. I tried it on this jsfiddle - https://jsfiddle.net/k2f46297/

For example,

$('#queryBuilderGoesHere').queryBuilder('setRulesFromSQL', 'NOT (price>100)');

would change the query to NOT ( ( NOT ( price > 100 ) ) )

Here is the script -

var myFilters = [{
    id: 'price',
    label: 'price',
    type: 'double'
}, {
    id: 'name',
    label: 'Name',
    type: 'string'
}, {
    id: 'email',
    label: 'email',
    type: 'string'
}];
$("#queryBuilderGoesHere").queryBuilder({
    plugins: ['not-group'],
    filters: myFilters
});

$('#queryBuilderGoesHere').queryBuilder('setRulesFromSQL', 'NOT (price>100)');
$("#getsql").on('click', function () {
    var sqlob = $("#queryBuilderGoesHere").queryBuilder("getSQL", false);
    $("#sql").text(sqlob.sql);
});

Thanks!

[ben-luck]

By the way, I am using query-builder.standalone.min.js. This is my workaround for now, not ideal but seems to workaround it -

var rule = $('#queryBuilderGoesHere').queryBuilder('getRulesFromSQL','NOT (price>100)');
if (rule != null) {
	rule.not=false;	
	$('#queryBuilderGoesHere').queryBuilder('setRules', rule);
}

[mistic100]

<code> is not how you put code in Github, you must use single or triple back quote https://guides.github.com/features/mastering-markdown/#GitHub-flavored-markdown

---

I'll work on this.

[ben-luck]

Thank you!

[ben-luck]

Great! @mistic100 , couple questions -

1. Do you have a release date for 2.5.2?
2. Will it be hard to convert the NOT checkbox button to a regular btn to be consistent with the AND and OR buttons?

Thanks!