Your query:
SET STATEMENT max_statement_time=60 FOR SELECT objects.diaObjectId, objects.g_psfFluxMean , objects.maxTai as "latest detection", sherlock_classifications.classification as "predicted classification" FROM objects, sherlock_classifications WHERE objects.diaObjectId=sherlock_classifications.diaObjectId AND objects.nSources > 2 LIMIT 1000 OFFSET 0
returned the error
1054 (42S22): Unknown column 'objects.maxTai' in 'field list'
SET STATEMENT max_statement_time=60 FOR SELECT objects.diaObjectId, objects.g_psfFluxMean , objects.maxTai as "latest detection", sherlock_classifications.classification as "predicted classification" FROM objects, sherlock_classifications WHERE objects.diaObjectId=sherlock_classifications.diaObjectId AND objects.nSources > 2 LIMIT 1000 OFFSET 0
returned the error
1054 (42S22): Unknown column 'objects.maxTai' in 'field list'
'needle_input_filter_test' filter results
'needle_input_filter_test' filter results
A detailed description of your filter.
The filter is not active.
SELECT objects.diaObjectId,
objects.g_psfFluxMean,
objects.maxTai AS "latest detection",
sherlock_classifications.classification AS "predicted classification"
FROM objects,
sherlock_classifications
WHERE objects.diaObjectId=sherlock_classifications.diaObjectId
AND objects.nSources > 2
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?
readthedocs
Lasair Community
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.

