suiteql to list vendors with changes in system notes field address

AI generated answer (using internal Slack threads):

To list vendors with changes in the system notes field address using SuiteQL, you would need to query the system notes table. However, it's important to note that the system notes only capture changes to the default billing address. If another address (e.g., the shipping address) on the vendor record is changed, it doesn't show in the system notes. Also, changes to the address are not captured in the system notes if users create a new address and then assign it as the default billing address or if they change an existing address and then assign it as the default. Unfortunately, there isn't a direct way to detect a change to an address on a vendor record using SuiteQL. You might need to use SuiteScript to achieve this. Here is a general example of how you might structure your SuiteQL query:

sql
SELECT *
FROM systemnotes
WHERE recordtype = 'vendor'
AND field = 'address'

Please note that this is a simplified example and you may need to adjust it according to your specific needs. Also, remember that the 'address' field in the system notes only captures changes to the default billing address. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******