Replies: 6 comments
-
Hello and welcome to SQLPage! It looks like your data is in a Microsoft SQL Server database, and you want to run some analysis over it in SQL, and display the results as graphs. Is that so? If that's the case, then you don't really need json anywhere, do you? You can just use the normal chart component and feed it data from your database using sql directly. And if you need to reuse the same intermediate results to build multiple graphs, the most natural way to do it is to build a view in your database, and query that view in SQLPage, not to "save the result in a variable". If you really need to query or produce JSON, you can use your database's built-in functions to do so, but I really don't think that's what you want here. If you want an example of using SQLPage to produce graphs based on analytics data in a database view, you can check out this one (which uses SQLite, not SQL server, but the principles are the same) : https://github.com/lovasoa/SQLpage/tree/main/examples/splitwise |
Beta Was this translation helpful? Give feedback.
-
thanks for the quick response, unfortunately I didn’t receive a response from you, I’ll try to give you the data |
Beta Was this translation helpful? Give feedback.
-
For the json file, do you need to download it to your application user's computer, or to save it to the server where SQLPage is running?
If you encounter issues while writing your queries, please paste your SQL, with a screenshot of the error you are getting here ! |
Beta Was this translation helpful? Give feedback.
-
|
Beta Was this translation helpful? Give feedback.
-
Forgive me, but I found your product to be very complex, I cannot use it to perform simple business tasks, such as |
Beta Was this translation helpful? Give feedback.
-
I'm sorry to hear you are finding SQLPage complex ! Its goal is to make web application creation easier, not more difficult. If you have any suggestion about how to improve the documentation, they are welcome. Even better, if you want to improve the official website, it is open-source too, so you can contribute. SQLPage is not a commercial product, it is an open source tool driven by a community of volunteers. It is provided as-is, without any guarantees or engagement. If you need personalized support, and tailored help, I'd be happy to setup a contract for that ! Feel free to contact me on Saving the results of a query to a json file and then using that to build a graph is unusual and a little opposite to the philosophy of simplicity behind SQLPage. Is there a reason you want to do that rather than just build the graph directly from your SQL query without the intermediary json export ? If that is really what you want, however, it is definitely possible to achieve with SQLPage. You would use
But once again, this is very unnecessarily complicated if you just want to show your query results as a graph. You can show a graph just by adding If you need paid personalized support, feel free to send an email to |
Beta Was this translation helpful? Give feedback.
-
Hello, I would like to know if I can get json from my sample
example:
Beta Was this translation helpful? Give feedback.
All reactions