Hello Everyone. I am trying to create item search...
# suitescript
v
Hello Everyone. I am trying to create item search using filter lastmodiefied date but not working below is my code. Could you please correct my code? // Define filters using 'lastmodifieddate' let filters = [ ['isinactive', 'is', 'F'] 'OR', ['lastmodifieddate', 'onorafter', '05/19/2026 13857 am'] ]; // Create the item search definitions let itemSearch = search.create({ type: search.Type.ITEM, filters: filters, columns: [ 'internalid', 'itemid', 'displayname', 'salesdescription', 'baseprice', 'modified' // FIXED: Swapped 'modified' to 'lastmodifieddate' to prevent UNEXPECTED_ERROR ] });
a
if you want, i can write query for you
v
okay
c
Don't handwrite this code, use the chrome plugin to export UI searches to SS2