Dynamický dotaz - CRM - Adresáti kampaní

ID:

FBIUKZCL4XEONATON3RNT4EE3S

Datasety

MAIN

Popis:

SQL definice:

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

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	P0WXCAK4AILOD4AYT2HT1WGI2K
C	2JCEDZ0E4PVODHQFIYTWJINVP0	Campaign	Kampaň
CFB	XGNUWFK0B0E4D0MKD0YZXBLQNC	CampaignFeedBack	Zp. vazba
CT	J3V5BNBVPDEON0TE440RZU0QKK	CampaignType	Typ kampaně
DQ	OFTMKVQH3ZD13ACL03KIU0CLP4	DocQueue	Řada dokladů
F	4K3EXM5PQBCL35CH000ILPWJF4	Firm	Firma
FO	AT011EZZ5DFO115YJ1HCZJDXJ4	FirmOffice	Provozovna
P	CAQPAYUOXVCL3ACL03KIU0CLP4	Period	Období
PE	WEC02QYERNCL35CH000ILPWJF4	Person	Osoba

Podmínky

CampaignType

Šablona:

CampaignType_ID

Dataset:

MAIN

Speciální parametry:

CLASSID=QZN1HCKMN4E4Z4IRQRXOUQCTDC
TextField=Name
DisplayField=Name

CampaignID

Šablona:

CampaignID_Parent

Dataset:

MAIN

Speciální parametry:

CLASSID=2JCEDZ0E4PVODHQFIYTWJINVP0
SITECLASSID=DIWIYKV5DPA4PFSZJXYNDFH2PC
DisplayField=DisplayName
DisplayLength=100
SingleSetupOnly=True

CampaignState

Šablona:

CampaignState

Dataset:

MAIN

TargetAddressType

Popiska:

Typ adresy

Typ/Subtyp:

ctSpecial/14

ckSingle:

##CASEOR {:VALUE} #
##1#A.TargetAddressType = 0
##2#A.TargetAddressType = 1
##3#A.TargetAddressType = 2
##4#A.TargetAddressType = 3
##END#

Dataset:

MAIN

Speciální parametry:

Names=Firma;Provozovna;Osoba;E-mailová adresa
Values=1;2;3;4

FirmID

Šablona:

Firm_ID (joined)

Dataset:

MAIN

FirmOfficeID

Šablona:

FirmOffice_ID

Dataset:

MAIN

PersonID

Šablona:

Person_ID

Dataset:

MAIN

Email

Šablona:

Email

Dataset:

MAIN

Audience State

Šablona:

AudienceState

Dataset:

MAIN

ContactTime

Popiska:

Termín kontaktu

Typ/Subtyp:

ctDateTime/0

ckRange:

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

Dataset:

MAIN

CampaignFeedBack

Šablona:

CampaignFeedBack

Dataset:

MAIN

ID

Šablona:

ID

Dataset:

MAIN

Speciální parametry:

CLASSID=P0WXCAK4AILOD4AYT2HT1WGI2K

Klíče

Parent_ID.CampaignType_ID.Name

Popiska:

Typ kampaně

SQL:

CT.Name Collate PXW_CSY {DIR}, C.CampaignType_ID

Dataset:

MAIN

Parent_ID.DisplayName

Popiska:

Kampaň

SQL:

DQ.Code Collate PXW_CSY {DIR}, 

P.Code Collate PXW_CSY {DIR},

C.OrdNumber

Dataset:

MAIN

Parent_ID.CampaignState

Popiska:

Stav kampaně

SQL:

C.CampaignState {DIR}, A.Parent_ID

Dataset:

MAIN

TargetAddressType

Popiska:

Typ adresáta

SQL:

A.TargetAddressType

Dataset:

MAIN

Firm

Popiska:

Firma

SQL:

F.Name Collate PXW_CSY {DIR}, A.Firm_ID

Dataset:

MAIN

FirmOffice

Popiska:

Provozovna

SQL:

FO.Name Collate PXW_CSY {DIR}, A.FirmOffice_ID

Dataset:

MAIN

Person

Popiska:

Osoba

SQL:

PE.LastName Collate PXW_CSY {DIR},

PE.FirstName Collate PXW_CSY {DIR},

A.Person_ID

Dataset:

MAIN

AudienceState

Popiska:

Stav

SQL:

A.AudienceState

Dataset:

MAIN

ContactTime$DATE

Popiska:

Termín kontaktu

SQL:

A.ContactTime$DATE

Dataset:

MAIN

CampaignFeedBack

Popiska:

Zp. vazba

SQL:

CFB.Name Collate PXW_CSY {DIR}, A.CampaignFeedBack_ID

Dataset:

MAIN

Email

Popiska:

E-mail

SQL:

A.Email Collate PXW_CSY

Dataset:

MAIN

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