Created
May 23, 2016 10:15
-
-
Save airatkh/76d977de03674da6a57f7c1a8cdd23f1 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"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