Retrieving the child item name, where the name contains special characters.

let itemSearch = search.create({   type: search.Type.ITEM,   columns: [‘internalid’, ‘name’, ‘parent’],   filters: [     [“type”, “anyof”, “InvtPart”],     “AND”,     [“isinactive”, “is”, “F”]   ] }); let pagedData = itemSearch.runPaged({ pageSize: 1000 }); pagedData.pageRanges.forEach(pageRange => {   let page = pagedData.fetch({ index: pageRange.index });   page.data.forEach(result => {     items.push({       id: result.getValue(‘internalid’),       name: result.getText(‘parent’) ? result.getValue(‘name’).replace(result.getText(‘parent’) + ‘ : ‘, ”) : result.getValue(‘name’),… Continue reading Retrieving the child item name, where the name contains special characters.

Display Child Item Name and Exclude Parent Item Name in Results of Saved Search

Scenario User wants to display only the child item name in search results. Since there is no field or setting that excludes the hierarchical information, users will have to use a formula to achieve this. This Formula (Text) works when used in ‘search results’. Solution To create the saved search, follow the steps below: Navigate… Continue reading Display Child Item Name and Exclude Parent Item Name in Results of Saved Search