#163 Split Transactions are not contained into Transaction Report

1.0_and_below
closed-accepted
nobody
Reports (13)
7
2009-11-12
2009-09-01
Webmaster33
No

When filtering to a main category, not all items of subcategories are found.

For example: I select main category Washing, to list all items of it.
How ever it lists all, except Washing/Softener.

Washing/
- Soap
- Detergent
- Softener
- Silver Nano
- Bleach

If I select just the category Washing/Softener separately, it is listed, correctly.

There is something wrong with the Filtering

The SQL select query, which is used to filter by category:
select * from checkingaccount_v1 where CATEGID=33
This gives the wrong result missing the Softener.

It seems the missing Softener is stored as Split Transaction.
select * from splittransactions_v1 where SUBCATEGID=58

BUG is, that the Split Transactions are not contained into Filter by Category!

Discussion

  • Webmaster33

    Webmaster33 - 2009-09-05

    I mistyped the name:
    Filter by Category = Transaction report/Specify Category

     
  • Webmaster33

    Webmaster33 - 2009-09-05
    • summary: Split Transactions are not contained into Filter by Category --> Split Transactions are not contained into Transaction Report
     
  • Pat O

    Pat O - 2009-11-09
     
  • Pat O

    Pat O - 2009-11-09

    I see that this is a problem, I have added a simple database to illustrate.

     
  • Pat O

    Pat O - 2009-11-09
    • labels: 833058 --> Reports
    • priority: 5 --> 7
     
  • Pat O

    Pat O - 2009-11-09
    • status: open --> open-accepted
     
  • Pat O

    Pat O - 2009-11-12
    • status: open-accepted --> closed-accepted
     
  • Pat O

    Pat O - 2009-11-12

    This artifact has been marked as a duplicate of artifact 2049819 with reason:
    No explanation provided.

     

Log in to post a comment.