export / export_articles_oms_test_read_conditions

#Connections
Source_Config: enhanceEngine #config - credetials of source connection service
Target_Config: exportEngine #config - credentials of target connection service

#Source
Source_Datapool: articles  #sql from

Joins:
- Join: #each condition is joined with "AND"
  Datapool: iwm_stocks
  Join_Condition: articles.ordernumber = iwm_stocks.ordernumber AND articles.attr1 = iwm_stocks.firma # One row per JOIN


Read_Conditions:  #sql where - Read-Filter
  - articles.active_oms = 1
  - !((articles.price_oms <= 6) AND (iwm_stocks.witten <= 10) AND (articles.attr2 = 90 or articles.attr2 = 91 or articles.attr2 = 92 or articles.attr2 = 96 or articles.attr2 = 101) AND (articles.attr11 = 'L'))
  - !((articles.price_oms < 25) AND (iwm_stocks.witten < 3) AND (articles.attr2 = 90 or articles.attr2 = 91 or articles.attr2 = 92 or articles.attr2 = 96 or articles.attr2 = 101) AND (articles.attr11 = 'L'))
  - !((articles.price_oms < 100) AND (iwm_stocks.witten < 1) AND (articles.attr2 = 90 or articles.attr2 = 91 or articles.attr2 = 92 or articles.attr2 = 96 or articles.attr2 = 101) AND (articles.attr11 = 'L'))

#Mapping -> Mappings source fields are detected by Mapping
Mapping:
 ordernumber:
   Source: articles.ordernumber
 mainnumber:
  Source: articles.mainnumber
 name:
  Source: articles.name_oms
 supplier:
  Source: articles.supplier_oms
 tax:
  Source: articles.tax
 price_EK:
  Source: articles.price_oms
  Field_Adapter:
    - replace: [',', '']
    - replace: ['.', ',']
 pseudoprice_EK:
   Source: articles.pseudoprice_oms
   Field_Adapter:
     - replace: [',', '']
     - replace: ['.', ',']
 baseprice_EK: (0)
 active:
   Source: articles.active_oms
 configurator_options:
   Source: articles.configuratorOptions
 description_long:
  Source: articles.description_long_oms
  Field_Adapter:
      - addslashes
      - replace: [';', '']
 supplier_number: articles.suppliernumber
 attr1:
    Source: articles.attr1
    Field_Adapter:
      - replace: [';', '']
 attr2:
     Source: articles.attr2
     Field_Adapter:
       - replace: [';', '']
 attr3:
     Source: articles.attr3
     Field_Adapter:
       - replace: [';', '']
 attr4:
     Source: articles.attr4
     Field_Adapter:
       - replace: [';', '']
 attr5:
     Source: articles.attr5
     Field_Adapter:
       - replace: [';', '']
 attr6:
     Source: articles.attr6
     Field_Adapter:
       - replace: [';', '']
 attr7:
     Source: articles.attr7
     Field_Adapter:
       - replace: [';', '']
 attr8:
     Source: articles.attr8
     Field_Adapter:
       - replace: [';', '']
 attr9:
     Source: articles.attr9
     Field_Adapter:
       - replace: [';', '']
 attr10:
     Source: articles.attr10
     Field_Adapter:
       - replace: [';', '']
 attr11:
     Source: articles.attr11
     Field_Adapter:
       - replace: [';', '']
 attr12:
     Source: articles.attr12
     Field_Adapter:
       - replace: [';', '']
 attr13:
     Source: articles.attr13
     Field_Adapter:
       - replace: [';', '']
 attr14:
     Source: articles.attr14
     Field_Adapter:
       - replace: [';', '']
 attr15:
     Source: articles.attr15
     Field_Adapter:
       - replace: [';', '']
 attr16:
     Source: articles.attr16
     Field_Adapter:
       - replace: [';', '']
 attr17:
     Source: articles.attr17
     Field_Adapter:
       - replace: [';', '']
 attr18:
     Source: articles.attr18
     Field_Adapter:
       - replace: [';', '']
 attr19:
     Source: articles.attr19
     Field_Adapter:
       - replace: [';', '']
 attr20:
     Source: articles.attr20
     Field_Adapter:
       - replace: [';', '']
 ean: articles.ean
 stock_witten:
     Source: iwm_stocks.witten
 shipping_free: articles.shippingfree


Filters: #In-Memory-Filter (Write-Filter) -> datasets matched by the filter condition are not in the result set (they are filtered out)
 - Filter:
    name: Mindestbestand  #there must always be a space between the key and the comparision operator
    condition: (price_EK < 6) AND (stock_witten < 10) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == 'L')
    reason: 'Mindestbestand (price < 6) AND (stock_witten < 10) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == L)'
 - Filter:
    name: 'Mindestbestand'
    condition: (price_EK < 25) AND (stock_witten < 3) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == 'L')
    reason: 'Mindestbestand (price < 25) AND (stock_witten < 3) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == L)'
 - Filter:
    name: 'Mindestbestand'
    condition: (price_EK < 100) AND (stock_witten < 1) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == 'L')
    reason: 'Mindestbestand (price < 100) AND (stock_witten < 1) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == L)'


#Target
Datapool: export_articles_oms #sql table
Primary_Key: [ordernumber, attr1]