Dynamický dotaz - PDM - Podací archy

ID:

GHBBLBZNAK34N0OKY4VPW32VK0

Datasety

MAIN

Popis:

Typ podacího archu

SQL definice:

SELECT {FIELDS} FROM
  PDMIssuedDocs A
JOIN PDMIssuedContentTypes ICT ON A.IssuedContent_ID=ICT.ID
WHERE ICT.IncludeInToReports = 'A'
{ANDWHERE}
GROUP BY ICT.ReportNumber
ORDER BY ICT.ReportNumber

Fields:

Jméno	Typ	Velikost	Výraz	CLSID	Popis
RepNumber	dtInteger	10	ICT.ReportNumber		Číslo reportu

ROW

Popis:

Podací arch

SQL definice:

SELECT {FIELDS}
  FROM PDMIssuedDocs A
  {JOIN}
WHERE
  CT.IncludeIntoReports = 'A'
AND CT.ReportNumber=:RepNumber
{ANDWHERE}
ORDER BY C.PostDate$DATE, C.ID, A.ClosingIndex

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	EFMK3ZXZQGE4B1SSCYEBDGMCCK
ADR	4C3EXM5PQBCL35CH000ILPWJF4	Address	Adresa
F	4K3EXM5PQBCL35CH000ILPWJF4	Firm	Firma
C	43CW0W1DJ404JF3XJSEL1RKUJK	PDMClosing	Uzávěrka pošty
CT	MTOSCETT4IC45JVA0Z02W1BUSW	PDMICT	Typy obsahů odeslané pošty

Podmínky

MAIN_Closing_ID

Popiska:

Uzávěrka

Typ/Subtyp:

ctSpecial/13

ckList:

A.Closing_ID IN ({:LIST})

ckSingle:

A.Closing_ID = {:VALUE}

Dataset:

MAIN

Speciální parametry:

CLASSID=43CW0W1DJ404JF3XJSEL1RKUJK
SITECLASSID=1NLCNMQVCK5OTH5APB40ZXAGM4
DisplayField=DisplayName
DisplayLength=16
AlwaysUsed=1
ForceSupportNegation=0
SingleSetupOnly=1

MAIN_IssuedContent_ID

Šablona:

IssuedContent_ID

Dataset:

MAIN

MAIN_PostageInCash

Šablona:

PostageInCash (Reports)

Dataset:

MAIN

ROW_Closing_ID

Popiska:

Uzávěrka

Typ/Subtyp:

ctSpecial/13

ckList:

A.Closing_ID IN ({:LIST})

ckSingle:

A.Closing_ID = {:VALUE}

Dataset:

ROW

Speciální parametry:

Hidden=True
CLASSID=43CW0W1DJ404JF3XJSEL1RKUJK
SITECLASSID=1NLCNMQVCK5OTH5APB40ZXAGM4
DisplayField=DisplayName
DisplayLength=16
AlwaysUsed=1
ForceSupportNegation=0
AssignedFrom=MAIN_Closing_ID

ROW_IssuedContent_ID

Šablona:

IssuedContent_ID

Dataset:

ROW

Speciální parametry:

Hidden=True
AssignedFrom=ROW_IssuedContent_ID

ROW_PostageInCash

Šablona:

PostageInCash (Reports)

Dataset:

ROW

Speciální parametry:

Hidden=True
AssignedFrom=MAIN_PostageInCash

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