Vendor Query

user_0223141589 avatar
user_0223141589
json
08/28/2023 9:38 PM
776 B
27
Indexable
{"q": "SELECT Vendor.id, Vendor.altname, Vendor.email, Vendor.url, Vendor.lastmodifieddate, Vendor.isperson, VendorAddress.Addressee AS VendorAddressee, VendorAddress.Addr1 As VendorAddress1, VendorAddress.Addr2 As VendorAddress2, VendorAddress.Addr3 As VendorAddress3, VendorAddress.City As VendorCity, VendorAddress.State As VendorState, VendorAddress.Zip As VendorZip, VendorAddress.Country As VendorCountry FROM Vendor AS Vendor LEFT JOIN EntityAddress AS VendorAddress ON VendorAddress.nkey = Vendor.defaultshippingaddress WHERE Vendor.lastmodifieddate>='{}'".format(new_date)}
Editor is loading...