MyTetra Share
Делитесь знаниями!
Объекты по Сберу
Время создания: 06.07.2020 12:22
Раздел: INFO - JOB - rtneo - Выгрузки
Запись: wwwlir/Tetra/master/base/1594009357gkenyq1w28/text.html на raw.githubusercontent.com

select c.realEstate.cadastralNumber, c.realEstate.address, case when c.ownType = 1 then c.areaInRent else c.realEstate.area end, c.validityFrom, c.validityTo, c.category.isLiving, (select count(r) from rtneo$RealEstateContainerYard r where r.contragentRealEstate.id = c.id and r.factRequest = 20) from rtneo$ContragentRealEstate c where c.contragent.id = '296f1b23-7b07-a4d3-7f70-3f57cf6e0495'


select c.realEstate.cadastralNumber, c.realEstate.address, case when c.ownType = 1 then c.areaInRent else c.realEstate.area end, c.validityFrom, c.validityTo, c.category.isLiving, (select count(r) from rtneo$RealEstateContainerYard r where r.contragentRealEstate.id = c.id and r.factRequest = 20), case when c.ownType = 1 then 'Аренда' else 'Собственность' end from rtneo$ContragentRealEstate c where c.contragent.id = '296f1b23-7b07-a4d3-7f70-3f57cf6e0495' and (c.excludeFromAccounting is null or c.excludeFromAccounting = false)

Так же в этом разделе:
 
MyTetra Share v.0.58
Яндекс индекс цитирования