Not able to get data from Orders Collections

Ask the community
, ,
1

wixData.get(“Stores/Orders”, 10006)
.then( (results) => {
console.log(“inside”)
console.log(results.value);
} )
. catch ( (err) => {
let errorMsg = err;
console.log(“err”)
} );

As per above code I need the data row having id 10006.
The orders collection is having default column as Number with type number

412×509 14.5 KB

In get(), it needs string, but the in Orders
the type of Number column is
number.
Any Suggestions??

2

https://support.wix.com/en/article/corvid-wix-stores-orders-collection-fields
To use the Orders collection in code, refer to it as “Stores/Orders”.

wixData.query("Stores/Orders")
  .find()
  .then( (results) => {
    // handle the results
  } );

You need to put your query in after the query dataset.
https://www.wix.com/corvid/reference/wix-data.WixDataQuery.html

You might be best with the eq() query
https://www.wix.com/corvid/reference/wix-data.WixDataQuery.html#eq

You can’t use Wix Data get() on it.
wix-data - Velo API Reference - Wix.com

As for the number, you can only filter that field in a certain way too.

Number (number)

Description: Running order number.
Type: Number
Can connect to data: Yes
Can use in dynamic page URL: Yes
Can be sorted: Yes
Can be filtered: eq, ne, hasSome, le, lte, gt, gte
Read-only: Yes

To get the number changed into text so that you can put it in a text element, then simply use .toString()
JavaScript Number toString() Method

3

Thanks for your reply
This helped

4

Is “Stores/Orders” Collection giving result response? I cannot seem to get data using the above query