XF 2.2 Showing number "pending" transactions

[DreamNetworks]

Hi,

I have a table xf_xff_transactions, with a field "transaction_status", there are 3 options for this field "Completed, Pending & Reverted".
Now I would like to show the total count of the status pending showing in the admin navbar on the PAGE_CONTAINER.

But somehow, I don''t get it to worl. Can someone assist me with this?

Greetz,
Alex

 

[DekuFX]

Greetings. You can create a method for your entity, and return the following SQL query:

SELECT transaction_status, COUNT(*) FROM xf_xff_transactions WHERE transaction_status = "Pending"

In theory, it should return the number of records, with the value "Pending"