Editing a dashlet in WelcomeMenu

[Abdullah Noman]

Hello,
when we show a dashlet in the welcome menu page we generally call a class and it shows all the records stored for that class. I am wondering if there is a way to show or filter those records by a certain attribute of that class. I still want to use the DashletBadge not the DashletObjectList but just want to filter the records it is going to show. Any help would be appreciated. I tried this so far but didn't work,
1)
<dashlet id="2" xsi:type="DashletBadge"> <rank>3</rank> <title>Circuits</title> <query>SELECT Circuit WHERE Circuit.status='Active'</query> </dashlet>

2)
<dashlet id="user-content-2" xsi:type="DashletBadge">
<rank>3</rank>
<class>Circuits</class>
<filter>[CDATA![SELECT Circuits WHERE Circuits.status='Active']]</ filter >
</filter></dashlet>

Kind Regards,

Abdullah

[Jeffrey Bostoen]

Almost like you wrote.

The Circuit class is not a default one, so you'd also need to check for the value (not the label!) of "active". Is it "active" or "Active".

SELECT Circuit WHERE status = 'active'

[Abdullah Noman]

The value is 'Active' or 'Inactive' and I only want to show the active ones. so which one should I try again , the first one or the second one? But so far both didn't work.

Thanks so much for responding.

[Abdullah Noman]

@pgoiffon Is there a way to do it? Really appreciate your time, thanks.

[Jeffrey Bostoen]

Might be best to share your custom class.