Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Request Feature: Payee & Category as dropdown #37

Open
wolfsolver opened this issue Dec 18, 2022 · 1 comment
Open

Request Feature: Payee & Category as dropdown #37

wolfsolver opened this issue Dec 18, 2022 · 1 comment

Comments

@wolfsolver
Copy link

It's very usefull if Payee & Category can be defined as dropdown (or even can be define in setting) instead of "twitter-typeahead".

@wolfsolver
Copy link
Author

Hi all, from MMEX version v1.6.2 recursive category was added as new feature. This require to review category/sub-category field in webapp.
DB is changed as #1477 and in general report https://github.com/moneymanagerex/general-reports/tree/master/packages/Category/OneCategoryList

is possible to have new category selection, probabily the best solution is to have a single field with dropdown
filled with result of

WITH RECURSIVE categories(categid, categname, parentid) AS 
(SELECT a.categid, a.categname, a.parentid FROM category_v1 a WHERE parentid = '-1' 
UNION ALL 
SELECT c.categid, r.categname || ':' || c.categname, c.parentid 
FROM categories r, category_v1 c 
WHERE r.categid = c.parentid) 
 SELECT categid, categname FROM categories ORDER by categname;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant