Better understaning how Dataassist builds queries
I'm trying to better understand how DataAssist builds queries so that I can tweak and refine them in the PHP code.
DataAssist makes something like this:
$query_WADAtable = "SELECT field1, field2, FROM table a, history b WHERE field1=field2
setQueryBuilderSource($query_WADAtable,$WADbSearch1,false);
$query_limit_WADAtable = sprintf("%s LIMIT %d, %d", $query_WADAvoters, $startRow_WADAvoters, $maxRows_WADAvoters);
Elsewhere, there is something like this:
$WADbSearch1->addComparisonFromEdit("registr_date","registr_date","AND",">=",2);
$WADbSearch1->addComparisonFromEdit("municipality_abbrv","municipality_abbrv","AND","=",0);
How is "addComparisonFromEdit" added to the query? Is it added as part of the WHERE clause? In any particular order?
Is there some documentation that explains what's happening? (I'm also interested in understanding the parameters for setQueryBuilderSource and addComparisonFrom.)
Thanks in advance.