| Struct |
| cached | |
| created | | Date Time (Etc/UTC) | | {ts '2026-06-10 10:26:48'} |
|
| executiontime | |
| expires | | Date Time (Etc/UTC) | | {ts '2026-06-10 10:41:48'} |
|
| key | | string | 836B9F5D38F89DFF65025AE3ACE54B83 |
|
| queryParams | | Array | | 1 | | Struct | | cfsqltype | | | list | | | maxlength | | | scale | | | separator | | | value | |
| | 2 | | Struct | | cfsqltype | | | list | | | maxlength | | | scale | | | separator | | | value | |
| | 3 | | Struct | | cfsqltype | | | list | | | maxlength | | | scale | | | separator | | | value | |
| | 4 | | Struct | | cfsqltype | | | list | | | maxlength | | | scale | | | separator | | | value | |
|
|
| server | |
| sql | | string | SELECT COUNT(*) as TotalRowCount FROM Agents WITH (NOLOCK) LEFT OUTER JOIN agents_preferences WITH (NOLOCK) ON agents_preferences.publicid=Agents.publicid LEFT OUTER JOIN Agents_Links WITH (NOLOCK) ON Agents_Links.publicid=Agents.publicid INNER JOIN Offices WITH (NOLOCK) ON Offices.OfficeID=Agents.OfficeID INNER JOIN companies WITH (NOLOCK) ON companies.companyNumber=Offices.companyNumber OUTER APPLY ( SELECT TOP 1 * FROM Agents_Teams_Members WITH (NOLOCK) WHERE Agents_Teams_Members.publicid=Agents.publicid and agentteamid in ( select agentteamid from agents_teams where status='A' ) ORDER BY Agents_Teams_Members.LastUpdateDateTime DESC ) Agents_Teams_Members OUTER APPLY ( SELECT TOP 1 * FROM Agents_Teams WITH (NOLOCK) WHERE Agents_Teams.AgentTeamID=Agents_Teams_Members.AgentTeamID AND Agents_Teams.Status='A' ) Agents_Teams WHERE (Agents.Status='A') AND ( Agents.publicid in ('626601') ) |
|
| tags | |