How to get the ID of percentcompleteoverride.period instead of its text label in a Saved Project Search Formula

AI generated answer (using internal Slack threads):

To get the ID of

percentcompleteoverride.period

instead of its text label in a Saved Project Search Formula, you can use the

.id

property in your formula. For example, if you were searching transactions and added a formula for

{percentcompleteoverride.period}

, simply add

.id

to make

{percentcompleteoverride.period.id}

. This will return the internal ID of the period instead of its text label. Here is an example of how you might use this in your code:

javascript
var search = nlapiCreateSearch('transaction', 
    [new nlobjSearchFilter('mainline', null, 'is', 'T')], 
    [new nlobjSearchColumn('percentcompleteoverride.period.id')]
);
var resultSet = search.runSearch();

In this example, the search is set up to return the internal ID of the

percentcompleteoverride.period

for each transaction where

mainline

is true. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******