Jump to content

Request list view not showing all requests


mikehibbert
 Share

Recommended Posts

I have set up a view for problem tickets with the following criteria:

image.png.da51a057868667fb095e068c84526b4d.png

However, out of 47 tickets, 3 do not appear in the view even though they adhere to the criteria. I only found out about them because a report with exactly the same criteria shows them. I can view the tickets so I don't think permissions are an issue.

Can anyone figure out why this might be the case?

Link to comment
Share on other sites

Hi Mike,

I have seen before where updates to the status via the BPM were incorrectly set up and they were updating the status with just the word Open when it should be status.Open.  If someone has access to the Database Direct tool in Administration, it would be interesting to see if the values held in the status field for these 3 requests match those of other requests.

Link to comment
Share on other sites

Hi James,

I did have access to that tool (didn't know it existed!) so I ran the following query;

SELECT * FROM h_itsm_requests where h_requesttype='problem'

I exported the results to Excel to check what statuses the problems had, but only the following showed, so I don't think the issue you've seen before is what's at play here?

image.png.0ffe29a13dd14eafad1470627274e787.png

 

Cheers,

Mike

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...