I have 2 documents and each document fields are as follow:
2021-06-15 12:00:00 / 1 / Start (doc1)
2021-06-15 12:00:05 / 1 / End (doc2)
How do I get a time difference between Start and End with ID=1 in the Dev Tools ?
I can do two SQL transactions to grab both start and end timestamp and compute the difference but this operation is not efficient if I do it for thousands of documents.
Thanks in advance.