[SOLVED] Transaction Report with Multiple Categories

General discussion on all other topics under the sun.

Moderator: Renato

Post Reply
KristiB
New MMEX User
Posts: 11
Joined: Sat Jan 28, 2023 6:31 pm
Are you a spam bot?: No

[SOLVED] Transaction Report with Multiple Categories

Post by KristiB »

Hello,

I'm a brand new user. Is it possible to create a Transaction Report with multiple values for Category? I don't see it as an obvious option, but wanted to be sure.

Thanks!
Last edited by KristiB on Sun Jan 29, 2023 8:10 pm, edited 1 time in total.
Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Transaction Report with Multiple Categories

Post by Nikolay »

Set the category names via pipe.
Screenshot 2023-01-29 174749.png
Screenshot 2023-01-29 174749.png (11.76 KiB) Viewed 3177 times
User avatar
Renato
MVP MMEX User
Posts: 655
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Transaction Report with Multiple Categories

Post by Renato »

Unfortunately the selection of subcategories does not work then
Renato Forum Administrator
KristiB
New MMEX User
Posts: 11
Joined: Sat Jan 28, 2023 6:31 pm
Are you a spam bot?: No

Re: Transaction Report with Multiple Categories

Post by KristiB »

Thank you! Even though I can't select to include all subcategories, I can pipe the ones I want in. This works great:

Utilities:Internet|Utilities:Gas|Housing
Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: [SOLVED] Transaction Report with Multiple Categories

Post by Nikolay »

This syntax is called "regular expressions". Here is an example of searching for some subcategories.

Bills:Telephone.*|Un.*
Screenshot 2023-02-01 203441.png
Screenshot 2023-02-01 203441.png (3.97 KiB) Viewed 3129 times
stefanoradice
New MMEX User
Posts: 2
Joined: Wed Jan 03, 2024 5:56 pm
Are you a spam bot?: No

Re: [SOLVED] Transaction Report with Multiple Categories

Post by stefanoradice »

Hi, this looks great. Could another expression *exclude* specific categories?
stefanoradice
New MMEX User
Posts: 2
Joined: Wed Jan 03, 2024 5:56 pm
Are you a spam bot?: No

Re: [SOLVED] Transaction Report with Multiple Categories

Post by stefanoradice »

Solved.

To exclude any categories that contain the string "apple":

^(?!.*apple).*

To exclude any categories that begin with the string "apple":

^(?!apple).*
Post Reply