Stack Overflow
Stack Overflow

Questions tagged [jquery-query-builder]

QueryBuilder is an UI component to create queries and filters. jQuery-Plugin.

37 questions
0
votes
1 answer

How to parse or generate dynamic SQL from react querybuilder output json

for one of my project we are using react-querybuilder lib and the end result will be sent to server to filter data accordingly, my backend use Sequelize, Express with JavaScript. My concern is how to make sql queries or Sequelize command from the…
Samuel Josh
  • 17
  • 3
0
votes
0 answers

Compare queryBuilder JSON string against the JSON payload in the hierarchical structure

I am working with jquery based queryBuilder and created a query JSON String, which is then passed to a Spring-Boot Service class. There I have a JSON Payload which contains numerous details along with the keys and values, I selected through…
manu
  • 1
  • 1
0
votes
1 answer

Getting error in filter initialization in query builder

I am getting a string like this "{id: 'breakthrough_designation_y_n',label: 'Breakthrough Designation Y/N',type: 'string',input: 'radio',values:{'Yes': 'Yes','No': 'No'},operators: ['equal']},{id: 'breakthrough_designation_y_n',label: 'Breakthrough…
Prince Gajjar
  • 46
  • 8
0
votes
1 answer

Querybuilder.js - How can I limit the conditions to have "AND" in the root, and "OR" in the subgroups?

I am used to working in C#, and just got handed this project with querybuilder. I have been searching for hours and can't seem to figure out how to achieve this. What I want is for the root condition to be "AND" - which is default. But since it is…
Malin
  • 97
  • 1
  • 8
0
votes
1 answer

Is it possible to build SQL statements including 'XOR' condition with jQuery QueryBuilder

I want to get an SQL statement using the jQuery QueryBuilder plugin. Everything works exactly as I want when using the default conditions 'AND' and 'OR'. However, when I try to use the 'XOR' condition I get an error (see below). This is my code for…
Noah Klop
  • 3
  • 2
0
votes
1 answer

jquery querybuilder: editing the Rule's structure in the file query-builder.standalone

I created a custom plugin for Jquery Querybuilder but it only works if I edit the Rule's structure from the file querybuilder-standalone itself. The plugin I've created adds a button like the one from the plugin not-group inside each rule. The…
Vanessa Maccherini
  • 1
0
votes
2 answers

How to implement JQuery Query Builder rule filter autocomplete

How to implemente autocomplete implementation for JQuery quer builder with rule filter?
Muni Chittem
  • 988
  • 9
  • 17
0
votes
1 answer

jquery builder with bootstrap 4.5 not working

Here is jsfiddle attempting to use jquery querybuilder with bootstrap…
David Budd
  • 1
  • 1
0
votes
0 answers

Develop clone of JQuery Query Builder Interface

I want to develop a searchfilter similar to JQuery QueryBuilder, but I encounter this error, which leads to the main.js: filter.html:35 Uncaught SyntaxError: Unexpected identifier So far I have: filter.html
…
regis_studios
  • 5
  • 1
  • 6
0
votes
1 answer

Querybuilder.js Adding both AND and OR statements

Using querybuilder.js example (https://querybuilder.js.org/) I do not see a way to have both AND and OR statement. For example, If I wanted to build a query that includes: (Name = "Name 1" AND Name = "Name 2") OR (Price = 1.00) I don't see a way…
jason
  • 3,821
  • 10
  • 63
  • 120
0
votes
1 answer

Subquery in JQuery QueryBuilder

I am going to use the JQuery Query Builder plugin in my project. I want to know how query will generate for relational table. For example, I have two tables user and user_emails. I want to filter those users which have an email address. To get this…
abdul wahid
  • 21
  • 5
0
votes
1 answer

How to get the optgroups object of the selected fields in the getRule json object output?

I have requirement to get the optgroup of selected field in the query builder, but as of I am aware queryBuilder('getRules') doesn't provide. For example:- I want to get optgroups object of selected field 'price' in the json output. How to get it?…
kaushik_pm
  • 295
  • 3
  • 10
0
votes
1 answer

Angular-QueryBuilder: Dynamically changing fields

Is there a way to dynamically change which fields are available to Angular-QueryBuilder? I've tried: Updating the fields property of my QueryBuilderConfig. Nothing happens. Removing and re-adding the component using ngIf and…
Eric Eskildsen
  • 4,269
  • 2
  • 38
  • 55
0
votes
1 answer

Is there a way to describe the chosen jQuery Query Builder filters as plain text?

Base on this screenshot, can we have a description like: Price less 10.25 AND (Category equals Movies OR Category equals Books)
Pirun Seng
  • 443
  • 1
  • 4
  • 20
0
votes
1 answer

Dynamic Query Builder for ASP.Net-MVC - Using jQuery QueryBuilder, DataTables, and dynamic-linq-query-builder

I'm trying to accomplish the following Tasks: Create a visual expression/ query builder for ASP.NET-MVC. Pass the resulting query to DataTables. This question is about Task 1 as that's where I'm stuck. I have posted Task 2 to provide more…
ipetduckies
  • 21
  • 6
1
2
3