Vendor Query

 avatar
user_0223141589
json
a year ago
582 B
7
Indexable
Never
{"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)}