I want to retrieve data of the item which matches the specified OrderID( this is my unique attribute in the dataset)

Ask the community
,
1

I have written this code for searching the item that matches the specified orderID.
I am getting this error and I am unable to understand where I am going wrong. It would be great if I get some help as this is my college assignment. I’ll attach two snapshots.

939×504 32.4 KB

1351×199 13.4 KB


function search () {    
wixData.query('#thisDataset')  //thisDataset is name of my dataset on this page  
.contains('orderID',$w("#OrderID").text)     //orderID is text field name contaning orderID   
.or(wixData.query('#thisDataset').eq('number', $w("#OrderID").text))    
.find()       
.then(res => {        
    console(res);        
    $w('#text7').text= res.items;    //printing my result just to check of its working
    });
}
2

Query is done on a collection not a dataset https://www.wix.com/corvid/reference/wix-data.html#query

3

Hi Shan thank you for giving me clearity.
If I want to find a record in my dataset how can i do that ?

4

I have a ‘Shipping’ database in which every column has long data entries which includes customers name, address, orderId, contact details etc. On this database using a hook i have created a new dataset named ‘place orders’ in which every column has only single valued specific data. I want to search this dataset so that i can fetch the required information and run an API. Please suggest me something