hello guys, I am new here, just stuck in a query on orders array of shopify
I want to manipulate orders to get info like this,
{
topVariant: [
{
variant_id: '',
variant_title: '',
product_title: '',
refundAmount: ''
}
],
topProducts: [
{
product_name: '',
productSaleAmount: '',
variantsSold: '',
product_id: ''
}
],
grandTotals: {
totalRefunds: '',
totalItemsSold: '',
totalRevenue: ''
}
}orders data in the format as below
https://shopify.dev/docs/admin-api/rest/reference/orders/order#index-2020-07
sorry, orders object is very lengthy so I was unable to send here, you can see on this link, under all order api-> show response
Hello guys. I was wondering, what is the approach to querying a collection with a dynamic field.
Let's say we have collection A { type, name, price } and a map of values B that holds the average price of a type of A, and can acces the value like so: B[A.type].avg.
What I want to do is create a dynamic query that will basically return the cheapest documents of a type but I can't figure out if this is doable in one query.
A.find({ price: { $lte: { B[A.type].avg } } })I imagine there is an aggregate method fot this, can someone point me in the right dirrection?
Thanks
1 reply
Top-level use of w, wtimeout, j, and fsync is deprecated. Use writeConcern instead.Any idea why I'm getting this warning and how to fix it?
Hi all, I have a collection that looks like this:
[
{ _id: 1, color: "Blue,Green", },
{ _id: 2, color: "Blue", },
{ _id: 3, color: "Green", }
]color could be a string of comma separated values as in “Blue,Green” or a single string value as in “Blue”.
Given a search string of “Blue”, I want to be able to return “Blue,Green” and “Blue”. Similarly, given a search string of “Green”, I want to be able to return “Blue,Green” and “Green”. I’m finding it hard to write such a query. Any ideas please?
I’m not using any ORM library . Mongo Version: 4.0.6.
Thanks
