Creating Widgets

[Sam Howlett]

Hello, I am trying to create some status widgets showing engineers call assignments. 

The widget has been created to show how many active calls each engineer is currently working on but for this instance, i want to exclude the unassigned calls from the support queue. 

This is the filter I am currently using, is there anyway I can exclude the unassigned calls that appear in an N/A column in the chart?

h_status IN('status.new','status.open','status.onHold') and h_requesttype IN ('Incident', 'service request') and h_fk_team_name IN ('MSE DS Desktop Support - 2nd Line')

 

Thanks

Sam

[Martyn Houghton]

@Sam Howlett

You could try h_ownerid is null.

Cheers

Martyn

[Sam Howlett]

I have tried that but it only shows me unassigned calls then, not those with the engineers. 

I also tried is not null but this gives me an error

[Steve Giller]

@Sam Howlett h_ownerid is null will show unassigned requests, as you've found. Try h_ownerid is not null

[Sam Howlett]

That doesnt work either, it applies but doesnt make any change to the chart. 

The unassigned requests are showing in a column named N/A so i have tried is not null and is not ('N/A') 

ive tried using 'and' and 'WHERE' but neither are working. 

 

[Steve Giller]

Without seeing the full config there's an element of "looking through closed eyes" here, but it may be worth trying h_ownerid is not null AND h_ownerid != ''

[Sam Howlett]

I get a query execution error using that one too

In another widget i have created, i have managed to view just unassigned requests using h_ownername != "N/A" so i believe this should work in this instance but i need to know how to tell the system to exclude not include. Is there any documentation around the configuration of widgets that I could read through?