How can I write a search criteria in SuiteScript to find a format profile related to a financial institution?

AI generated answer (using internal Slack threads):

To write a search criteria in SuiteScript to find a format profile related to a financial institution, you would need to create a search on the relevant record type and add filters to narrow down the results. However, the specific field for the financial institution format profile might not be directly accessible via search. In such cases, you can use a formula field in your search. A formula field allows you to create a custom field using a SQL expression. You can use this to access fields that are not directly accessible via search. Here is a sample code snippet on how you might do this:

javascript
var search = require('N/search');

var mySearch = search.create({
   type: "customrecord_myrecordtype", // replace with your record type
   filters: [
      ["custrecord_myfield","is", "myvalue"] // replace with your field and value
   ],
   columns: [
      search.createColumn({
         name: "formulanumeric",
         formula: "{sbankcompanyid}", // replace with your field
         label: "Bank Company ID"
      })
   ]
});

mySearch.run().each(function(result){
   // process each result
   return true;
});

In this example, replace

"customrecord_myrecordtype"

with the record type you are searching,

"custrecord_myfield"

with the field you are filtering on, and

"myvalue"

with the value you are filtering for. The formula

{sbankcompanyid}

should be replaced with the field you are trying to access. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******