User Tools

Site Tools


resolution_area:prometheus_resolutions:res-p9118

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
resolution_area:prometheus_resolutions:res-p9118 [2022/12/23 16:01] 10.91.110.100resolution_area:prometheus_resolutions:res-p9118 [2022/12/23 16:02] (current) 10.91.110.100
Line 11: Line 11:
  
 **Manual Action Steps:** Query to check for grand child tickets. **Manual Action Steps:** Query to check for grand child tickets.
-<code> SELECT+<del><code> SELECT
   pt.id AS child_id,   pt.id AS child_id,
   pt.parent_id AS parent_id,   pt.parent_id AS parent_id,
Line 25: Line 25:
      
 From the query above take the child_id value and set the parent_id to null From the query above take the child_id value and set the parent_id to null
-<code>update ticketer.ticket set parent_id = NULL where id = <child_id>;</code>+<code>update ticketer.ticket set parent_id = NULL where id = <child_id>;</code></del>
  
 Just execute the below query: Just execute the below query:
resolution_area/prometheus_resolutions/res-p9118.1671811313.txt.gz · Last modified: 2022/12/23 16:01 by 10.91.110.100