title: How can I get netsuite inventory item historical pricing matrix from systemnotes?
body: <p>I'm trying to write a routine that will look over netsuite pricing changes, looking for data that was lost due to buggy code.</p>
  
  <p>My current suitescript code</p>
  
  <pre><code>// Define filters
              var filters = [];
              filters.push(new nlobjSearchFilter( 'internalid', null, 'is', id));
  
              // Define search columns
              var columns = [
                  new nlobjSearchColumn( 'itemid' ),
                  new nlobjSearchColumn( 'class' ),
                  new nlobjSearchColumn( 'name' ),
                  new nlobjSearchColumn( 'displayname' ),
                  new nlobjSearchColumn('date', 'systemNotes'),
                  new nlobjSearchColumn('name', 'systemNotes'),
                  new nlobjSearchColumn('type', 'systemNotes'),
                  new nlobjSearchColumn('field', 'systemNotes'),
                  new nlobjSearchColumn('context', 'systemNotes'),
                  new nlobjSearchColumn('newvalue', 'systemNotes'),
                  new nlobjSearchColumn('oldvalue', 'systemNotes')
              ];
  
              var searchResults = nlapiSearchRecord( 'inventoryitem', null, filters, columns );
  
              var searchResultJson = [];
              _.each(searchResults, function (searchResult){
                  if(searchResult.getValue(columns[7]) === "pricelist")
                      searchResultJson.push({
                          itemid:  searchResult.getValue(columns[0]),
                          class: searchResult.getValue(columns[1]),
                          name: searchResult.getValue(columns[2]),
                          displayname: searchResult.getValue(columns[3]),
                          date: searchResult.getValue(columns[4]),
                          username: searchResult.getValue(columns[5]),
                          type: searchResult.getValue(columns[6]),
                          field: searchResult.getValue(columns[7]),
                          context: searchResult.getValue(columns[8]),
                          newvalue: searchResult.getValue(columns[9]),
                          oldvalue: searchResult.getValue(columns[10])
                      });
              });
              return searchResultJson;
  </code></pre>
  
  <p>This gives me a javascript object like</p>
  
  <pre><code>class:"136"
  context:"UI"
  date:"4/29/2016 2:51 am"
  displayname:"&lt;item name&gt;"
  field:"pricelist"
  itemid:"&lt;item id&gt;"
  name:"&lt;item id&gt;"
  newvalue:"View"
  oldvalue:"View"
  type:"Change"
  username:"&lt;user id&gt;"
  </code></pre>
  
  <p>I want to get the full pricing matrix for the old and new values, but all I'm getting back is the string <code>View</code>.  Changes to single fields do return the actual value for newvalue and oldvalue, but the pricelist field just returns <code>View</code>.</p>
  
  <p>How can I get the pricing data that is show in the UI of the item's system notes when 'View' is clicked?</p>