Différences

Ci-dessous, les différences entre deux révisions de la page.

--- dse:data_query_expression_language [2025/03/19 14:48] – nicoanto
+++ dse:data_query_expression_language [2025/03/19 15:14] (Version actuelle) – nicoanto
@@ Ligne 6: / Ligne 6: @@
 ===== Examples =====
+==== Divers ====
 <code>
@@ Ligne 15: / Ligne 16: @@
         ).filter(x => x IS NOT NULL);
+</code>
+<code>
+durationsByTransition : List<Tuple<state: String, duration: Integer>> =
+    List.range(startInclusive: 1, endExclusive: transitionTuples.length, step: 1 )
+        .map(index =>{state: transitionTuples[index - 1].current, duration: Date.daysBetween(start: transitionTuples[index - 1].datetime, end: transitionTuples[index].datetime)})
+    + {state: transitionTuples[transitionTuples.length - 1].current, duration:Date.daysBetween(start: transitionTuples[transitionTuples.length - 1].datetime, end: Date.today())};
+</code>
+====  stateful map() ====
+<code>
+snapshotTuples : List<Tuple<week: String, current: String>> =
+    $Year_Weeks
+        .map(
+            initialState: issue.current
+            , updateState: (x, previousState) => transitionsMap[x].current IS NOT NULL?transitionsMap[x].current:previousState
+            , function: (x, currentState) => {week:x, current:x>=originatedWeek?currentState:NULL}
+        )
+        .filter(x => x.current IS NOT NULL);
+</code>
+==== toMap ====
+<code>
+transitionsMap : Map<String, Tuple<event: String, datetime: DateTime, current: String>> =
+    List.range(startInclusive: 0, endExclusive: issue._history_event.length, step: 1 )
+        .map(index => issue._history_event[index] IN ["create", "promote","demote"]?
+            {event: issue._history_event[index], datetime:issue._history_time[index], current: issue._history_state[index]}
+            :NULL)
+        .filter(x => x IS NOT NULL)
+        .toMap(
+            keyFunction: x => Date.format(date: x.datetime, format:"yyyy_ww")
+            , valueFunction: x => x
+        );
 </code>
 ==== Map.mapValues ====