On May 31, 2009 06:53:23 am Erwin Rieger wrote: > Hi, > > i have another funny problem with querying data from scheme with the > (my)sql backend. > > The query from my previous posts do only return transactions that > are/were shown in the gui (ledger)! > > Steps to reproduce: > * install config.user from my previous post in ~/.gnucash > * open a nonempty sql-book with gnucash (with --extra command line > option), all accounts closed, only account-tree visible > * run scheme query from the "Extensions - AQueryTest1" menu > * watch output on console: "got 0 transactions..." > * open a account with transactions in it > * run scheme query from the "Extensions - AQueryTest1" menu a > second time > * watch output on console, now it reports a number of returned > transactions > * close ledger view of account > * re-run query, console still reports a number of returned > transactions
Yes, there definitely isn't support for general queries, yet. I *do* have something in there which is commented out, so maybe I need to get it working. I wasn't aware of the extensions menu, so didn't have a way of creating a general query. All I had was the ones built into gnucash. The main one is a split query for a single account, used to populate a register, and at this point, the assumption is that that is the only query used. This explains why your BQueryTest fails (isn't split query for a single account) and why this test here fails (it might load a single account, but not all accounts). However, any accounts which have a ledger open would have had those splits/transactions already loaded. Phil _______________________________________________ gnucash-devel mailing list [email protected] https://lists.gnucash.org/mailman/listinfo/gnucash-devel
