You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi, I was trying to query orders related to a specific customer. But what I have found is that, in order fields received through order api, in the billing section under it, there is an email field under billing which matches with the email field of the customer fields received through customer api and THIS IS THE ONLY LINK. There is a 'customer_id' field in the order params but most of the times it is 0 (I believe 0 is for guests in WooCommerce?). [Moreover, the billing field you get is in the format (in order api),
[
{
"id": 7337, //order_id
"billing": {
"email": "cuccagna@gmail.com",
},
}
]
So, I am trying the below query on the basis of the results I got,
(I am using the data received through api directly, not saving those in database)
But NONE OF THESE WORKS!!. Can someone help me? Seems like no queries using where condition is working.. (even simple queries, it always results in all the results (which is 10 per page)) (only order::find($id) works efficiently)
The text was updated successfully, but these errors were encountered:
Hi, I was trying to query orders related to a specific customer. But what I have found is that, in order fields received through order api, in the billing section under it, there is an email field under billing which matches with the email field of the customer fields received through customer api and THIS IS THE ONLY LINK. There is a 'customer_id' field in the order params but most of the times it is 0 (I believe 0 is for guests in WooCommerce?). [Moreover, the billing field you get is in the format (in order api),
[
{
"id": 7337, //order_id
"billing": {
"email": "cuccagna@gmail.com",
},
}
]
So, I am trying the below query on the basis of the results I got,
(I am using the data received through api directly, not saving those in database)
$customeremail = $request->email;
$order_of_the_customer = order:where('to->billing->email', $customeremail)->get();
Or,
$order_of_the_customer = order::whereJsonContains('to', [['billing' => ['email' => $customeremail ]]])->get();
But NONE OF THESE WORKS!!. Can someone help me? Seems like no queries using where condition is working.. (even simple queries, it always results in all the results (which is 10 per page)) (only order::find($id) works efficiently)
The text was updated successfully, but these errors were encountered: