How to setup custom value editor

EasyQuery allows you to define custom value editor for some attribute and then create your own UI to edit condition values for this attribute. Here are the step-by-step instructions:

  1. Run Data Model Editor (DME) and open your model file.
  2. Go to Entites tab and find necessary attribute.
  3. At the right panel for this attribute open “Value Editors” tab and select “Custom (user defined)” in “Default value editor” combo-box.
  4. Save your model and close DME.
  5. Open your project in Visual Studio and select QueryPanel component on form designer.
  6. Add an event handler for ValueRequest event (use Events tab in Properties panel).

Here is an example of ValueRequest event handler:

private void QPanel_ValueRequest(object sender, ValueRequestEventArgs e) {
    //checking if this condition row is associated with some SimpleCondition object
    if (((QueryPanel)sender).ActiveRow is QueryPanel.SimpleConditionRow) {
        SimpleCondition cond = (SimpleCondition)e.Condition;
 
        //if we need our entity attribute - we can get it from BaseAttr property of SimpleCondition object
        EntityAttr attr = cond.BaseAttr;
 
        //bring your own dialog to edit condition value
        //you can use event parameter properties Value and Text to get current value
        .  .  .  .  .  .  .  .
        //after the dialog is closed - return new value and (if necessary) text via event's parameter
        e.Value = "<new value>";
        e.Text = "<new text>"; //you can omit this
    }
}

Discussion

, 2017/04/04 16:02
Can we execute user written query by copy paste into SQL panel in easy query.
, 2017/04/04 16:13
Can we execute user written query by copy & paste in SQL panel in EasyQuery builder
Enter your comment: