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.
Tag: Remove Parent Item Name
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
Remove Parent Item Name in Saved Searches
Remove Parent Item Name in Saved Searches