perf(support): find HD tickets without desc scan

Open
#696 0 comments 0 reactions 1 assignee View on GitHub

Maintainers usually reply within 1 day

@primalkz is already working on this.

Since Nov 12, 2026.

  • #749 by @primalkz — open

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

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from frappe/central

All issues in frappe/central

Similar issues

More Python issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.