Stack Overflow
Stack Overflow

Questions tagged [redquerybuilder]

A JavaScript SQL editor UI component.

35 questions
5
votes
3 answers

AngularJS Query Builder similar to http://redquerybuilder.appspot.com/

I am trying to create a complete query builder with AngularJS only. I have seen http://redquerybuilder.appspot.com/ which is awesome but not with AngularJS and I would like to create in AngularJS. Can you please advise if it is already available or…
Maneesh Thareja
  • 51
  • 1
  • 1
  • 5
2
votes
2 answers

Access to request structure in RedQueryBuilder

Does RedQueryBuilder api, which allows access to the tree of the query, not to the finished sql? I want to write secure way to receive SQL requests from the client, forming the final SQL on server. For example, the client may send: { op: "AND", …
Somewater
  • 113
  • 1
  • 7
1
vote
1 answer

Is there a way to use redquerybuilder with Lucene?

Is there any interface to Lucene from redquery builder (https://github.com/salk31/RedQueryBuilder)? I have a Lucene indexed system and would like to support complex Lucene queries using its AND and NOT operators. Alternatively, are there other…
user1001630
  • 493
  • 1
  • 3
  • 16
1
vote
1 answer

Left joins where there is an OR clause

Consider the following Query in RQB using Foreign Keys I have two tables, companies and weather. The foreign key joins the weather to company on zip code The RQB I am entering is: Employees Total - Greater Than - 1000 OR FK Weather.Temp < 50 The…
Severun
  • 2,893
  • 1
  • 16
  • 22
1
vote
1 answer

Validating Inputs entered in REDQueryBuilder

I am using this amazing JavaScript SQL Query Builder UI REDQueryBuilder and I am able to generate the query. However I wish to validate the input textbox. for e.g. If I have configured a column type as Integer, I wish to handle it in client side…
Rinav
  • 2,527
  • 8
  • 33
  • 55
1
vote
1 answer

How can we load Saved searches in JSON format by RedQueryBuilder

when we save a result as a Saved searches like this [ { "label": "Cities in the UK", "sql": "SELECT \"x0\".\"ID\", \"x0\".\"NAME\", \"x0\".\"COUNTRYCODE\", \"x0\".\"DISTRICT\", \"x0\".\"POPULATION\" FROM \"CITY\" \"x0\" INNER JOIN…
PPPPPPPPP
  • 660
  • 7
  • 14
1
vote
1 answer

Setup a starting point expression - Saved searches - RedQueryBuilder

I need when page is loaded there wasn't any selection and one cell was shown already My mean is that I don't need drop down menu or any extra selection, I need in first load one cell based on simple.js come on the page then user with pushing (+) or…
AMH
  • 461
  • 5
  • 12
1
vote
0 answers

RedQueryBuilder validations

I am using the RedQueryBuilder version 0.5.0 http://0-5-0.redquerybuilder.appspot.com/ for building an Expression validator. I want to Know, how to validate the entered expressions? The metadata of the RedQuery Builder 0.5.0 supports css and class…
user_D_A__
  • 460
  • 2
  • 6
  • 14
1
vote
1 answer

What type of SQL does Red Query Builder generate?

I have been trying to use Red Query Builder visual query builder on a project, but we are finding that the SQL output is not consistent with the SQL our database (SQLite) expects. That makes me wonder what dialect of SQL is being generated and how…
picardo
  • 24,530
  • 33
  • 104
  • 151
0
votes
1 answer

Timestamp redquerybuilder

Timestamp is not working RedQueryBuilder .getting error unknown datatype Object { e: "Could not find type 'timestamp'", "__gwt$backingJsError": Error } ​ "__gwt$backingJsError": Error: Could not find type 'timestamp'
venkatesh s
  • 1
  • 1
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

Getting connection refused errors when doing mvn clean install

I downloaded the Tardis branch of RedQueryBuilder and did an mvn clean install. It runs through things for a bit then it gets to this part [INFO] Running com.redspr.redquerybuilder.core.client.GwtTestDom [INFO] logging for HtmlUnit thread [INFO] …
Severun
  • 2,893
  • 1
  • 16
  • 22
0
votes
1 answer

Format table names differently than column names in dropdown?

This may seem like a silly question, but it's taking me way too long to find the answer, so I'm hoping I can get some help here. If I'm understanding correctly, the sample RedQueryBuilder formats the table names that are related to the initial table…
molleyc
  • 349
  • 2
  • 14
0
votes
1 answer

how to customize redQueryBuilder

i just want to customize redquerbuilder. Currently it shows its own default table names like city country etc. i just want to connect this to my own database please help .for database i use MYSQL. Here is the URL of redquerbuilder.…
Anukul Mittal
  • 29
  • 5
0
votes
1 answer

Using QueryBuilder and getting "QueryBuilder is not defined" error

I have query builder sort of working but when I pull up the console the error I get is QueryBuilder is not defined Am I missing a reference to a JS library or am I loading my JS in the wrong order? Here's my javaScript order: 1. doT.js 2.…
Jeff Mcbride
  • 453
  • 2
  • 6
  • 19
1
2 3