3.2.3.2. CMJ

Получение значений из кастомных полей

Значения

SQL - запрос

tn_field_string

select tfs."value" as v
from tn_field_string tfs
join tn_field tf on tf.id = tfs.id
where tf."owner" = rkkbase.id and tf.cmjfield = 'stage'

tn_field_decimal

select tfd."value" as v
from tn_field_decimal tfd
join tn_field tf on tf.id = tfd.id 
where tf."owner" = rkkbase.id and tf.cmjfield = 'index'

Статус	ЧЕРНОВИК
Раздел