Vendor Query

 avataruser_0223141589
json
24 days ago
582 B
4
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)}