moneymanagerex icon indicating copy to clipboard operation
moneymanagerex copied to clipboard

Quick (sub-)filter on list of transactions

Open sarjanwebdev opened this issue 2 years ago • 6 comments

Once the Transaction Filter is applied I sometimes need to focus on a subset of records

  1. AS IS I apply a transaction filter to seek a date range, let's say it returns 100 records
  2. REQUEST I want to further zoom into records with certain keyword, which I do not want to do another transaction filter, I wish I could enter the keyword somewhere on the same screen and filter out the particular 22 records. This may not re-query the database but only the current view, hence is quicker. (Keeping HTML+JS client search vs MYSQL server search in mind)

sarjanwebdev avatar Feb 13 '23 04:02 sarjanwebdev

records with certain keyword

What do you mean by 'keyword'? Which column(s) do you want the keyword sub-filter to search in?

tactilis avatar Feb 13 '23 17:02 tactilis

Is it worth considering supporting something like: https://tabulator.info/ for tables, in the same way we have ApexCharts? Will add much more flexibility

E.g. https://tabulator.info/examples/5.4#filter

whalley avatar Feb 13 '23 20:02 whalley

We should be able to search Notes, Amount, Dates, Category name, Split or not, Status, and Balance.

sarjanwebdev avatar Feb 13 '23 23:02 sarjanwebdev

Is it worth considering supporting something like: https://tabulator.info/ for tables, in the same way we have ApexCharts? Will add much more flexibility

E.g. https://tabulator.info/examples/5.4#filter

Something like that would definitely add much more flexibility, but I'm not sure how feasible it is now, given the current components used within MMEX. I took the request @sarjanwebdev to refer to the transaction grids that use the wxWidgets control, not the reports area which uses HTML. But maybe he was referring to both. But even if we did want to enhance the reports, on Windows the embedded Internet Explorer web browser control wouldn't support that, I know there is a separate issue in the backlog on whether to migrate away from the IE browser control but I recall that being a significant effort since Microsoft's Edge WebView2 doesn't support custom schemes and virtual file systems... Just a few things to consider. https://github.com/moneymanagerex/moneymanagerex/issues/5124

rmelillo76 avatar Feb 14 '23 02:02 rmelillo76

Yes, would likely need to update the browser control for windows

whalley avatar Feb 14 '23 09:02 whalley

This issue is stale because it has been open 365 days with no activity. Please update if you want to keep the issue open

github-actions[bot] avatar Feb 15 '24 01:02 github-actions[bot]

Not a fix, but #5512 might help a little?

n-stein avatar Feb 25 '24 02:02 n-stein

Tabulator works with the Edge backend mmex_rTCQJPIvXg

n-stein avatar Feb 27 '24 22:02 n-stein

I want similar thing on transaction list (not on report)

sarjanwebdev avatar Feb 29 '24 03:02 sarjanwebdev