Filter: AT from TNS

'AT from TNS' filter results

Getting AT from TNS, crossmatched with Lasair. Lasair keeps a cache of the whole TNS database, and this filter finds objects in both. Checks if any alert is associated with an interacting transient from TNS. The filter is streamed via kafka with the topic name lasair_245ATfromTNS .
Your kafka stream has produced 0 alerts today (0 bytes of your quota of 100,000,000)

Run Filter Duplicate Show Query

SELECT objects.diaObjectId,
       crossmatch_tns.tns_prefix,
       crossmatch_tns.tns_name,
       crossmatch_tns.type
FROM objects,
     watchlist_hits,
     crossmatch_tns
WHERE objects.diaObjectId=watchlist_hits.diaObjectId
  AND watchlist_hits.wl_id=46
  AND watchlist_hits.name=crossmatch_tns.tns_name
  AND crossmatch_tns.type IN ("SN IIn",
                              "SN Ibn",
                              "SN Icn",
                              "LRN",
                              "ILRT",
                              "LBV",
                              "Gap")
ORDER BY objects.lastDiaSourceMjdTai DESC

Filter Results

ZERO MATCHES

Click on the run button above to execute your filter.

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