This forum has been archived. All content is frozen. Please use KDE Discuss instead.

SQL code for custom reporting?

Tags: None
(comma "," separated)
tjjunior
Registered Member
Posts
5
Karma
0

SQL code for custom reporting?

Mon Aug 22, 2016 8:34 pm
Hi,

I use KMM on Windows using the Windows installer. Tried once to install KDE itself so I could install the developer version but with no luck. Given I have no experience in C++, probably not the end of the world if I don't have the developer version. However, I do run it using the MySQL back end and would love to be able to do some custom reports (using PHP which I have a lot more experience in) beyond the KMM reports interface. Is the SQL code used to pull the existing reports available anywhere without having to install C++? Happy to share any new reports I come up with as well if anyone's interested. If it's not easily available, I can always just log the SQL calls made and do it that way but that would take a lot more work to sort them all out.

Thanks!
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS

Re: SQL code for custom reporting?

Tue Aug 23, 2016 7:16 am
tjjunior wrote:Is the SQL code used to pull the existing reports available anywhere without having to install C++

Certainly, you can always take a look at the code with installing C++. After all, the source code is all text files. :)
Seriously, the reporting code is not based on SQL at all for historical reasons, since KMyMoney's generic data storage is based on its own XML scheme and kept in a flat file. You might be better off understanding the SQL data structure and base your reports on it. Maybe others have already created reports and can give you some advise - I haven't.. A good source might also be the developer mailing list. Checkout the KMyMoney support page to find out more about the various places in case you haven't done already..


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5


Bookmarks



Who is online

Registered users: Bing [Bot], Google [Bot], Yahoo [Bot]