Edit fiddle - JSFiddle[
^]
This is working fine in JSFiddle. But this is not working for me. Please suggest.
HTML Code:
<!DOCTYPE html>
<html>
<head>
<title>Conditions Demo</title>
<!--http:
<script src="http://code.jquery.com/jquery-1.10.1.min.js"></script>
<link rel="stylesheet" type="text/css" href="css/bootstrap.min.css" />
<link rel="stylesheet" type="text/css" href="css/bootstrap-theme.min.css" />
<link rel="stylesheet" type="text/css" href="css/query-builder.css" />
<script src="js/query-builder.js"></script>
<script src="js/query-builder-new.js"></script>
</head>
<body>
<div id="container" class="container search-template">
<div id="content">
<div id="builder"></div>
<form role="form" method="post" id="query-builder-form">
<div class="btn-group">
<input type="button" class="btn btn-warning reset" value="Reset" />
<input type="button" class="btn btn-primary parse-sql" value="Run" />
</div>
<hr />
<textarea class="form-control json-parsed" rows="10" id="json-parsed" name="json-parsed" readonly></textarea>
<hr />
<textarea class="form-control sql-parsed" rows="10" id="sql-parsed" name="sql-parsed" readonly></textarea>
</form>
</div>
</div>
</body>
</html>
JavaScript :
$('#builder').queryBuilder({
sortable: true,
filters: [{
id: 'core_ID',
type: 'integer',
operators: ['equal', 'not_equal', 'in', 'not_in']
}, {
id: 'store_id',
label: 'Store ID',
type: 'string',
operators: ['equal', 'not_equal', 'in', 'not_in']
}]
});
$('#builder').queryBuilder('setRules', {
"condition": "AND",
"rules": [{
"id": "core_ID",
"field": "core_ID",
"type": "integer",
"input": "text",
"operator": "in",
"value": "1240"
}]
});
$('.reset').on('click', function() {
$('#builder').queryBuilder('reset');
$(".json-parsed").empty();
$(".sql-parsed").empty();
});
$('.parse-sql').on('click', function() {
var resJson = $('#builder').queryBuilder('getRules');
$(".json-parsed").html(JSON.stringify(resJson, null, 2));
var resSql = $('#builder').queryBuilder('getSQL', false);
$(".sql-parsed").html(resSql.sql);
});
$(document).ready(function() {
$(".parse-sql").trigger("click");
});
Also included -
[
^]
[
^]
[
^]
and Jquery
What I have tried:
This is working fine in JSFiddle. But this is not working for me. Please suggest.