© 2026 Hedgehog Software, LLC
Twitter
GitHub
Discord
System
Light
Dark
More
Communities
Docs
About
Terms
Privacy
Search
Star
Feedback
Setup for Free
F
Filament
•
2y ago
•
3 replies
cpbret
Distinct Table Count
Adding distinct
(
) makes it to the count query
, but the column does not
. Is there a different way
?
T
e
x
t
C
o
l
u
m
n
:
:make
(
'responses
_count
'
)
-
>counts
(
[
'responses
'
=
> fn
(
$query
)
=
>
$query
-
>distinct
(
'request
_id
'
)
]
)
-
>label
(
'Responses
'
)
SELECT DISTINCT count
(
*
) FROM
responses
responses
WHERE
churches
churches
.
id
id
=
responses
responses
.
church_id
church_id
and
responses
responses
.
TYPE
TYPE
= 1
) AS
responses_count
responses_count
FROM
churches
churches
Filament
Join
A powerful open source UI framework for Laravel • Build and ship admin panels & apps fast with Livewire
20,307
Members
View on Discord
Resources
ModelContextProtocol
ModelContextProtocol
MCP Server
Similar Threads
Was this page helpful?
Yes
No
Recent Announcements
Similar Threads
table count status
F
Filament / ❓┊help
3y ago
Custom table relationship count
F
Filament / ❓┊help
3y ago
Widget Table : display records count
F
Filament / ❓┊help
7mo ago
Records count in table header
F
Filament / ❓┊help
2y ago