Engine / Editor
export_list_articles_inactive
Mandant default
Pipelines
Engines
Include Mappings
Filter
Überblick
Editor
Validierung
Metadaten
Revisionen
Zurück
Altbestand
Engine bearbeiten
Bestand öffnen
Altbestand
Zum Editor
Run erst mit Status active
DRAFT
Status
engine
Typ
export
Runner
1
Revisionen
Editor
Engine bearbeiten
Definitionstyp
Runner-Typ
Name
Titel
Status
draft
active
archived
YAML-Inhalt
#Connections Source_Config: exportEngine #config - credetials of source connection service Target_Config: exportEngine #config - credentials of target connection service Mysql_Engine: InnoDB Default_Charset: utf8 #Source Source_Datapool: export_articles_tre_filtered #sql from Datapool_Definition: ordernumber: VARCHAR(255) NOT NULL Deaktivierungsgrund: VARCHAR(500) NOT NULL name: VARCHAR(255) NOT NULL supplier: VARCHAR(255) NOT NULL supplier_number: VARCHAR(255) NOT NULL ean: VARCHAR(20) NOT NULL price_ost: VARCHAR(255) NOT NULL price_tre: VARCHAR(255) NOT NULL price_oms: VARCHAR(255) NOT NULL attr1: VARCHAR(255) NOT NULL attr2: VARCHAR(255) DEFAULT NULL attr3: VARCHAR(255) DEFAULT NULL attr4: VARCHAR(255) DEFAULT NULL attr11: VARCHAR(255) DEFAULT NULL attr12: VARCHAR(255) DEFAULT NULL attr21: TEXT DEFAULT NULL stock: VARCHAR(255) DEFAULT NULL bestellsperre: VARCHAR(255) DEFAULT NULL Sql: SELECT t1.* FROM ( SELECT * FROM export_list_articles_inactive_channel_tre UNION SELECT * FROM export_list_articles_inactive_channel_ost UNION SELECT * FROM export_list_articles_inactive_channel_oms UNION SELECT * FROM export_list_articles_inactive_general) as t1 Mapping: ordernumber: Source: t1.ordernumber Deaktivierungsgrund: Source: t1.Deaktivierungsgrund name: Source: t1.name supplier: Source: t1.supplier supplier_number: Source: t1.supplier_number ean: t1.ean price_ost: t1.price_ost price_tre: t1.price_tre price_oms: t1.price_oms attr1: Source: t1.attr1 attr2: Source: t1.attr2 attr3: Source: t1.attr3 attr4: Source: t1.attr4 attr11: Source: t1.attr11 attr12: Source: t1.attr12 attr21: Source: t1.attr21 stock: Source: t1.stock bestellsperre: Source: t1.bestellsperre # ahstat: # Source: t1.ahstat Filters: #In-Memory-Filter (Write-Filter) -> datasets matched by the filter condition are not in the result set (they are filtered out) - Filter: name: Verkaufshaus #there must always be a space between the key and the comparision operator and between the parentheses condition: Cross_Dataset_Filter_Adapter: export_list_articles_inactive__filterByOrdernumber reason: 'There is a price with a verkaufshaus with higher priority' #Target Datapool: export_list_articles_inactive #sql table Primary_Key: [ordernumber, attr1, Deaktivierungsgrund]
Definition aktualisieren