how to return the columns of this search search.cr...
# ask-stanley-ai
n
how to return the columns of this search search.create({ type: search.Type.INBOUND_SHIPMENT, filters: [ ['internalid', 'anyof', inbdId+""], 'AND', ['item', 'anyof', itemId+""] ], columns: [ search.createColumn({ name: 'custrecord75', join: 'inboundShipmentItem' }), ] }); var searchResult = prodYearSearch.run().getRange({ start: 0, end: 1 });
c
AI generated answer (using internal Slack threads):
To return the columns of the search, you can use the
getValue
method on the search result object. This method takes a parameter which is the name of the column you want to retrieve. Here is an example:
Copy code
javascript
var prodYearSearch = search.create({
    type: search.Type.INBOUND_SHIPMENT,
    filters: [
        ['internalid', 'anyof', inbdId+""],
        'AND',
        ['item', 'anyof', itemId+""]
    ],
    columns: [
        search.createColumn({
            name: 'custrecord75',
            join: 'inboundShipmentItem'
        }),
    ]
});

var searchResult = prodYearSearch.run().getRange({
    start: 0,
    end: 1
});

// Get the value of the 'custrecord75' column
var custrecord75Value = searchResult[0].getValue({
    name: 'custrecord75',
    join: 'inboundShipmentItem'
});
In this example,
custrecord75Value
will hold the value of the 'custrecord75' column from the first result of the search. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.864371479
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.854028642
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.851380289
Please provide your feedback on this answer.