Other Examples

In the sections below, many other calculated attribute functions are grouped by purpose and are demonstrated in simple terms using a variety of value templates:

• Classification Functions can be used to access classification objects.
• Completeness Functions can be used to access the completeness score of an object.
• Data Container Functions can be used to access data container objects.
• Hierarchy Functions can be used to access STEP hierarchy objects.
• Lookup Table Functions can be used to access lookup table data.
• Object Functions can be used to access object information.
• Override Functions can be used to access product override data.
• Reference Functions can be used to access object reference data.
• Revision Functions can be used to access revision information.
• Workflow Functions can be used to access workflow information.

For function syntax information and links to more detailed use cases, refer to the Other Functions topic in the STEP Functions section of the Resource Materials online help here.

Classification Functions

These functions can be used to access classification objects.

The example calculated attribute is written to use a product with the classification data defined in the following table.

After creating the data above, copy and paste any of the Value Template text below into the Function Editor, select the object with the defined data, and click the Evaluate button to display the Result.

list(iterate(classifications(), "stepid()"), "/ ")

Use Cases

For a scenario using the CLASSIFICATIONS function, refer to Classification Scenario here.

Completeness Functions

These functions can be used to access the completeness score of an object.

For more information, refer to Initial Setup for Metrics in the System Setup documentation here.

Copy and paste the Value Template text below into the Function Editor, select an object set up for completeness metric, and click the Evaluate button to display the defined Result.

completeness()

round(completeness(),0)

Data Container Functions

These functions can be used to access data container objects on products or entities.

The example value templates require the products and values defined in the following table:

Data Container Types (ID):	Non-Typed Data (244320)	Technical Specifications (244321)
Product: ALRM-01 (157618)
Product: ALRM-02 (157619)	{no Non-Typed Data (244320) data container exists}

{
dclist := datacontainers(),
dc_typeids := iterate(dclist, 'datacontainertypeid()')
}
list(sort(unique(dc_typeids)), "\n")

{
dc := datacontainers(),
dcid := list(iterate(dc, 'value("Supplier_Cost")'), "/"),
dcc := list(iterate(dc, 'datacontainertypeid()'), ", "),
dc1 := listitem(dc, 1),
dc2 := iterate(datacontainercomposite(), 'stepname()'),
msg := ""
}
concatenate(dcid, " --- ", dcc, " --- ", dc2)

{
dc := datacontainers(),
dcid := sort(unique(iterate(dc, 'value("Supplier_Cost")'))),
introtext := if(listlen(dcid) <gt/> 1, "Supplier Cost ranges
 from ", "Supplier Cost is "),
septext := if(listlen(dcid) <gt/> 1, " to ", ""),

firstval := listitem(dcid,1),
lastval := if(listlen(dcid) <gt/> 1, listitem(dcid, 
listlen(dcid)), ""),
 
dctypes := sort(unique(iterate(dc, 'datacontainertypeid()'))),
dclist := if(listlen(dctypes) <gt/> 1, list(dctypes, ", ",
 " and "), listitem(dctypes,1)),
dctext := if(listlen(dctypes) <gt/> 1, " in Data Container 
types ", " in Data Container type "),
msg := "Data Container examples"
}
concatenate(introtext, firstval, septext, lastval, dctext, dclist)

Hierarchy Functions

These functions can be used to access STEP hierarchy objects.

The example value templates require the objects and values defined in the following table:

After creating the data above, copy and paste any of the Value Template text below into the Function Editor, select the object with the defined data, and click the Evaluate button to display the Result.

list(iterate(children(),
'concatenate(stepname())'),', ')

list(iterate(subproducts(),
'concatenate(stepname())'),', ')

list(iterate(children(),
'concatenate(stepname())'),', ')

list(iterate(subproducts(),
'concatenate(stepname())'),', ')

parentid()

list(iterate(path(),
'concatenate(stepname())'),', ')

isbelow('step://product?id=P1id')

isbelow('step://product?id=P-Family')

{i:=path(), 
parent:=listitem(i,listlen(i)-1)
} 
iterate(parent, 
'concatenate("name=",stepname(),"; id=", stepid())')

Evaluating Data on Child Objects

The example value templates require the products and values defined in the following table:

After creating the data above, copy and paste any of the Value Template text below into the Function Editor, select the object with the defined data, and click the Evaluate button to display the Result.

{all:=iterate(subproducts(), "prodval('BrandNameID')"),
unique:=unique(all),
oftenIndex:=1,
oftenCount:=0,
dummy:=iterate(unique, '
{curval:=item,
count:=listlen(filter(all,"exact(curval,item)"))
}
if (count>oftenCount, concatenate(
oftenCount:=count,
oftenIndex:=index),
0)')
}
if (oftenCount>0, listitem(unique,oftenIndex), "")

{attrid:='grandchildattrid'
}
listconcatenate(iterate(subproducts(), 
'iterate(subproducts(),"prodval(attrid)")'))

{msg := "Closest date that is less than the current date is: ",
datenow := left(substitute(now(), "-", ""), 8),
datelist := filter(iterate(children(), 'value("RemovalDate")'), 
'substitute(item, "-", "") < datenow'),
neardate := listitem(reverse(sortnumeric(datelist)), 1)
}
if(exact(neardate, "N/A"), "None Newer", concatenate(msg, neardate))

Lookup Table Functions

These functions can be used to access lookup table data.

For more information, refer to the Transformation Lookup Tables topic in the Resource Materials online help here.

The following templates use this lookup table data.

The examples in the following table do not require specific object data to produce the defined result. Copy and paste any of the Value Template text below into the Function Editor, select any object, and click the Evaluate button to display the defined Result.

REPLACEVALUEBYLOOKUP('UOMLookupTable','EACH')

REPLACEWORDBYLOOKUP('UOMLookupTable','EACH, DOZEN, CASE')

Object Functions

These functions can be used to access object information.

The example value templates require the products and values defined in the following table:

After creating the data above, copy and paste any of the Value Template text below into the Function Editor, select the object with the defined data, and click the Evaluate button to display the Result.

stepid()

stepname()

stepname('step://product?id=P1id')

stepurl()

stepurl('Product','P1id') 

stepobjecttype()

stepobjecttype('step://product?id=P1id')

iterate(stepurl2objid(stepurl('Product','Level1-109267')),'stepname()')

{meta := iterate(stepurl2objid(stepurl('attribute','TEXT1id')), 
'value("Attribute Description")'),
val := value('TEXT1id')
}
concatenate("\'", meta,"\'", " is the metadata on the \'TEXT1id\' 
attribute which contains the value: ", val) 

Override Functions

These functions can be used to access product override data.

The example calculated attributes below are written to use the hierarchy objects defined in the following table.

After creating the data above, copy and paste any of the Value Template text below into the Function Editor, select the object with the defined data, and click the Evaluate button to display the Result.

overriddenproduct('Override1ID')

overriddenproduct('Batteries')

{x := listlen(overriddenby()),
z := iterate(overriddenby(), 'stepname()'),
z := list2multivalue(z),
z := substitute(z, "<multisep/>", "")
}
concatenate("This product is overridden by ", x, " product override(s):
", z)

{x := iterate(overriddenproductobject(), 'stepname()'),
z := listitem(x,1)
}
concatenate('This PO overrides the product "', z, '"')

list(iterate(productoverrideparents(), "stepid()"), "/ ")

Reference Functions

These functions can be used to access object reference data.

The example calculated attributes below are written to use the referenced object defined in the following table.

After creating the data above, copy and paste any of the Value Template text below into the Function Editor, select the object with the defined data, and click the Evaluate button to display the Result.

list(iterate(iterate(references('product', 
'BillOfMaterials'),'referencetarget()'),'stepname()'),', ')

Use Cases

For a scenario using the REFERENCES function, refer to Reference Scenario here.

For a scenario using the REFERENCES and REFERENCETARGET functions, refer to Total Cost of Materials Scenario here.

Revision Functions

These functions can be used to access revision information.

The example calculated attributes below are written to use the revisions defined in the following table.

After creating the data above, copy and paste any of the Value Template text below into the Function Editor, select the object with the defined data, and click the Evaluate button to display the Result.

list(iterate(revisions(), 
'revisioncreatedate()'), ', ')

revisionname()

revisioneditedby()

revisioncomment()

revisionismajor()

revisioncreatedate()

revisioneditdate()

firstrevisioncreatedate()

Workflow Functions

These functions can be used to access workflow information.

The example calculated attributes below are written to use the referenced object defined in the following table.

After creating the data above, copy and paste any of the Value Template text below into the Function Editor, select the object with the defined data, and click the Evaluate button to display the Result.

workflowids()

currentworkflowstates('Workflow6')