| Struct |
| cached | |
| created | | string | June, 10 2026 10:26:48 +0000 |
|
| executiontime | |
| expires | | string | June, 10 2026 10:41:48 +0000 |
|
| key | | string | 836B9F5D38F89DFF65025AE3ACE54B83 |
|
| queryParams | | Array | | 1 | | Struct (ordered) | | maxlength | | | list | | | scale | | | separator | | | cfsqltype | | | value | |
| | 2 | | Struct (ordered) | | maxlength | | | list | | | scale | | | separator | | | cfsqltype | | | value | |
| | 3 | | Struct (ordered) | | maxlength | | | list | | | scale | | | separator | | | cfsqltype | | | value | |
| | 4 | | Struct (ordered) | | maxlength | | | list | | | scale | | | separator | | | cfsqltype | | | 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 | |