Yes, I think it is 100% of the stock reports, and the reason you are seeing it included in the SQL viewed post run, is because the filters are parameters which get sent to the Stored Procedure, but then that's all you see. You're not seeing what the stored procedure is doing with those parameters.
For example, here is the SQL output from running the Agent All Fields Report and selecting both a Resource Group called Sales and a Skill called Support (Indentation was my own doing, it shows on one line normally):
{
call sp_agent_all_fields(
'2020-09-04 05:00:00',
'2020-09-05 04:59:59',
'0',
'Sales',
null,
'Support',
null,
'CUIC\uccxadmin'
)
}
If we look at the stored procedure definition, we can see the order of the params and how they align with the above output:
CREATE FUNCTION sp_agent_all_fields (
p_startTime DATETIME YEAR TO FRACTION(3),
p_endTime DATETIME YEAR TO FRACTION(3),
p_sortBy INT DEFAULT 0,
p_resGroupList LVARCHAR(4000) DEFAULT 'NULL',
p_agentList LVARCHAR(4000) DEFAULT 'NULL',
p_skillList LVARCHAR(4000) DEFAULT 'NULL',
p_teamList LVARCHAR(4000) DEFAULT 'NULL',
p_user LVARCHAR(4000) DEFAULT 'NULL
)
If we were to follow the logic of the stored procedure to see what it does with all of that information, we can see that it first sets up a conditional IF, and we can notice that in no way can two things be true at the same time, and further, the IF processes top down. I.e., There is a priority to the filters. E.g., If you set both Resource Group and Skill Name, RG takes precedence over Skill Name and your report will only show results from the RG.
-- list of resource group names selected
IF p_resGroupList <> 'NULL' then
let l_selType = 1;
let l_selvalue = p_resGroupList;
let l_rgSelected = 1;
-- list of agent login id's selected
ELIF p_agentList <> 'NULL' then
let l_selType = 2;
let l_selvalue = p_agentList;
-- list of call skills selected
ELIF p_skillList <> 'NULL' then
let l_selType = 3;
let l_selvalue = p_skillList;
let l_skillSelected = 1;
-- list of teams selected
ELIF p_teamList <> 'NULL' then
let l_selType = 4;
let l_selvalue = p_teamList;
let l_tmSelected = 1;
-- default: all agents selected
ELSE
let l_selType = 0;
let l_selValue = null;
From here the stored procedure goes on to process the info further, asking another SP to get a list of Agents for it, and then filters out Agents not belonging to the logged in supervisor, etc. But the damage is already done, so those further details are unimportant.
