Get The Users whose are currently working on Cases

(0) Share

Report

Posted on by Shakti Singh Rajput

958

Scenario is First, I want to show the status of cases in SQL Server. In Status field there is no value to show the case is open i guess.

So how could i get that how many cases are open and their user name?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report
Copy link

Link copied!

Hi Shakti,

Would you mind explaining bit more on " In Status field there is no value to show the case is open i guess.".

However if i understood your second line correctly - all you need is below :

Select OwnerIdName, count(incidentid) as CountOFCases from incident
where statecode = 0
group by OwnerIdName

Was this reply helpful? Yes No
Shakti Singh Rajput 958 on at

Like (0)

Report
Copy link

Link copied!

Thanks for response Rawish,

I want to display that which cases are open state and close state.

Like, I had a custom field "Case_Status" which is blank initially. When I am open a case record within the list of case records then the value of "Case_Status" field is assigned to 'Opened' and if the case is closed(Resolved) then update the field value to Closed.

How could i get the same?

Was this reply helpful? Yes No
Suggested answer

Abdul Wahab 12,119 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Shakti Singh Rajput,

Use advanced find view. I think this will solve your problem. Feel free to ask more.

Thanks

Regards,

AW

Was this reply helpful? Yes No
Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report
Copy link

Link copied!

To get the label names in sql query you might have to perform a join operation on a stringmap table.

However i would recommend you to use simple like below.

1. open the attribute "Case_Status" from customiziation and see what value(integer) represent open and what represents a close case:

then simply run the below query:

Select Case_Status, count(Case_Status) as CountOFCases from incident

group by Case_Status

make sure the field name is correct.

Was this reply helpful? Yes No
Shakti Singh Rajput 958 on at

Like (0)

Report
Copy link

Link copied!

Could you please elaborate?

Was this reply helpful? Yes No
Suggested answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Shakti,

You have tagged your question as CRM Online. If it is correct and you are on CRM Online then you can't access SQL. If you are on premise, you can follow above suggestions.

Hope this helps.

Was this reply helpful? Yes No
RaviKashyap 55,410 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Shakti,

How did you get on with this? If you have got your answer, please close the thread by mark the suggestion as answer if it helped you

Was this reply helpful? Yes No