Level 63
You can use the JSON where clauses.
$currentSupplierId = 3;
$orders = Order::whereJsonContains('supplier_ids', $currentSupplierId)->get();
1 like
Aug 25, 2023
9
Level 3
how to use where query a in casted array field
Hello friends, how to use where query a in casted array field for EXAMPLE
- in model
protected $casts = [
'supplier_ids' => 'array',
];
- Data Stored in Database table field in this format supplier_ids [1,2,3,4]
// db table field data stored like thats
[1,2,3,4]
[1,3,5,7]
- AND NOW I need LIST ALL DATA query only if supplier_ids field where casted array = 3 IN one of them FOR EXAMPLE
$currentSupplierId = 3;
$orders = Order::->where('supplier_ids', $currentSupplierId)->get();
** HOW TO DO THIS QUERY , THANKS FOR TIME
Level 3
@vincent15000 Thanks so much for answer it worked thx so much
1 like
Level 20
Try this ''' $currentSupplierId = 3; $orders = Order::where('supplier_ids', 'LIKE', '%"'.$currentSupplierId.'"%')->get(); ''''
1 like
Level 63
@Shivamyadav It's not a good idea because in the database it's a JSON format and in your suggestion you consider the field as a simple string, but it's not a simple string.
Your query will find any order which contains 3, for example 3 as well as 35 or 53.
1 like
Level 3
@Shivamyadav Thanks so much for answer - like will show like data (search) whereJsonContains() worked
1 like
Level 7
Data is saved in JSON format in the database. So json where clauses should be used as suggested by @vincent15000 above.
1 like
Level 73
I strongly recommend not storing data in json format, it defeats the purpose of a relational database.
I also suggest giving this a read.
1 like
Please or to participate in this conversation.