Forums

Hi John,

I am trying to plug calendar in the query builder. The way I am thinking to implement this

First Identify which variable user has selected for that criterion row

If the variable needs calendar then disable the value input box and put icon at the side of this box for popup calendar.

My question is what is the best way to identify what variable user has selected.

If there is other way to implement it please let me know

Mayank

Hi John,

That's great that you are planning to build date picker for query builder. mean time I came up with following solution
http://ideone.com/Kr454

1) I am extending QueryBuilder and overided appendNew method where I am firing changeSelect event if some one changes the newly appended selected box (which contains all the keys).

2) I am handling that changeSelect event such that if selected keys needs the date picker then I am creating one. After that just syncing between calendar date and value text.


Mayank

Also, you should really implement the Calendar as a QueryBuilder plugin. You could base it on the QueryBuilder.String class:

http://jafl.github.com/yui3-gallery/yui ... ng.js.html

Very nice! My only suggestion is that you switch from 'click' on the input to 'focus'.

Hi John,

The only issue now I've that Query builder is created using table now because of calendar BETWEEN operator I have two values for the date variable and other variable has one value that causing unequal number of <td> tags for under <tr> tags and thats causing some formatting issue.

Do you have any idea how to handle this problem ?


Mayank