Test SQL

Служебный пример JEXL для демонстрации технического приема, преобразования данных или вызова API.

Место применения: Сервис > Инструменты > Выполнить JEXL-скрипт

Тип: JEXL-скрипт

sql(`
with migratePosType as (select
	cast('TK' as varchar) as sCodeOld
	,cast('ТКЧ' as varchar) as sCodeNew
	,cast('Техкомплекты по чертежу' as varchar) as sCaption
)
select t.sCodeOld as "sCodeOld"	,t.sCodeNew as "sCodeNew"	,t.sCaption as "sCaption"	,t1.id as idOld	,t2.id as idNew
from migratePosType t
	left join Mct_PosType t1 on t.sCodeOld = t1.scode
	left join Mct_PosType t2 on t.sCodeNew = t2.scode
 `).foreach(function(r){
@begin{
	println(r.sCodeOld);
	println(r.sCodeNew);
	println(r.sCaption);
  }
@exception
function(exp){
	println("[JEXL Exception] " + exp.getCause());
}end;
}) ;