search

croustibat / filament-jobs-monitor

Queue Monitoring Package for Filament
https://filamentphp.com/plugins/jobs-monitor
MIT License
121 stars 33 forks source link

Don't Work in Sql Server #41

Open henryavila opened 2 months ago

henryavila commented 2 months ago

Hi, I just installed the plugin and when accessing the plugin main pageI get the error

SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Operand data type datetime is invalid for sum operator.

SELECT
  top 1 COUNT(*) AS count,
  SUM(finished_at - started_at) AS total_time_elapsed,
  AVG(finished_at - started_at) AS average_time_elapsed
FROM
  [ queue_monitors ]

I'm Running SqlServer 2019

parth2bacancy commented 1 week ago

@croustibat

I am adding my comment here as I found this library very useful. But one feature is missing on this library that is ->poll('10s')

You can add option in config OR some where in code so end developer can use this feature. This is filament's default feature who give live update in table builder....

NOTE: PLEASE CONSIDER THIS COMMENT AND CREATE PR, AS I TRIED TO CREATE ISSUE OR ASK A QUESTION BUT THAT SHOWS ME 404 SO WIRITNG MY POINTS IS HERE.

Expecting this feature to be added library if not added, cause I missed thit points in documentation.