Dynamický dotaz - Majetek - karty drobného majetku dle osoby

ID:

G0MHFMJWANF131MF00C5PPBIWO

Datasety

MAIN

Popis:

Majetek - karty drobného majetku DrM 1

SQL definice:

select
  p.LastName as LastName,
  sc2.inventorynr as outInventoryNr,
  sc2.responsible_id as outResponsible_id,
  sc2.quantity as outQuantity
  {ANDFIELDS}
from
  SmallAssetCards2 SC2
  LEFT JOIN AssetResponsibles AR on SC2.responsible_id = AR.ID
  LEFT JOIN Persons P ON AR.Person_ID = P.ID
  JOIN SmallAssetCards SC ON SC2.Parent_ID = SC.ID
{WHERE}
union all
select
  p.LastName as LastName,
  sc.inventorynr as outInventoryNr,
  sc.responsible_id as outResponsible_id,
  sc.quantity as outQuantity
  {ANDFIELDS}
from
  SmallAssetCards SC
  LEFT JOIN AssetResponsibles AR on SC.responsible_id = AR.ID
  LEFT JOIN Persons P ON AR.Person_ID = P.ID
where
  not exists (select sc_2.id from SmallAssetCards2 SC_2 where SC.ID = SC_2.Parent_ID)
{ANDWHERE}
order by %LastName%

Aliasy:

Alias	CLSID objektu	Prefix	Popis
AR	0AHQJ5OLAREL31ME00C5PPBIWO	AR	Odpovědná osoba
P	WEC02QYERNCL35CH000ILPWJF4	Person	Osoba
SC	4E4R1JFNBREL31ME00C5PPBIWO

Fields:

Jméno	Typ	Velikost	Výraz	CLSID	Popis
LastName	dtString	30			Příjmení
outInventoryNr	dtString	20			Inventární číslo
outQuantity	dtInteger	10			Počet kusů
outResponsible_ID	dtString	10		0AHQJ5OLAREL31ME00C5PPBIWO	Odpovědná osoba

Podmínky

ID

Šablona:

ID

Dataset:

MAIN

Speciální parametry:

CLASSID=4E4R1JFNBREL31ME00C5PPBIWO

Name

Šablona:

Name

Dataset:

MAIN

InventoryNr

Šablona:

InventoryNr

Dataset:

MAIN

Code

Šablona:

Code

Dataset:

MAIN

ProductNumber

Šablona:

ProductNumber

Dataset:

MAIN

AssetLocation_ID

Šablona:

AssetLocation_ID

Dataset:

MAIN

Responsible_ID

Šablona:

Responsible_ID

Dataset:

MAIN

EvidenceDivision_ID

Šablona:

EvidenceDivision_ID

Dataset:

MAIN

ExpensesDivision_ID

Šablona:

ExpensesDivision_ID

Dataset:

MAIN

BusOrder_ID

Šablona:

BusOrder_ID

Dataset:

MAIN

BusTransaction_ID

Šablona:

BusTransaction_ID

Dataset:

MAIN

BusProject_ID

Šablona:

BusProject_ID

Dataset:

MAIN

PurchaseDate$DATE

Popiska:

Datum pořízení

Typ/Subtyp:

ctDateTime/0

ckRange:

(SC.PurchaseDate$DATE >= {:LOW}) and (SC.PurchaseDate$DATE < {:HIGH})

Dataset:

MAIN

Status

Popiska:

Stav karty

Typ/Subtyp:

ctSpecial/1

ckSingle:

SC.Status = {:VALUE}

Dataset:

MAIN

Speciální parametry:

Values=0;1
Names=V evidenci;Vyřazená

DiscardDate$Date

Popiska:

Datum vyřazení

Typ/Subtyp:

ctDateTime/0

ckRange:

(SC.DiscardDate$DATE >= {:LOW}) and (SC.DiscardDate$DATE < {:HIGH})

Dataset:

MAIN

Generated by ABRA Software a.s. 27.10.2021 16:36