# CDATA to Exactonline Query

**URL:** <https://community.cdata.com/t/cdata-to-exactonline-query/1024>\
**Category:** CData Connect AI\
**Tags:** sql, exact-online, question, cdata-connect-ai\
**Created:** [February 19, 2025, 3:59pm UTC](https://community.cdata.com/t/cdata-to-exactonline-query/1024 "2025-02-19T15:59:18Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![muthuEOL](https://avatars.discourse-cdn.com/v4/letter/m/cc9497/32.png) [@muthuEOL](https://community.cdata.com/u/muthuEOL)\
**Post date:** [February 19, 2025, 3:59pm UTC](https://community.cdata.com/t/cdata-to-exactonline-query/1024/1 "2025-02-19T15:59:20Z")

</div>

Hi Team,

I am trying to run this query in CDATA through powerautomate but its not producing any results but with some other divisons it producing results strange issue.please guide me on this

SELECT GLAccountCode,MIN(FinancialYear) AS LeastFinancialYear,  
MAX(FinancialYear) AS HighestFinancialYear  
FROM [ExactOnline1].[11111111.[TransactionLines]  
GROUP BY GLAccountCode

---

<div class="post-metadata">

**Author:** ![Ethem\_Q](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ethem_q/32/1997_2.png) [@Ethem\_Q](https://community.cdata.com/u/Ethem_Q)\
**Post date:** [February 20, 2025, 8:57pm UTC](https://community.cdata.com/t/cdata-to-exactonline-query/1024/2 "2025-02-20T20:57:52Z")

</div>

Hi ​ @muthuEOL

If you are running the same query but with a different schema depending on the Division number you are setting then the problem could be related to the Division in question. Can you confirm you have access to the data for this Division? Are you certain you are providing the correct Division as a Schema? In most cases we have seen that Division is a 6 digit number but you are providing a 8 digit Division in your query. Can you double check and verify?

> **[CData JDBC Driver for Exact Online - Division](https://cdn.cdata.com/help/DYK/jdbc/RSBExact_p_Division.htm)**
>
> CData JDBC Driver for Exact Online - RSBExact - Division: The Division associated with the Exact Online administration.

If you think you have the correct Division but are still seeing issues then more details are needed &nbsp;to further troubleshoot the issue. Would you be able to share the corresponding logs from Connect AI? You can find these in the Logs tab within Connect AI. I would recommend you submit a ticket with our support team here [https://www.cdata.com/support/submit.aspx](https://www.cdata.com/support/submit.aspx)&nbsp;&nbsp;so that one of our support specialists can start looking into this.