[feature request] Compare to other column

[gbegley]

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.

[mistic100]

I can't really explain what is needed to achieve this.

Please tell me if you got any progress, I wouldn't duplicate the work if I got the time to do it myself.

[gbegley]

Thanks for the response. I haven't made any progress on this. But I will certainly share if I manage to figure it out. I am hoping this is can be implemented as a custom field 'input' that simply renders the field list again as a select input but with an appropriate input name.

[andrewaggb]

I just started playing with querybuilder yesterday and I was also wondering about comparing to other fields. I don't think I need it yet, but thought I'd mention my interest as well.

[harveyl888]

I had a similar need whilst putting together an htmlwidget for use in R/Shiny. I have a hacky solution that changes the rule-value-container depending on the operator. There's an example at http://codepen.io/harveyl888/pen/mOejgN. Like I said - it's particularly hacky and I'm sure there's a much better way to do this using plugins but this seems to serve my purpose for the moment.

[mistic100]

I tried : it's extremely complicated to integrate this in a generic way. The number of side effects is outstanding.

[naveendb92]

Any solution for this ? Comparing two fields.
Even I want to do FIELD1 < FIELD2 OR FIELD1 > FIELD3

[mistic100]

Not yet sorry, It's still planned though

[naveendb92]

It will be of great help, if you can add the Column Comparison feature if your next release.
Waiting for this feature.