asked on May 16, 2025
Hello.
I'm making a custom api, and I want a pivot table to come out, but I got a /select request from the front in the form of a flat table.
I was wondering why this is the case, can the developer decide on the pivot/flat form.
⋅ May 16, 2025
Hello,
Thank you for contacting us.
Flexmonster sends the /select request for the pivot table, the flat table, or the drill-through view based on the current view. The view is defined in the options.grid.type property of the Report object. With this in mind, if the type is set to compact or classic, the /select request for the pivot table will be sent, and if it is defined as flat type, the /select request for the flat table will be sent. Finally, if you open the drill-through view (double click on the cell in the pivot table), the server will receive the /select request for the drill-through view.
Please let us know if other questions arise.
Kind regards,
Nadia
⋅ May 27, 2025
Hello,
Hope you are having a great week!
We were wondering whether our response addressed your question. Please let us know if you need further assistance.
Looking forward to hearing from you.
Kind regards,
Nadia
⋅ June 3, 2025
Hello,
Hope you are doing well.
Just checking in to ask if you found our response helpful. Please let us know if you have any additional questions.
Looking forward to hearing your feedback.
Kind regards,
Nadia
⋅ June 11, 2025
hello, thanks for the answer. I have additional question!
When is the querytype set to drilldown? I'm developing a custom api, but I don't know what to do in ui to set the querytype to drilldown.
⋅ 6 days ago
Hello,
Thank you for your reply.
The querytype parameter is set to "drillDown" only when the multilevel hierarchy is drilled down. A multilevel hierarchy in a pivot table organizes data into nested levels, such as Year-Quarter-Month, combining them into a single field. For more information about configuring multilevel hierarchies, please refer to our documentation: https://www.flexmonster.com/doc/mapping/#multilevel-hierarchies
When connected to the custom data source API server, the "drillDown" requests are sent separately for each drilled-down cell. You can see a sample of multilevel hierarchies used with the custom API server in this JSFiddle: https://jsfiddle.net/flexmonster/o4jywt38/
Handling these requests on the server is required only when the multilevel hierarchies are configured. If you are not planning to use multilevel hierarchies for your project, implementing the "drillDown" request handling can be omitted.
Please let us know if our answer helped you.
Best Regards,
Maksym
