If you need to retrieve data based on a more complex query than just selecting the field from a single table, you will need this feature. The SQL Query can be as much complicated as the database provider can support. This means that you could join tables, do summarization and grouping without any issues.
Follow the below steps to achieve SQL Query:
- From the Tables window, in the upper left hand corner, click Add and select Add SQL Query.
2. In the Destination Table Name field, enter a name for the table destination.
3. In the SQL Expression text box, enter the SQL statement and click Save.
Important:
Using of the schema name in the SQL statement is highly recommended.
Tip:
Variables can also be used to create queries in an SQL statement.
Example:
SELECT * FROM TABLE WHERE YEAR = @YEAR
Note:
The QUERY will be added in the list.
Once in the list, you can:
- Do a mouse over to see the whole SQL statement,
- Click on the QUERY hyperlink in the Table Source column to change the statement any time,
- Apply a filter directly in the query statement (ex: select field1, sum(qty) from schema.table1 group by field1 where field2 = 2023) or in the row of the Filter column as a regular table If you are looking for more clarity.
Tip:
You can also get access to the Tables windows by clicking on the hyperlink within the Tables column on the Extraction page.
About Us
Greytrix – a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.
Greytrix caters to a wide range of Sage X3 (Sage Enterprise Management) offerings – a Sage Business Cloud Solution. Our unique GUMU™ integrations include Sage X3 for Sage CRM, Salesforce.com and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3 (Sage Enterprise Management). Currently we are Sage X3 Implementation Partner in East Africa, Middles East, Australia, Asia. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight and Letter of Credit for Sage X3 to Sage business partners, end users and Sage PSG worldwide.
Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star app listed on Salesforce AppExchange.
For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com. We will be glad to assist you.