I assume I’m missing something simple, or doing something dumb.
I have a collection, called Dealers, with, among others, a column named ‘Product’. I’m trying to use wixData.query to search for records with a specific value in the ‘Product’ column.
My code is attached to the ‘click’ event of a button.
This code returns no results:
wixData.query(“Dealers”)
.contains(“product”,“decking”)
.find()
.then( (results) => {
console.log(results.items);
})
.catch( (error) => {
console.log(error.message);
});
This code returns an array of all items in my collection (I simply removed the “.contains()”):
wixData.query(“Dealers”)
.find()
.then( (results) => {
console.log(results.items);
})
.catch( (error) => {
console.log(error.message);
});
Viewing the ‘database’ in the Web editor, I can confirm, 100%, that there are entries with ‘decking’ in the ‘Product’ column.
Any ideas why the first bit of code doesn’t return any items?
If I create a new dataset, attach it to a table, and set it’s filter to ‘Product’ and ‘decking’ it shows the expected results. However, if I try to use code to change the filter the table becomes empty. In the end, I’d prefer this to work, as it would make other parts of this project easier to use, any suggestions there would be appreciated as well.
The second bit of code returns this in the Developer Console:
{“_id”:“886b1643-b4b3-49bf-a9bc-90ef06b19b1f”,“_owner”:“b7a27a87-50d4-4d4e-b366-9e435e25a7a4”,“_createdDate”:“2018-02-19T16:21:38.287Z”,“_updatedDate”:“2018-02-19T20:40:33.812Z”,“title”:“Nix Lumber and Hardware”,“address”:“5117 NW 10th St, Oklahoma City, OK 73127”,“phoneNumber”:“(405) 942-5561”,“product”:“decking”},{“_id”:“01109855-991d-40c3-aaf9-cb0a998ecacb”,“_owner”:“b7a27a87-50d4-4d4e-b366-9e435e25a7a4”,“_createdDate”:“2018-02-19T16:20:04.350Z”,“_updatedDate”:“2018-02-19T20:40:38.572Z”,“title”:“Daniel’s Lumber Company”,“address”:“123 Neverthere Ave, Oklahoma City, OK 73108”,“phoneNumber”:“405-850-1111”,“preferred”:true,“product”:“decking”},{“_id”:“fb6a30ac-53af-44c6-b2b5-447aaf65d84e”,“_owner”:“b7a27a87-50d4-4d4e-b366-9e435e25a7a4”,“_createdDate”:“2018-02-19T16:18:41.168Z”,“_updatedDate”:“2018-02-19T20:40:43.254Z”,“title”:“Nix Lumber and Hardware”,“address”:“5117 NW 10th St, Oklahoma City, OK 73127”,“phoneNumber”:“(405) 942-5561”,“product”:“posts”},{“_id”:“b6c62af5-7ca6-43ed-886d-b3e3cef71d95”,“_owner”:“b7a27a87-50d4-4d4e-b366-9e435e25a7a4”,“_createdDate”:“2018-02-19T16:18:30.105Z”,“_updatedDate”:“2018-02-19T20:40:45.869Z”,“address”:“5801 NW 36th St, Warr Acres, OK 73122”,“phoneNumber”:“(405) 946-9032”,“product”:“screws”,“title”:“Gordon White”},{“_id”:“8763dfb7-73ef-4a2a-9418-1485f7b828e7”,“_owner”:“b7a27a87-50d4-4d4e-b366-9e435e25a7a4”,“_createdDate”:“2018-02-19T16:17:12.117Z”,“_updatedDate”:“2018-02-19T20:40:48.812Z”,“title”:“Cedar Creek”,“address”:“450 N MacArhur Blvd”,“phoneNumber”:“405-599-1234”,“product”:“hardware”},{“_id”:“e92aa485-5938-4fc9-8ac2-cdcd5201739e”,“_owner”:“b7a27a87-50d4-4d4e-b366-9e435e25a7a4”,“_createdDate”:“2018-02-19T16:12:41.770Z”,“_updatedDate”:“2018-02-19T20:40:51.417Z”,“title”:“Cedar Creek”,“address”:“450 N MacArthur Blvd”,“phoneNumber”:“405-599-1234”,“product”:“decking”},{“_id”:“971bb786-67d8-4062-bba0-893628c137c1”,“_owner”:“b7a27a87-50d4-4d4e-b366-9e435e25a7a4”,“_createdDate”:“2018-02-19T16:12:08.816Z”,“_updatedDate”:“2018-02-19T20:40:56.299Z”,“title”:“Cedar Creek”,“address”:“450 N MacArthur Blvd”,“phoneNumber”:“405-599-1234”,“product”:“screws”,“latitude”:“34”,“longitude”:“-97”},{“_id”:“544bbb10-864a-470a-9dd3-b5df6f2fd21b”,“title”:“Office Lumber”,“address”:“123 Ave”,“phoneNumber”:“405”,“product”:“fox pelts”,“preferred”:true,“_owner”:“b7a27a87-50d4-4d4e-b366-9e435e25a7a4”,“_createdDate”:“2018-02-16T21:54:01.262Z”,“_updatedDate”:“2018-02-19T20:40:59.660Z”},{“_id”:“95d769ce-cd2e-4bc8-bfec-ebb9d83e68bb”,“_owner”:“b7a27a87-50d4-4d4e-b366-9e435e25a7a4”,“_createdDate”:“2018-02-15T18:40:05.520Z”,“_updatedDate”:“2018-02-19T20:41:01.413Z”,“title”:“Cops Lumber”,“address”:“123 Overthere Ave, OKC, OK 74108”,“phoneNumber”:“405-850-1234”,“preferred”:true,“product”:“decking”},{“_id”:“46d7cf4e-1eb2-4e41-876a-a2b481855dc9”,“title”:“Daniel’s Lumber Company”,“_owner”:“b7a27a87-50d4-4d4e-b366-9e435e25a7a4”,“_createdDate”:“2018-02-15T18:02:34.853Z”,“_updatedDate”:“2018-02-19T20:41:05.871Z”,“address”:“123 Neverthere Ave, Oklahoma City, OK 73108”,“phoneNumber”:“405-850-1111”,“product”:“lighting”,“preferred”:true}