Table of Contents

<html> <div style=“font-size:xx-large; font-weight: 900;”>18.10.2018 Donnerstag</div> </html>

Kalender, Oktober, KW42

Termine

TODO

Seeburger

AIRS-903 UX Dimensions in a new tab in DA

AIRS-903 UX Dimensions in a new tab in DA

Was funktioniert: 

SELECT a.*, 1 AS cType FROM TAIRFIELDCONFIG a WHERE cCustomerCPId = 101883 AND cProcess = 'DA-UXDimensions' 
UNION 
SELECT a.*, 2 AS cType FROM TAIRFIELDCONFIG a WHERE cCustomerCPProfileId = -100 AND cProcess = 'DA-UXDimensions' 
 AND CFIELDNAME NOT IN ( SELECT CFIELDNAME FROM TAIRFIELDCONFIG WHERE cCustomerCPId = 101883  AND cProcess = 'DA-UXDimensions' )
UNION 
SELECT a.*, 3 AS cType FROM TAIRFIELDCONFIG a WHERE CCUSTOMERCPID = -1000 AND cProcess = 'DA-UXDimensions' 
 AND CFIELDNAME NOT IN ( SELECT CFIELDNAME FROM TAIRFIELDCONFIG WHERE (cCustomerCPProfileId = -100 OR cCustomerCPId = 101883) AND cProcess = 'DA-UXDimensions' )

Oder in Java: 

String sql =
"SELECT * FROM TAIRFIELDCONFIG "
  + " where cCustomerCPId = ? AND cProcess = ? "
  + " UNION "
  + "SELECT * FROM TAIRFIELDCONFIG "
  + " where cCustomerCPProfileId = ? AND cProcess = ?"
  + " AND CFIELDNAME NOT IN ( SELECT CFIELDNAME FROM TAIRFIELDCONFIG "
  + " where cCustomerCPId = ? AND cProcess = ? ) "
  + " UNION "
  + "SELECT * FROM TAIRFIELDCONFIG "
  + " where CCUSTOMERCPID = " + SASWebKeys.FIELD_CONFIG_GLOBAL_DEFAULT_CP + " AND cProcess = ? "
  + " AND CFIELDNAME NOT IN ( SELECT CFIELDNAME FROM TAIRFIELDCONFIG "
  + " where (cCustomerCPId = ? OR cCustomerCPProfileId = ?) AND cProcess = ? )";

rm#27807 Supplier Modify war teilweise ohne Angabe vom Reason Code möglich

rm#27807 Supplier Modify war teilweise ohne Angabe vom Reason Code möglich → Ticket

AIRS-75 PO Reason Code for buyer by supplier modify → Spec in diesem Wiki

Avril