...

Calculated Field Set 

• Get the current processed item (e.g. product):

  Code Block
  language groovy
  api.currentItem()

  Sometimes this does not work in the debug mode; then you can use:

  Code Block
  language groovy
  if (!api.isDebugMode()) { return api.currentItem() }

  
  

  Code Block
  language groovy
  def currentItem = api.currentItem() != null ? api.currentItem() : api.getProduct(api.product("sku"))

  
  

• Get the attribute of the current product:
  • formula: Product("MatNr. 8 Stellen")
  • Groovy: api.product("MatNr. 8 Stellen")
• Get the parameters for CFS:
  • return api.option("Add Products to Price Grid","Yes","No")?:"Yes"

• Track the progress when running:
  Admin > Job/TaskTracking > find CFS by its ID

Products Table

• Iterate through products:

  Code Block
  language groovy
  def prods = api.find("P", Filter.equal("attribute20", sku8)) for (p in prods) { api.trace("Marking for recalculation", null, p.sku) api.update("P", [ "sku" : p.sku, "attribute30" : "X" ]) }

  
  

Price Parameter

• To look up a certain row:
  • formula:  VLookup(“<PP table name>", “<key of the desired row>")
  • Groovy: api.vLookup("Cockpit_Teile", "Value", "Teile") 

• Iterate through all rows:

  Code Block
  language groovy
  def values = api.findLookupTableValues("Reaktivierte_Stati") if (values) { for (v in values) { def a = v.name def b = v.attribute1

  
  

Product Extension

This code shows how to get a value of the attribute name. It is not possible by default from Groovy because getExtension returns a list of records that contain original names "attribute1, attribute2....". 

def px1 = api.productExtension("L1_L2_prices")
if (px1) {
  def meta = api.find("PXAM", Filter.equal("name", "L1_L2_prices"), Filter.equal("label", "RCH1001"))
  def attrName = meta[0].fieldName
  def value = px1[0].get(attrName)
  return value
}
return null

Date Time Functions

def lastUpdate = api.product("lastUpdateDate")
api.trace("lastUpdate", null, lastUpdate)
def date = '12/01/2014 00:00:00'
def myDateTime = Date.parse( 'dd/MM/yyyy HH:mm:ss', date)
api.trace("myDateTime", null, myDateTime)
return lastUpdate > myDateTime

...

api.trace("Product", null, product)

Global API Variables

...

api.retainGlobal = true //optional (see above)
api.global.<variable> = “hello"

CRUD Operations

Add

def map = [
          pricelistId: plId,
          sku: item.sku,
          resultPrice: item.resultPrice,
          label: item.label,
          unitOfMeasure: item.unitOfMeasure,
          currency: item.currency,
          comment: item.comment
        ]
api.add("PLI", map)

Add or Update

def product = [:]
product["sku"] = “Product1"
product["label"] = “The Best Product"
api.addOrUpdate("P", product)

...

Read Data and Search Any Table

api.find("PLI", Filter.equal("sku", mySku))

Iterate over Results of FIND Operation

As the Find operation may not give you all the results, but only 100 items or so, you can use this code:

def startRow = 0
while ( products = api.find("P", startRow, <filters>) ) {
	startRow += products.size()
	for(def product : products){
		//……...
	}
}

Update

// update the LAST_PROCESSED_ID in PricingParameters
def lt = api.findLookupTable("CopyCFS")
api.update("LTV", [
  lookupTableId : lt.id,
  name : "LAST_PROCESSED_ID",
  value : id
])

Delete

api.delete("PX", [
      name: "PMIntegration",
      id: id
])

Set Values in Extra Info Columns Attributes

This sample shows how to set values in additionalInfo[1,2,3] attributes (Extra Info columns) on quotes and contracts via the header logic. 

//Contract header logic (PromotionManager)
cProcessor.updateField("ROOT", "additionalInfo3", "some text")


//Quote header logic (QuoteConfigurator)
quoteProcessor.updateField("ROOT", "additionalInfo3", "some text")

Get value of another element of the Pricing Logic 

api.getElement("<element_name>")

Get attribute value by Name

api.getPropertyByElementName(pgi, "SomeLabel")

Syntax Check Hack

Sometimes the syntax check is ok but you still cannot save the logic. Then use:

...