0 Replies Latest reply on Feb 13, 2020 10:53 PM by ssilveri777

    Parent join from customer in search criteria

    ssilveri777
      I am trying to do a search with a filter on  parent.internal .  where it is not empty
      I keep getting errors whatever combo I try. Anyone know what the right join/column would be for a filter on parent.internalid
      {"type":"error.SuiteScriptError","name":"SSS_INVALID_SRCH_FILTER_JOIN","message":"An nlobjSearchFilter contains an invalid join ID, or is not in proper syntax: internalid.","stack":["create(N/search/searchPaging.js)","<anonymous>(adhoc$-1$debugger.user:30)","<anonymous>(adhoc$-1$debugger.user:1)"],"cause":{"type":"internal error","code":"SSS_INVALID_SRCH_FILTER_JOIN","details":"An nlobjSearchFilter contains an invalid join ID, or is not in proper syntax: internalid.","userEvent":null,"stackTrace":["create(N/search/searchPaging.js)","<anonymous>(adhoc$-1$debugger.user:30)","<anonymous>(adhoc$-1$debugger.user:1)"],"notifyOff":false},"id":"","notifyOff":false,"userFacing":
      var mySearch  = search.load( {  id :   'customsearch_cs_customers_overdue'

       

         columns :  [ 'internalid',

         'partner.internalid',

         'parent.internalid',

         'daysoverdue',

         'balance'  ] });

       

        filters = mySearch.filters;


        filters.push(search.createFilter({ name : 'internalid',

        join : 'parent',

        operator : search.Operator.ISNOTEMPTY } ));