[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-bugs-dist
Subject:    [skrooge] [Bug 349976] default categories for payees
From:       Stephane MANKOWSKI <stephane () mankowski ! fr>
Date:       2015-08-19 19:08:30
Message-ID: bug-349976-17878-rvHiRhVxoU () http ! bugs ! kde ! org/
[Download RAW message or body]

https://bugs.kde.org/show_bug.cgi?id=349976

--- Comment #7 from Stephane MANKOWSKI <stephane@mankowski.fr> ---
Hi, 

I am still thinking to this request.
I would like to try to propose the better category automatically.

Could you do this from the console to help me?
1- export SKGTRACEPERFO=1
2-skrooge
3-Open the page "Debug"
4-Execute the following sql order:
SELECT S1.t_PAYEE, S1.t_REALCATEGORY, 100*S1.NB/S2.NBTOTAL AS POURCENT FROM
(SELECT t_PAYEE, t_REALCATEGORY, count(1) AS NB FROM
v_suboperation_consolidated GROUP BY t_PAYEE, t_REALCATEGORY) S1, (SELECT
t_PAYEE, count(1) AS NBTOTAL FROM v_suboperation_consolidated GROUP BY t_PAYEE)
S2 WHERE S1.t_PAYEE=S2.t_PAYEE AND POURCENT>90

Could you confirm the category is what you would like to see when the payee is
entered?

-- 
You are receiving this mail because:
You are watching all bug changes.
[prev in list] [next in list] [prev in thread] [next in thread]