# Need advice to translate a SQL request to a REST code

**URL:** <https://discuss.elastic.co/t/need-advice-to-translate-a-sql-request-to-a-rest-code/1650>\
**Category:** Elasticsearch\
**Created:** [June 1, 2015, 2:44pm UTC](https://discuss.elastic.co/t/need-advice-to-translate-a-sql-request-to-a-rest-code/1650 "2015-06-01T14:44:49Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![JUSTINE\_STIENNE\_HOUP](https://avatars.discourse-cdn.com/v4/letter/j/5fc32e/32.png) [@JUSTINE\_STIENNE\_HOUP](https://discuss.elastic.co/u/JUSTINE_STIENNE_HOUP)\
**Post date:** [June 1, 2015, 2:44pm UTC](https://discuss.elastic.co/t/need-advice-to-translate-a-sql-request-to-a-rest-code/1650/1 "2015-06-01T14:44:49Z")

</div>

Hello, All

I'm a beginner in Elasticsearch technology.

Below, is my ORACLE's SQL code I want to translate in a REST Elasticsearch

SELECT tra\_process\_type\_name, E.EXC\_NAME,  
sum(decode(TRA\_STATUS, 'C', 1, 0)) AS TRA\_COUNT\_C,  
max (tra\_timestamp\_last) AS TIMESTAMP  
FROM oxy\_trace  
WHERE TRA\_TIMESTAMP\_FIRST between {ts '2015-05-01 00:00:00.0'} and {ts '2015-05-07 00:00:00.0'} AND TRA\_TIMESTAMP\_LAST \> {ts '2015-05-01 00:00:00.0'}  
GROUP BY tra\_process\_type\_name, E.EXC\_NAME  
ORDER BY TIMESTAMP DESC

Could you help me ?

Is a tool can translate, in automatic mode, a SQL code to ELK REST code ?

Thanks a lot  
Regards  
Justine

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 12:10am UTC](https://discuss.elastic.co/t/need-advice-to-translate-a-sql-request-to-a-rest-code/1650/2 "2017-07-06T00:10:27Z")

</div>