Skip to content

Instantly share code, notes, and snippets.

@airatkh
Created May 23, 2016 10:15
Show Gist options
  • Save airatkh/76d977de03674da6a57f7c1a8cdd23f1 to your computer and use it in GitHub Desktop.
Save airatkh/76d977de03674da6a57f7c1a8cdd23f1 to your computer and use it in GitHub Desktop.
{
"name": "request",
"args": {
"requests": [
{
"clientId": "b353448f-dce5-4e5f-b376-2e6ea0bee4f0",
"data": "SELECT\n 'get_customer_by_call' AS query_type, 'tricepssql' AS service_type, '5fac4982-56e7-b621-7de4-70987b178cd1' AS call_id, '6b57565c-70f2-4b97-9f78-24a89aabeb66' AS call_company_id, Agent.AgentID AS customer_id, Agent.Name AS customer_fullname, Agent.FirstName AS customer_first_name, Agent.MiddleName AS customer_middle_name, Agent.LastName AS customer_last_name, Agent.Sex AS customer_sex, Agent.AgentFaceType AS customer_ownership, Agent.LegalName as customer_legalname, Agent.Comment AS customer_comment FROM Contact LEFT JOIN agent on agent.AgentID = Contact.AgentID WHERE REPLACE(contact.Value, '-', '') LIKE '%79250903387%' ORDER BY Agent.AgentID desc",
"id": "E9CD1E3C-A324-2A82-9B2C-E70EB6B4E1EF"
}
]
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment