Level 102
Do you mean just the count of those and nothing else?
$userCount = User::where('app_version', '4.3.1')->count();
Dec 10, 2022
11
Level 2
version
hey i need to get the count of users based on the latest version of application for example i am having 4.2.1 and 4.3.1 one user is updated from 4.2.1 to 4.3.1 so that user count will not list the count of 4.2.1 any suggestion?
Level 2
@Sinnbeck i am getting all the version count
Level 2
@Sinnbeck for example the output will be 4.1.1 = 1000 4.2.1 = 2000 4.3.1 = 3000 here if one user is updated from 4.1.1 to 4.2.1 to 4.3.1 means the user count only list on 4.3.1 not on other below version
Level 102
@syedhasy ok
$users = User::query()
->selectRaw('COUNT(*) as num_users, version')
->groupBy('version')
->get();
1 like
Level 73
Level 2
Level 102
@syedhasy show some code. We cannot guess it, as the query should be correct
Level 73
@syedhasy How are we supposed to help you when you don't show any code at all, and we have no clue what your database look like?
Level 2
@jeffrey way help me
Level 102
@syedhasy the chances of Jeffrey answering your questions are very slim. He is way too busy making content for the site :)
1 like
Level 24
@Sinnbeck Jeffrey is teaching me how to write another Laravel
https://www.youtube.com/watch?v=U2lQWR6uIuo&list=PL3VM-unCzF8ipG50KDjnzhugceoSG3RTC
Please or to participate in this conversation.