[INSTRM-1732] display groups in obslog Created: 04/Oct/22  Updated: 02/Apr/23  Resolved: 02/Apr/23

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

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

Issue Links:
Blocks
is blocked by INSTRM-1731 create sequence_group table in opdb Done
Story Points: 2

 Description   

I'm adding a new sequence_group table (INSTRM-1731)
As a result, iic_sequence can be joined to that external table on iic_sequence.group_id (that field will be void otherwise).
I'll let you choose how to display such information .
Thanks !

 Comments   
Comment by yuki.moritani [ 25/Nov/22 ]

For recording:

With actual data taken in November run, Koike-san is getting clear idea and will start this ticket.

Comment by michitaro [ 13/Feb/23 ]

I've Implemented functions to display `sequence_group`'s info on the visit list on obslog.

Comment by michitaro [ 13/Feb/23 ]

We can now search visits belonging to sequence group whose name contains `NGC` by a SQL like this:

where sequence_group_name like '%ngc%'

http://133.40.164.16/obslog/#/visits/83032?limit=200&offset=0&whereSql=where+sequence_group_name+like+%27%25ngc%25%27

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