Dynamický dotaz - Evidence času

ID:

H1IKC00ORYU4PA2DALNGN3Y1N0

Datasety

MAIN

Popis:

Evidence času

SQL definice:

SELECT {FIELDS} FROM
  DevTimeRecords A
  {JOIN}
{WHERE}
{ORDERBY}

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	BDP1DNXF5YBOVGF5U4PZGAF2GO
DB	GHGX5UKIMBDL3HGF01K0LEIOE0	DevBug	Vývojový požadavek
DBP	CAQPAYUOXVCL3ACL03KIU0CLP4	DevBugPer	Období výv. požadavku
DBQ	OFTMKVQH3ZD13ACL03KIU0CLP4	DevBugQue	Řada výv. požadavku
DD	S2MBTCTKOZDL3HGF01K0LEIOE0	DevDoc	Vývojová dokumentace
DDP	CAQPAYUOXVCL3ACL03KIU0CLP4	DevDocPer	Období výv. dokumentace
DDQ	OFTMKVQH3ZD13ACL03KIU0CLP4	DevDocQue	Řada výv. dokumentace
SU	22AHIVDVAVE13C5S00CA141B44	SecUser	Pracovník

Fields:

Jméno	Typ	Velikost	Výraz	CLSID	Popis
DevDocumentNumber1	dtString	10	COALESCE(DBQ.Code, DDQ.Code, '')		Doklad projektové dokumentace 1
DevDocumentNumber2	dtString	10	COALESCE(DBP.Code, DDP.Code, '')		Doklad projektové dokumentace 2
DevDocumentNumber3	dtString	10	COALESCE(DB.OrdNumber, DD.OrdNumber, 0)		Doklad projektové dokumentace 2

Podmínky

ID

Šablona:

ID

Dataset:

MAIN

Worker_ID

Popiska:

Pracovník

Typ/Subtyp:

ctSpecial/0

ckSingle:

A.Worker_ID = {:VALUE}

ckList:

A.Worker_ID IN ({:LIST})

Dataset:

MAIN

Speciální parametry:

CLASSID=G1W2A2CBNNDL3DZ403KIU0CLP4
TextField=LoginName

Description

Šablona:

Description

Dataset:

MAIN

Product_ID

Popiska:

Produkt

Typ/Subtyp:

ctSpecial/0

ckSingle:

((DB.Product_ID = {:VALUE}) and (A.DevDocumentType = 'ER')) or
((DD.Product_ID = {:VALUE}) and (A.DevDocumentType = 'DD'))

ckList:

((DB.Product_ID IN ({:LIST})) and (A.DevDocumentType = 'ER')) or
((DD.Product_ID IN ({:LIST})) and (A.DevDocumentType = 'DD'))

Dataset:

MAIN

Speciální parametry:

CLASSID=C5DW05OOLJDL331C00C5OG4NF4
TextField=Code

Part_ID

Popiska:

Část produktu

Typ/Subtyp:

ctSpecial/0

ckSingle:

((DB.Part_ID = {:VALUE}) and (A.DevDocumentType = 'ER')) or
((DD.Part_ID = {:VALUE}) and (A.DevDocumentType = 'DD'))

ckList:

((DB.Part_ID IN ({:LIST})) and (A.DevDocumentType = 'ER')) or
((DD.Part_ID IN ({:LIST})) and (A.DevDocumentType = 'DD'))

Dataset:

MAIN

Speciální parametry:

CLASSID=SPQZP5A3LJDL3HGF01K0LEIOE0
TextField=Code

Version_ID

Popiska:

Verze

Typ/Subtyp:

ctSpecial/0

ckList:

((DB.Version_ID IN ({:LIST})) and (A.DevDocumentType = 'ER')) or
((DD.Version_ID IN ({:LIST})) and (A.DevDocumentType = 'DD'))

ckSingle:

((DB.Version_ID = {:VALUE}) and (A.DevDocumentType = 'ER')) or
((DD.Version_ID = {:VALUE}) and (A.DevDocumentType = 'DD'))

Dataset:

MAIN

Speciální parametry:

CLASSID=CKEXB5RVLRDL3HGF01K0LEIOE0
TextField=Code

Status

Popiska:

Stav

Typ/Subtyp:

ctSpecial/14

ckSingle:

##CASEOR {:VALUE} #
##1#(((DB.Status = 2) or (DB.Status = 5)) and (A.DevDocumentType = 'ER')) or (((DD.Tested = 2) or (DD.Tested = 3) or (DD.Tested = 5))and (A.DevDocumentType = 'DD')) 
##2#(((DB.Status = 1) or (DB.Status = 3) or (DB.Status = 4) or (DB.Status = 6) or (DB.Status = 7)) and (A.DevDocumentType = 'ER')) or (((DD.Tested = 1) or (DD.Tested = 4))and (A.DevDocumentType = 'DD'))
##END#

Dataset:

MAIN

Speciální parametry:

Names=Hotovo;V procesu
Values=1;2

Topics

Popiska:

Téma

Typ/Subtyp:

ctString/0

ckSingle:

(DD.Topics = {:VALUE}) or (DB.Topics = {:VALUE}) 

Dataset:

MAIN

Firm_ID

Popiska:

Firma

Typ/Subtyp:

ctSpecial/0

ckSingle:

((A.DevDocumentType = 'ER') and 
(DB.Firm_ID IN (SELECT ID FROM Firms WHERE ID={:VALUE} OR Firm_ID={:VALUE})))
or
((A.DevDocumentType = 'DD') and 
(DD.Firm_ID IN (SELECT ID FROM Firms WHERE ID={:VALUE} OR Firm_ID={:VALUE})))

ckList:

((A.DevDocumentType = 'ER') and 
(DB.Firm_ID IN (SELECT ID FROM Firms WHERE ID IN ({:LIST}) OR Firm_ID IN ({:LIST}))))
or
((A.DevDocumentType = 'DD') and 
(DD.Firm_ID IN (SELECT ID FROM Firms WHERE ID IN ({:LIST}) OR Firm_ID IN ({:LIST}))))

Dataset:

MAIN

Speciální parametry:

CLASSID=O3OWQQYWYJCL3J0B01K0LEIOE0
TextField=Code

CreatedBy_ID

Šablona:

CreatedBy_ID

Dataset:

MAIN

CorrectedBy_ID

Šablona:

CorrectedBy_ID

Dataset:

MAIN

DateOfRecord

Popiska:

Datum

Typ/Subtyp:

ctDateTime/0

ckRange:

(A.DateOfRecord$DATE >= {:LOW}) and
(A.DateOfRecord$DATE < {:HIGH})

Dataset:

MAIN

DevDocumentType

Popiska:

Typ dokladu projektové dokumentace

Typ/Subtyp:

ctString/0

ckSingle:

A.DevDocumentType = {:VALUE}

Dataset:

MAIN

Speciální parametry:

Hidden=True

DevDocument_ID

Popiska:

Dokument projektové dokumentace

Typ/Subtyp:

ctString/0

ckSingle:

A.DevDocument_ID = {:VALUE}

ckList:

A.DevDocument_ID IN ({:LIST})

Dataset:

MAIN

Speciální parametry:

Hidden=True

Klíče

DateOfRecord$Date

Popiska:

Ve dni

SQL:

A.DateOfRecord$Date

Dataset:

MAIN

Worker_ID

Popiska:

Pracovník

SQL:

SU.Name Collate PXW_CSY {DIR}, A.Worker_ID

Dataset:

MAIN

DevDocumentNumber

Popiska:

Doklad projektové dokumentace

SQL:

%DevDocumentNumber1% {DIR},%DevDocumentNumber2% {DIR}, %DevDocumentNumber3%

Dataset:

MAIN

CreatedBy_ID

Popiska:

Vytvořil

SQL:

A.CreatedBy_ID

Dataset:

MAIN

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