WHERE t.from_date < :validityTO AND t.to_date > :validityFROM

Select Root From MyTable

Select Root, Child From MyTable

Select Child From MyTable Where Root='****'

+-----+-------+-----------+
| id  | name  | parent_id |
+-----+-------+-----------+
| 125 | Lorem | -         |
| 548 | Ipsum | -         |
| 587 | Dolor | 125       |
| 874 | Artis | 125       |
+-----+-------+-----------+

+-+ Lorem
| |
| +----- Dolor
| |
| \----- Artis
|
\-- Ipsum 

SELECT id, text, NULL, NULL, NULL, NULL, NULL, 1, parent_id, 1 
FROM my_table

getMyTreeBoxField().getTree().getSelectedNode()

@Order(10.0)
public class TestField extends AbstractTreeBox<Long> {

  @Override
  protected void execInitField() throws ProcessingException {
    super.execInitField();
    getTree().setCheckable(false);
    // solution 01 add a listener
    getTree().addTreeListener(new TreeAdapter() {
      @Override
      public void treeChanged(TreeEvent e) {
        if (e.getType() == TreeEvent.TYPE_NODE_ACTION) {
          System.out.println("node aciton on '" + e.getNode().getNodeId() + "'");
        }
      }
    });
  }
  .....
}

@Order(10.0)
public class TestField extends AbstractTreeBox<Long> {

  ....

  // solution 02 override the default tree
  public class Tree extends DefaultTreeBoxTree {

    @Override
    protected void execNodeAction(ITreeNode node) throws ProcessingException {
      System.out.println("node action");
    }
  }
}

public void treeExpanded(TreeEvent e)