mistic100 / mistic100/jQuery-QueryBuilder

[feature request] Compare to other column

Open
#221 13 comments 4 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

feature
Dominant language
JavaScript
Stars
1.7k
Forks
544
PR merge metrics
No merged PRs in 30d

Description

This repo is fantastic!

My application's database fetch operations have a very common (to my app) use case where the user wants to compare two fields, usually as "FIELD1 < FIELD2 OR FIELD1 > FIELD3"

I'd like to add a plugin adding additional 'field comparison' operators (one for each of the tradition operators, but specifying a field comparison rather that comparison to an explicit value) that, when one of these operators is selected, will trigger a rule's value to render an additional column/field selection, so that the two columns can be compared by the users selected operator.

I'd also like to integrate with the SQL parser so that queries containing column to column comparisons can be parsed by the SQL parser and rendered as rules in the SQL builder.

I know I need to perform some operations on the
afterUpdateRuleOperator.queryBuilder
event, but not sure where to go from there.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the afterUpdateRuleOperator.queryBuilder event mentioned in the issue and trace how operators render their rule values and how the SQL parser produces rules. Define the column-comparison operators and their additional field selection, then integrate parsing and SQL-builder rendering. Done means column-to-column comparisons work through both the UI and SQL parser.

Written by the indexing model from the issue text.

Assessment

Tech stack
javascript, jquery, sql
Domain
databases, frontend
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.