Vanilaa Meta Data

2 posts / 0 new
Last post
Offline
Last seen: 4 years 1 month ago
Joined: 10/01/2013 - 15:08
Vanilaa Meta Data
English

Hi,

I am new to Vanilla. I am exploring and analyzing the vanilla features. During my analysis i found one following issue which is i am not able to understand.

Unable t get distinct values: You have an error in your SQL Syntax; Check the manual that corresponds to your MYSQL server version fot the right syntax to use near "Customer" group by "customer".cms_address' at line 1 select cms_address, count(*) from customer "Customer" group by "Customer".cms_address

If any one can help me on this. i will be gratefull  to him.

Offline
Last seen: 4 years 9 months ago
Joined: 08/23/2013 - 16:08

Hi Manoj,

It's a bit hard to understand what you want to do with this only information, but i'll try.

First thing, the query you show there seems not  correct : something like select count(distinct cms_address) from customer "Customer"  should work to wount the distinct cms_address that you have on your table customer.

Next thing : where do you incounter this error ?

  • In FreeMetadata module
    • On the source table definition
    • On business table
    • On the Vew Query feature
  • In Birt or FreeDashboard usinf a metadata as datasource

More details should help us understand what is you issue.

Thanks