Low code platform for building business apps and workflows in minutes. Supports PostgreSQL, MySQL, MariaDB, MSSQL, MongoDB, Rest API, Docker, K8s, and more 🚀
[ X] I have searched budibase discussions and github issues to check if my issue already exists
Self
Method:
Budibase Version: <2.32.11>
Describe the bug
A rest call produces a pivot table. This is set up as a rest API query in the Budibase data interface. Bindings to the rest call enable the columns of the pivot table to be specified. The default is to display all columns, and on initial screen load the line chart displays just fine. When columns from the rest query are selected for display using URL parameters, the line chart disappears until nearly all of the columns are selected for display.
A similar issue is line charts from rest calls are displaying data points but missing lines in the chart.
To Reproduce
When the rest call is made with the default of showing all columns, the line chart and the associated table display fine. A multi-select picker allows me to choose the columns from the pivot table data I want to display in the chart. The multi-select tool lists the account names provided in columns. When I load the screen there are about 20 columns populated and the line chart displays fine.
Each click on the multi-select picker checkmarks an acccount that is the heading to a pivot column. On click, the value sets a state parameter that is passed to the rest query that tells it to execute a rest api with parms and display the pivot table with the columns named in the accountnames parameter. When the screen loads, all the columns are displayed in the line chart. If I click on 1 account column, the api returns the rest data with only 1 column of data, and the whole chart disappears. It remains hidden until almost all of the account columns are selected. It's almost as though the interface breaks if the default values are not all provided, as with the screen load.
There is a table that is performing a display of the same data which shows data in the selected columns. The deselected columns are empty, but still provided in the table. I submitted a question about whether there might be a way to suppress these blank columns with empty data from the table.
Another issue which may be related is I have line charts that display data from rest api calls that contain the data, that is there are points for the data shown in a hover, but the lines for all the data points are not displayed. I've included a screenshot below. This problem is intermittent. I don't know what causes it and what makes it go away but it doesn't happen all the time.
There is something weird going on with the charting interface tool and rest service calls.
Expected behavior
I would expect the chart to display 1 line when one column is selected, and then add lines as more accounts columns are selected in the multi-select tool.
I don't know why sometimes charts are displaying with data points without lines.
Screenshots
App Export
If possible - please attach an export of your budibase application for debugging/reproduction purposes.
???
Desktop (please complete the following information):
OS: Budibase in docker compose is on a small Ubuntu 22.04 server.
Client is a Ubuntu 22.04 laptop using current version of Firefox as a browser.
rest service calls are supported by a python flask server, also o the Ubuntu 22.04 server running in docker compose
pivot tables are created using pandas, and the json data tests as valid
database calls supporting the rest services are to MySQL services, also running in docker compose
other direct calls from Budibase to the MySQL server have no issues
Additional context
Add any other context about the problem here.
linear[bot]
commented
1 week ago
Checklist
[ X] I have searched budibase discussions and github issues to check if my issue already exists
Self
Describe the bug A rest call produces a pivot table. This is set up as a rest API query in the Budibase data interface. Bindings to the rest call enable the columns of the pivot table to be specified. The default is to display all columns, and on initial screen load the line chart displays just fine. When columns from the rest query are selected for display using URL parameters, the line chart disappears until nearly all of the columns are selected for display.
A similar issue is line charts from rest calls are displaying data points but missing lines in the chart.
To Reproduce
When the rest call is made with the default of showing all columns, the line chart and the associated table display fine. A multi-select picker allows me to choose the columns from the pivot table data I want to display in the chart. The multi-select tool lists the account names provided in columns. When I load the screen there are about 20 columns populated and the line chart displays fine.
Each click on the multi-select picker checkmarks an acccount that is the heading to a pivot column. On click, the value sets a state parameter that is passed to the rest query that tells it to execute a rest api with parms and display the pivot table with the columns named in the accountnames parameter. When the screen loads, all the columns are displayed in the line chart. If I click on 1 account column, the api returns the rest data with only 1 column of data, and the whole chart disappears. It remains hidden until almost all of the account columns are selected. It's almost as though the interface breaks if the default values are not all provided, as with the screen load.
There is a table that is performing a display of the same data which shows data in the selected columns. The deselected columns are empty, but still provided in the table. I submitted a question about whether there might be a way to suppress these blank columns with empty data from the table.
Another issue which may be related is I have line charts that display data from rest api calls that contain the data, that is there are points for the data shown in a hover, but the lines for all the data points are not displayed. I've included a screenshot below. This problem is intermittent. I don't know what causes it and what makes it go away but it doesn't happen all the time.
There is something weird going on with the charting interface tool and rest service calls.
Expected behavior I would expect the chart to display 1 line when one column is selected, and then add lines as more accounts columns are selected in the multi-select tool.
I don't know why sometimes charts are displaying with data points without lines.
Screenshots
App Export If possible - please attach an export of your budibase application for debugging/reproduction purposes. ???
Desktop (please complete the following information):
Additional context Add any other context about the problem here.