I have an issue where I am getting multiple ticket.id values of the same ticket. I have a table with a table column to get the ticket.id. The table's
Data: is calling a query to "getTicketsforSearch". When the search returns the values, I have noticed that it has some multiple IDs (not all IDs are multiple). I have looked in the docs and saw where the spaceship operator <=> could see if it return a 0 indicating that the values are the same, but I am unclear the best approach to take on getting "a unique" ticket.id. - I understand there could be multiple ticket.id with different order numbers. But in this case, the data is the same. It looks as if it is just adding the same ticket.id to multiple rows in the table.
Any suggestions on how/where to narrow down the query and/or the table (or column for ticket.id) for not returning multiple ticket.id's?
(database shows one ticket with the (as shown) 2771, and this ticket.id has no value. Looks as if it was created, and then canceled before entering in any data. It also shows the same order number on all the rows seen.
Thank you for in advance for any help.
- Capture.PNG (11.26 KiB) Viewed 3678 times
