Jump to content

WHERE h_answer =


Shamaila.Yousaf
 Share

Recommended Posts

I would like to create a widget to show the number of loan requests from those who answered Yes that they are self isolating.

Currently the answer is not assigned to a custom field.

 

The number being shown is not correct as the 'Yes' also picks up from other questions asked.

Please see details attached.

 

Thanks in advance all.

 

Sxx

Query.JPG

Procap.JPG

Answer to question.JPG

Link to comment
Share on other sites

  • 4 weeks later...

@Shamaila.Yousaf you closed the bracket too soon...

(h_requesttype='service request')
AND (h_catalog= 'student laptop loan request')
AND (h_datelogged BETWEEN '2021-01-30' AND '2021-08-31')
AND h_pk_reference IN 
(SELECT h_entity_ref FROM h_itsm_questions WHERE h_answer = 'Yes' AND h_question_id ='coronavirusloanrequest')

 

  • Like 1
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...