#1 EXAMPLE:
/*----#start-code(index)----*/
view.clients.setQuery(Core.query(null,"SELECT id as ID, name as NAME")
.from("tbl_customer0")
.union()
.select(" 'id' as ID, 'designationName' as NAME ")
.from("tbl_customer1")
.unionAll()
.select(" 'id' as ID, 'firstName' as NAME")
.from("tbl_customer2")
);
/*----#end-code----*/
#2 EXAMPLE:
/*----#start-code(index)----*/
view.tag.setQuery(Core.query(null,
"SELECT '' as ID, '-- Selecionar --' as NAME union
SELECT '_self' as ID, 'Mesma contpágina' as NAME union
SELECT '_blank' as ID,'Popup' as NAME union
SELECT '_newtab' as ID, 'New tab' as NAME"));
/*----#end-code----*/
view.estado.setQuery(Core.query(null,
"SELECT 'ATIVE' as ID,'Ativo' as NAME
UNION SELECT 'INATIVE' as ID,'Inativo' as NAME "),"-- Selecionar--");