AnsweredAssumed Answered

query to contextualize EFs AND archived attribute values

Question asked by narburgh on Oct 29, 2019
Latest reply on Oct 31, 2019 by gregor


I'm new to the SQL family of products and was hoping someone could help me create a query that will:

1. gather EF data: get start and end times, durations, parent EFs and any EF attributes + values (we have a hierarchy for unit procedure, operation and phase and only phase level has attributes/values)

2. grab referenced unit name

3. grab the archived values (timestamp and value) for all attributes of the referenced unit during the phase level of the EFs

I see there are some example and built-in queries in the SQL Commander Lite. I know how to do step 1 on it's own and step 3 on it's own but I'm having trouble getting all 3 steps into one query. I would appreciate any help!