companysql
select r{Name of Company} from t{Company Master@@ERP Admin} where lower(c{Name of Company}) like lower('${Name of Company}%') order by c{Name of Company}
projectsql
select r{Project Name} from t{Project Master@@ERP Admin} where lower(c{Project Name}) like lower('${Project Name}%') and c{Name of Company}=${Name of Company} order by c{Project Name}
selfsql
NATIVE:select distinct(a.c{"+Field_name()+"}) from t{"+Form_name()+"@@"+Module_name()+"} as a where lower(a.c{"+Field_name()+"}) like lower('${"+Field_name()+"}%') order by a.c{"+Field_name()+"} LIMIT 40
sql:Code Field:Name Field:Form:Module
No example
hql:Code Field:Name Field:Form:Module
No example
