Filter: Test Filter

Your query:
SET STATEMENT max_statement_time=60 FOR SELECT objects.diaObjectId, objects.ra, objects.decl, mjdnow()-objects.lastDiaSourceMJD AS age, sherlock_classifications.classification AS class FROM objects, sherlock_classifications WHERE objects.diaObjectId=sherlock_classifications.diaObjectId AND mjdnow() - objects.lastDiaSourceMJD < 7 AND (objects.g_psfFlux > 100000 OR objects.r_psfFlux > 100000) AND objects.nSources > 1 AND sherlock_classifications.classification in ("SN", "NT", "CV", "AGN") LIMIT 1000 OFFSET 0
returned the error
1054 (42S22): Unknown column 'objects.lastDiaSourceMJD' in 'SELECT'

'Test Filter' filter results

Test The filter is not active.

Run Filter Duplicate History Show Query

SELECT objects.diaObjectId,
       objects.ra,
       objects.decl,
       mjdnow()-objects.lastDiaSourceMJD AS age,
       sherlock_classifications.classification AS CLASS
FROM objects,
     sherlock_classifications
WHERE objects.diaObjectId=sherlock_classifications.diaObjectId
  AND mjdnow() - objects.lastDiaSourceMJD < 7
  AND (objects.g_psfFlux > 100000
       OR objects.r_psfFlux > 100000)
  AND objects.nSources > 1
  AND sherlock_classifications.classification IN ("SN",
                                                  "NT",
                                                  "CV",
                                                  "AGN")

Filter Results

ZERO MATCHES

Zero objects have been matched against this filter so far. Check back later to see if any new objects have been matched, or amend the filtering criteria to catch more objects.

Need Help?

Start with our documentation on readthedocs, you might find the FAQ section especially useful.

If you still have questions, want to report a bug, or make a feature request, please reach out to us on the Lasair topic on the Rubin Community pages.

readthedocs

Lasair Community

Help