Query builder - has anyone made more user friendly?

[SusanMordy1]

Has anyone modified the SFV 1.3 query builder widget so when the user clicks on an operator (eg '+' or '='), the operater displays in the query box?

By default, the user has to select the values BEFORE the operator is selected.

This 'backwards" seeming step is not very intuitive or user friendly.

Has anyone modified this widget so after the users selects the field, they can select the operator THEN the value?

Thanks!

Susan

[MarkHoyland]

Hi Susan,
Here is a modified one which I have done. The layout is changed to allow selecting the operator.

Includes an alphabetised DISTINCT list of values.

You can also highlight the formula and replace the highlighted bit.
I have tried to indicate the additions or changes in the code.

Please make a backup copy of your existing QueryBuilderWidget.mxml, before testing.

EDIT:In the .zip file is the modified QueryBuilderWidget.mxml file.
I loaded as a zip and the .zip kept corrupting during the upload!
mxml files can not be loaded directly as attachments!
Tried to load as .txt but it is bigger than 12.5kb so it wouldnt let me!
Last chance I have renamed to .doc

You will have to rename the QueryBuilderWidget.doc file to QueryBuilderWidget.mxml

[SusanMordy1]

Genuis!!!!

Thanks so much, works great!

Susan