Unable to retrieve custom list value from saved search in netsuite












1















Creating saved search in suitescript using nlapiSearchRecord. All the column value returns except one column which is type is custom list.
How could I get value of custom list?



To get the value I'm using code lines below.



columns[0] = new nlobjSearchColumn( 'customlist' );
var searchresults = nlapiSearchRecord( 'customrecord', null, filters, columns );


To get the column value



var  listValue = searchresult.getListValue( 'customlist' );









share|improve this question



























    1















    Creating saved search in suitescript using nlapiSearchRecord. All the column value returns except one column which is type is custom list.
    How could I get value of custom list?



    To get the value I'm using code lines below.



    columns[0] = new nlobjSearchColumn( 'customlist' );
    var searchresults = nlapiSearchRecord( 'customrecord', null, filters, columns );


    To get the column value



    var  listValue = searchresult.getListValue( 'customlist' );









    share|improve this question

























      1












      1








      1








      Creating saved search in suitescript using nlapiSearchRecord. All the column value returns except one column which is type is custom list.
      How could I get value of custom list?



      To get the value I'm using code lines below.



      columns[0] = new nlobjSearchColumn( 'customlist' );
      var searchresults = nlapiSearchRecord( 'customrecord', null, filters, columns );


      To get the column value



      var  listValue = searchresult.getListValue( 'customlist' );









      share|improve this question














      Creating saved search in suitescript using nlapiSearchRecord. All the column value returns except one column which is type is custom list.
      How could I get value of custom list?



      To get the value I'm using code lines below.



      columns[0] = new nlobjSearchColumn( 'customlist' );
      var searchresults = nlapiSearchRecord( 'customrecord', null, filters, columns );


      To get the column value



      var  listValue = searchresult.getListValue( 'customlist' );






      netsuite suitescript






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 22 '18 at 14:20









      nisoniso

      306




      306
























          1 Answer
          1






          active

          oldest

          votes


















          3














          I assume you've simplified your code in trying to be clear or confidential but there will never be fields or records with those ids.



          from a search you would do:



          var searchResult = searchResults[0];
          searchResult.getValue(fieldId, joinName, summary)
          // or in your case
          searchResult.getValue('customlist'); //returns id of list value or simple result of non-list/record fields


          or (and I think this is the one you want)



          searchResult.getText('customlist'); // returns the display value of the list/record field. 





          share|improve this answer


























          • Yea exactly I would like to get value of list/record field. As you mentioned I'm using searchResult.getValue(customlist). But from search result it doesn't return anything.

            – niso
            Nov 23 '18 at 8:59













          • If you are still having trouble look at the edited code sample

            – bknights
            Nov 23 '18 at 15:02











          Your Answer






          StackExchange.ifUsing("editor", function () {
          StackExchange.using("externalEditor", function () {
          StackExchange.using("snippets", function () {
          StackExchange.snippets.init();
          });
          });
          }, "code-snippets");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "1"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53432954%2funable-to-retrieve-custom-list-value-from-saved-search-in-netsuite%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          3














          I assume you've simplified your code in trying to be clear or confidential but there will never be fields or records with those ids.



          from a search you would do:



          var searchResult = searchResults[0];
          searchResult.getValue(fieldId, joinName, summary)
          // or in your case
          searchResult.getValue('customlist'); //returns id of list value or simple result of non-list/record fields


          or (and I think this is the one you want)



          searchResult.getText('customlist'); // returns the display value of the list/record field. 





          share|improve this answer


























          • Yea exactly I would like to get value of list/record field. As you mentioned I'm using searchResult.getValue(customlist). But from search result it doesn't return anything.

            – niso
            Nov 23 '18 at 8:59













          • If you are still having trouble look at the edited code sample

            – bknights
            Nov 23 '18 at 15:02
















          3














          I assume you've simplified your code in trying to be clear or confidential but there will never be fields or records with those ids.



          from a search you would do:



          var searchResult = searchResults[0];
          searchResult.getValue(fieldId, joinName, summary)
          // or in your case
          searchResult.getValue('customlist'); //returns id of list value or simple result of non-list/record fields


          or (and I think this is the one you want)



          searchResult.getText('customlist'); // returns the display value of the list/record field. 





          share|improve this answer


























          • Yea exactly I would like to get value of list/record field. As you mentioned I'm using searchResult.getValue(customlist). But from search result it doesn't return anything.

            – niso
            Nov 23 '18 at 8:59













          • If you are still having trouble look at the edited code sample

            – bknights
            Nov 23 '18 at 15:02














          3












          3








          3







          I assume you've simplified your code in trying to be clear or confidential but there will never be fields or records with those ids.



          from a search you would do:



          var searchResult = searchResults[0];
          searchResult.getValue(fieldId, joinName, summary)
          // or in your case
          searchResult.getValue('customlist'); //returns id of list value or simple result of non-list/record fields


          or (and I think this is the one you want)



          searchResult.getText('customlist'); // returns the display value of the list/record field. 





          share|improve this answer















          I assume you've simplified your code in trying to be clear or confidential but there will never be fields or records with those ids.



          from a search you would do:



          var searchResult = searchResults[0];
          searchResult.getValue(fieldId, joinName, summary)
          // or in your case
          searchResult.getValue('customlist'); //returns id of list value or simple result of non-list/record fields


          or (and I think this is the one you want)



          searchResult.getText('customlist'); // returns the display value of the list/record field. 






          share|improve this answer














          share|improve this answer



          share|improve this answer








          edited Nov 23 '18 at 15:02

























          answered Nov 22 '18 at 23:43









          bknightsbknights

          8,3642822




          8,3642822













          • Yea exactly I would like to get value of list/record field. As you mentioned I'm using searchResult.getValue(customlist). But from search result it doesn't return anything.

            – niso
            Nov 23 '18 at 8:59













          • If you are still having trouble look at the edited code sample

            – bknights
            Nov 23 '18 at 15:02



















          • Yea exactly I would like to get value of list/record field. As you mentioned I'm using searchResult.getValue(customlist). But from search result it doesn't return anything.

            – niso
            Nov 23 '18 at 8:59













          • If you are still having trouble look at the edited code sample

            – bknights
            Nov 23 '18 at 15:02

















          Yea exactly I would like to get value of list/record field. As you mentioned I'm using searchResult.getValue(customlist). But from search result it doesn't return anything.

          – niso
          Nov 23 '18 at 8:59







          Yea exactly I would like to get value of list/record field. As you mentioned I'm using searchResult.getValue(customlist). But from search result it doesn't return anything.

          – niso
          Nov 23 '18 at 8:59















          If you are still having trouble look at the edited code sample

          – bknights
          Nov 23 '18 at 15:02





          If you are still having trouble look at the edited code sample

          – bknights
          Nov 23 '18 at 15:02




















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53432954%2funable-to-retrieve-custom-list-value-from-saved-search-in-netsuite%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          "Incorrect syntax near the keyword 'ON'. (on update cascade, on delete cascade,)

          Alcedinidae

          RAC Tourist Trophy