[jmagnusson]

Hi,

We have a case where we would like to fetch all rows from a saved search where the data has been updated since a specific date. We’ve added the filter System Notes : Date under the Available Filters tab in the UI (with label set to last_updated). Filtering on this works great through the UI but we don’t see the option to pass this parameter in through the web service. Is this possible? And if so, how?

Thanks,

Jacob
This is a cached copy. Click here to see the original post.

[hguerrero]

Hi Jacob,

There is an enhancement filed to support this 145994 WS > Provide the ability to search system notes through Web Services hence you were not able to find system notes on criteria or column on the schema.

https://system.netsuite.com/help/hel…l?mode=package

But you can try to reference the saved search id you created on the Web Services using Advanced Search Operation and this works for me

Sample Soap Request:

However , please take note since this is NOT supported via Web services as of the moment there is a possibility that this approach might break in the future.

As a workaround

(1) You can use “lastModifiedDate” as filter instead if you want to retrieve all record that has been modified on this specific date.

OR

(2) If you are filtering the field modified and the date it was last modified and if it is only of a specific field , you could probably do the following:

– Create a Custom Record similar to System Notes

— Add Field and Date as custom fields

– Use a script to create those record on After User Submit

– Create a saved search to use Custom Record: Field and Custom Record: Date as filter

– Call this saved search in the Web Services Advanced Search Operation

Hope this helps.

Thanks,

Hanna

[hguerrero]

Take note in relation to Workaround (2): Custom Record should be associated to the record that you would like to search

[Author]

Posts