[INSTRM-507] Date of experimentid should be looged in the database Created: 04/Oct/18  Updated: 17/Oct/18  Resolved: 17/Oct/18

Status: Done
Project: Instrument control development
Component/s: ics_spsaitActor
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Normal
Reporter: fmadec Assignee: arnaud.lefur
Resolution: Done Votes: 0
Labels: SM1
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Epic Link: Red channel alignment

 Description   

the date when experiment was done should be entered in the database



 Comments   
Comment by arnaud.lefur [ 04/Oct/18 ]

which date ? starting date ? end date ?

Comment by arnaud.lefur [ 04/Oct/18 ]

if it's the starting date that you're looking for, you just have to join Experiment.visitStart on Exposure.visit

c.execute('''select obsdate from Exposure inner join Experiment on Experiment.visitStart=Exposure.visit''')
Comment by fmadec [ 05/Oct/18 ]

Agreed to add date

Comment by arnaud.lefur [ 17/Oct/18 ]

merged in 1bf7366

Generated at Sat Feb 10 16:25:44 JST 2024 using Jira 8.3.4#803005-sha1:1f96e09b3c60279a408a2ae47be3c745f571388b.