WHERE h_answer =

[Shamaila.Yousaf]

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

[Shamaila.Yousaf]

Can someone kindly assist me with this one please?

 

Thanks

Sxx

[HHH]

try changing to WHERE h_answer='Yes' AND h_question_id = [put the ID of the question field here]

[Shamaila.Yousaf]

Thanks @HHH, would the question id be the Field ID?

[HHH]

On 2/10/2021 at 1:01 PM, Shamaila.Yousaf said:

Thanks @HHH, would the question id be the Field ID?

I am 90% sure it is. But give it a test

[Shamaila.Yousaf]

Thanks @HHH "Query execution error' occurs.  

[Victor]

@Shamaila.Yousaf can you copy/paste here the whole WHERE clause please?

[Shamaila.Yousaf]

Thanks @Victor

 

(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'

[Victor]

@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')

 

[Victor]

... also, not sure about that date logged... you might need to specify the timestamp as well.. 

BETWEEN '2021-01-30 00:00:00' AND '2021-08-31 00:00:00'