Получить настройки задач - 1с Отчетность на QlikView и Qlik Sense

TASK

QUALIFY *;
UNQUALIFY ;

DocTask:
LOAD Name,
    Enabled,
    NameIsAutoGenerated,
    AllowPluginClient,
    AllowMobileClient,
    AllowZeroFootprintClient,
    AllowPDFGeneration,
    SendNotificationEmail,
    AlwaysOpenable,
    SourceDocumentID,
    ClearLocks,
    ClearAll,
    ClearAlwaysOneSelected,
    ReapplySelections,
    EnableAuditLogging,
    SetScript,
    SectionAccessUserName,
    SectionAccessPassword,
    OverrideXSSectionAccess,
    MaxOpenSessions,
    SessionTimeout,
    DocumentTimeout,
    ReloadOption,
    Distribute,
    DistributionServiceID,
    TaskTrack,
    TimeoutMinutes,
    NumberOfAttempts,
    CreationMode,
    DownloadAccess,
    ExportAccess,
    VersionID,
    EnableSessionCollaboration,
    ModifiedByUser,
    ModifiedTime,
    ID
FROM [C:\XML_SAVED\DocumentTask.xml] (XmlSimple, Table is [NewDataSet/DocumentTask]);

UNQUALIFY *;

QUALIFY *;

UNQUALIFY ;

DocTask:

LOAD Name,

Enabled,

NameIsAutoGenerated,

AllowPluginClient,

AllowMobileClient,

AllowZeroFootprintClient,

AllowPDFGeneration,

SendNotificationEmail,

AlwaysOpenable,

SourceDocumentID,

ClearLocks,

ClearAll,

ClearAlwaysOneSelected,

ReapplySelections,

EnableAuditLogging,

SetScript,

SectionAccessUserName,

SectionAccessPassword,

OverrideXSSectionAccess,

MaxOpenSessions,

SessionTimeout,

DocumentTimeout,

ReloadOption,

Distribute,

DistributionServiceID,

TaskTrack,

TimeoutMinutes,

NumberOfAttempts,

CreationMode,

DownloadAccess,

ExportAccess,

VersionID,

EnableSessionCollaboration,

ModifiedByUser,

ModifiedTime,

FROM [C:\XML_SAVED\DocumentTask.xml] (XmlSimple, Table is [NewDataSet/DocumentTask]);

UNQUALIFY *;

CATEGORY

QUALIFY *;
UNQUALIFY ;

Category:
LOAD Name,
    ModifiedByUser,
    ModifiedTime,
    ID
FROM [C:\XML_SAVED\Category.xml] (XmlSimple, Table is [NewDataSet/Category]);

UNQUALIFY *;

QUALIFY *;

UNQUALIFY ;

Category:

LOAD Name,

ModifiedByUser,

ModifiedTime,

FROM [C:\XML_SAVED\Category.xml] (XmlSimple, Table is [NewDataSet/Category]);

UNQUALIFY *;

TASK-CATEGORY

QUALIFY *;
UNQUALIFY ;

Category:
LOAD Name,
    ModifiedByUser,
    ModifiedTime,
    ID
FROM [C:\XML_SAVED\Category.xml] (XmlSimple, Table is [NewDataSet/Category]);

UNQUALIFY *;

QUALIFY *;

UNQUALIFY ;

Category:

LOAD Name,

ModifiedByUser,

ModifiedTime,

FROM [C:\XML_SAVED\Category.xml] (XmlSimple, Table is [NewDataSet/Category]);

UNQUALIFY *;

TRIGGER

QUALIFY *;
UNQUALIFY DocTask.ID;

Trigger:
LOAD TaskID								As DocTask.ID,
    Enabled,
    TriggerType,
    EnableAt,
    ExpireAt,
    RunTaskID,
    MaxCount,
    Count,
    if(Year(StartAt)&lt;>0,Timestamp(StartAt))					As StartAt,
    EDXPassword,
    TimeContraintFrom,
    TimeContraintTo,
    AndTimeConstraintMinutes,
    MainTriggerID,
    ModifiedByUser,
    ModifiedTime,
    ID
FROM [C:\XML_SAVED\Trigger.xml] (XmlSimple, Table is [NewDataSet/Trigger]);

UNQUALIFY *;

QUALIFY *;

UNQUALIFY DocTask.ID;

Trigger:

LOAD TaskID As DocTask.ID,

Enabled,

TriggerType,

EnableAt,

ExpireAt,

RunTaskID,

MaxCount,

Count,

if(Year(StartAt)<>0,Timestamp(StartAt)) As StartAt,

EDXPassword,

TimeContraintFrom,

TimeContraintTo,

AndTimeConstraintMinutes,

MainTriggerID,

ModifiedByUser,

ModifiedTime,

FROM [C:\XML_SAVED\Trigger.xml] (XmlSimple, Table is [NewDataSet/Trigger]);

UNQUALIFY *;

Отправить ответ