Presenting the data in tabular format:
id | module_id | rating
1 | 421 | 3
2 | 421 | 5
3. | 5321 | 4
4 | 5321 | 5
5 | 5321 | 4
6 | 641 | 2
7 | 641 | 3
8 | 641 | 3
9 | 641 | 2
10 | 7201 | 4
11 | 7201 | 4
12 | 7201 | 3
My code involves fetching ratings of a module id and sorting them using a custom formula, followed by arranging module ids in descending order based on the formula value.
Below is the code snippet:
let arr = [421,5321,641,7201];
let temp = [], ci_bounds = [];
for(let j=0; j<arr.length; j++){
// Code logic for fetching and calculating lower bounds
}
The 'temp' array contains sub-arrays with module_id as the first element and corresponding lower bound as the second element.
temp value for above data
[
[
421,
0.09452865480086611
],
[
5321,
0.43849391955098216
],
[
641,
2.8316237110415135e-17
],
[
7201,
0.20765495512648788
]
]
The 'arr' array is then sorted based on these lower bounds to get the final reordered result. Here's how the sorting is done:
// Sorting logic
Final answer after sorting: [5321, 7201, 421, 641]
Is there a way to perform this aggregation directly in a query?