Use the below formula to return only the item’s child name in a saved search.
Formula(Text): ltrim(regexp_substr({name},'[^:]*$’))
For example without the formula a parent: child item will display as:
Parent Item Name: Child Item Name
Using the formula only the Child Item Name will display.
search export:
var itemSearchObj = search.create({
type: “item”,
filters:
[
[“name”,”is”,”SKTHA96976″]
],
columns:
[
search.createColumn({
name: “itemid”,
sort: search.Sort.ASC,
label: “Name”
}),
search.createColumn({
name: “formulatext”,
formula: ” ltrim(regexp_substr({name},'[^:]*$’))”,
label: “Formula (Text)”
})
]
});