Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Custom data source: row with two hierarchy

Re-Open
Brad Huang asked on March 26, 2021

With custom data source, I put two hierarchy in row
So it will be like [mst_1, dtl_1] + [mst_2, dtl_2] 
But when I drilled down to level 4 [dtl_2], flexmonster only request rows [mst_1, mst_2, dtl_2] with filter [mst_1, dtl_1, mst_2]
After I return data with [level2, level3, level4],
there will not appear data in pivot at all.
If I use 4 rows [mst_1, dtl_1, mst_2, dtl_2], it will work correctly.
There is the sample request from flexmonster.

{
"type": "select",
"index": "myIndex",
"query": {
"aggs": {
"by": {
"rows": [
{
"uniqueName": "mst_1"
},
{
"uniqueName": "mst_2"
},
{
"uniqueName": "dtl_2"
}
]
},
"values": [
{
"func": "sum",
"field": {
"uniqueName": "ttlTeu"
}
}
]
},
"filter": {
"type": "and",
"value": [
{
"field": {
"uniqueName": "mst_1"
},
"include": [
{
"member": "mst_1_value_1",
"filter": {
"field": {
"uniqueName": "dtl_1"
},
"include": [
{
"member": "dtl_1_value_1"
}
]
}
}
]
},
{
"field": {
"uniqueName": "mst_2"
},
"include": [
{
"member": "mst_2_value_1"
}
]
}
]
}
},
"page": 0
}

3 answers

Public
Brad Huang March 26, 2021

I reproduced the scenario by adjusting your example.
You may see that we can not drill to level4[Destination].
Example in jsFiddle

Public
Milena Pechura Milena Pechura Flexmonster March 26, 2021

Hello, Brad,
 
Thank you for posting to our forum.
 
It seems that this issue has already been reported to our team.
 
We will provide the fix for this in our upcoming release ETA 5th of April.
Our team will notify you as soon as the version with a fix is available to download.
 
Do not hesitate to contact us in case any other questions arise.
 
Regards,
Milena

Public
Brad Huang April 6, 2021

I tried the latest version 2.8.30.
This issue is fixed.
Thanks for your help.

Please login or Register to Submit Answer