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)

@Override
protected String getConfiguredSqlSelect() {
	return "SELECT "
	+ "p.idProd, "
	+ "p.nameProd, "
	+ "NULL, "
	+ "NULL, "
	+ "NULL, "
	+ "NULL, "
	+ "NULL, "
	+ "1, "
	+ "c.nameCat, "
	+ "1 "
	+ "FROM prod p, cat c "
	+ "WHERE c.idCat = p.cat_idCat";
}

\--prod_item1
|
\--prod_item2
|
\--prod_item3
|
\--prod_item...

\Cat_item1
|         \--prod_item1
|         |
|         \--prod_item2
|
\Cat_item2
         \--prod_item3
         |
         \--prod_item...

SELECT
p.idProd,
p.nameProd,
NULL,
NULL,
NULL,
NULL,
NULL,
1,
p.cat_idCat, -- here you provide the id of the parent lookuprow
1
FROM prod p
UNINON
SELECT
c.idCat,
c.nameCat,
NULL,
NULL,
NULL,
NULL,
NULL,
1, -- if you want to disable the "categories lookup rows" put a 0
NULL, -- categories do not have parents.
1
FROM cat c

loadRootNode()