perf(support): find HD tickets without desc scan
Maintainers usually reply within 1 day
Assessment
This issue has not been assessed yet.
Description
Central finds a team's tickets by matching description LIKE '%%' on Helpdesk's HD Ticket table, plus owner = . support.frappe.io has about 66,000 tickets. description is long text with no usable index, so every lookup scans the whole table. Need a better way to do this.
Currently the search would be off, as there are no articles. But before enabling we need a better way to do this.
One HD Customer per team (preferred). Set HD Ticket.customer, which is indexed and which customers can't set. Filter lists and search by customer. Central's service user needs create permission on HD Customer. Later, syncing team members as customer managers lets teammates open each other's tickets in the portal.
Or
An indexed, read-only custom field central_team on HD Ticket. Set it on create and filter by it. This doesn't help portal access for teammates, but that is still ok.
- Dominant language
- Python
- Stars
- 25
- Forks
- 28
- Avg merge
- 8h 28m
- Merged PRs (30d)
- 202
Getting set up
This project ships no dev container, Dockerfile or contributing guide, so setting up is up to you: start from its README, and see our first-contribution guide for the general steps.
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from frappe/central
-
The server usage charts can't be zoomedPossibly taken @primalkz claimed this today. Open
frappe/central#770 · 1 assignee ·
Maintainers usually reply within 1 day
-
Turning off email for a category still sends critical emailsPossibly taken @primalkz claimed this today. Open
frappe/central#766 · 1 assignee ·
Maintainers usually reply within 1 day
-
Improve the support ticket module backendPossibly taken @primalkz claimed this today. Open
Difficulty 5/5 Over a week Newbie friendliness 35/100
frappe/central#750 · 1 assignee ·
Maintainers usually reply within 1 day
-
Show resize progress on the server pagePossibly taken @primalkz claimed this 2 days ago. Open
Difficulty 4/5 3-5 days Newbie friendliness 35/100
Maintainers usually reply within 1 day
-
Pilot alerts: persist context, carry action_route, and rate-limit flapping sitesPossibly taken @primalkz claimed this 2 days ago. Openenhancement
Difficulty 4/5 3-5 days Newbie friendliness 42/100
frappe/central#743 · 1 assignee ·
Maintainers usually reply within 1 day
Similar issues
-
ready-for-agent
Difficulty 1/5 1-3 hours Newbie friendliness 79/100
gregwebs/agent-vm-images#216 ·
Maintainers usually reply within 1 day
-
Layout accepts a step threshold of 0 or less, then in-toto-verify crashes with StopIterationPossibly taken @BahaaMattar claimed this today. Open
Difficulty 2/5 1-3 hours Newbie friendliness 76/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
gcivil-nyu-org/team5-mon-fall26#145 ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
gcivil-nyu-org/team3-mon-fall26#156 ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
antlr/grammars-v4#5220 ·
Maintainers usually reply within 1 day