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.

Sign up for GitHub

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

Jump to bottom

Tidy - Ticket_view_all SQL query + possible pagination #933

Closed
wrongecho opened this issue Apr 7, 2024 · 0 comments · Fixed by #934
Closed

Tidy - Ticket_view_all SQL query + possible pagination #933

wrongecho opened this issue Apr 7, 2024 · 0 comments · Fixed by #934
Assignees
@wrongecho
Labels
enhancement New feature or request

Comments

@wrongecho
Copy link
Collaborator

L30 = $all_tickets = mysqli_query($mysqli, "SELECT * FROM tickets LEFT JOIN contacts ON ticket_contact_id = contact_id WHERE $ticket_status_snippet AND ticket_client_id = '$session_client_id' ORDER BY ticket_id DESC");

For efficiency, this should only request the fields required to show the ticket number, subject, contact and status. We should also consider pagination if possible?

--

2023-02-01 - Created draft
2024-04-07 - Promoted to issue
@wrongecho wrongecho self-assigned this Apr 7, 2024
@wrongecho wrongecho added the enhancement New feature or request label Apr 7, 2024
wrongecho added a commit to wrongecho/itflow that referenced this issue Apr 7, 2024
@wrongecho
Client Portal - Ticket SQL Tidy
da3201d 
Tidy up the client portal sql for viewing tickets to only grab required fields - itflow-org#933
@wrongecho wrongecho mentioned this issue Apr 7, 2024
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@wrongecho wrongecho

Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Client Portal - Ticket SQL Tidy wrongecho/itflow
1 participant
@wrongecho