Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.

  • 14/04/2017 Happy Easter

    Wish a Happy Easter and give 30% discount for all our WordPress and Joomla! extensions. Use EASTER17 coupon code. The offer is valid till 17 April.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

[SOLVED] Help, stuck on a basic SQL query
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: [SOLVED] Help, stuck on a basic SQL query
#58439
Re:Help, stuck on a basic SQL query 1 Year, 1 Month ago Karma: 666
Remove "anno" field from fields list in "SELECT" SQL query. You can use it is directly in "ORDER BY" clause if need this to sort data.

PS: When "Revert data" is set to "Yes", "Columns settings" parameters are applied to transformed table. It doesn't contain "anno" column, it contains "2011-06", "2011-07" and etc. columns.

Regards,
ARI Soft
Last Edit: 2016/09/08 03:50 By admin.
The administrator has disabled public write access.
 
#58440
Re:Help, stuck on a basic SQL query 1 Year, 1 Month ago Karma: 0
Ok, thank you, that did the trick, however the custom labels aren't working when the Revert is enabled. Take a look:

this is the result:
The administrator has disabled public write access.
 
#58441
Re:Help, stuck on a basic SQL query 1 Year, 1 Month ago Karma: 666
As we wrote in our previous, the extension works with transformed table when "Revert data" is enabled. Alias can be set in SQL query. For example:

Code:


SELECT
 id AS `Product Id`,
 YEAR(C.created) AS `Created at`
...



Regards,
ARI Soft
The administrator has disabled public write access.
 
#58442
Re:Help, stuck on a basic SQL query 1 Year, 1 Month ago Karma: 0
I suppose that will have to do. Thank you for your support.
The administrator has disabled public write access.
 
Go to topPage: 12