Contact Us Today! | vcare@wdmtech.com

WDMtech

Topic-icon vChart gets stuck at this Query...

  • Orhan Bozkartal
  • Orhan Bozkartal's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
1 year 6 months ago #2151

Solved:

There was an annotation failure at seventh to last line. Double Strokes ''.

It works now.

B)

Please Log in or Create an account to join the conversation.

  • Orhan Bozkartal
  • Orhan Bozkartal's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
1 year 6 months ago #2150

The result should look like this.

Please Log in or Create an account to join the conversation.

  • Orhan Bozkartal
  • Orhan Bozkartal's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
1 year 6 months ago #2149

Hi,

we have an customer satisfaction survey where the customer can give grades to different areas.
I have made an sql query with "FlySpeed SQL Query" like this:

Select
  'Eingangsbereich' As Beschriftung,
  Avg(ck05a_rsform_submission_values.FieldValue) As Bericht
From
  ck05a_rsform_submission_values
Where
  ck05a_rsform_submission_values.FormId = 14 And
  ck05a_rsform_submission_values.FieldName = 'EingangsbereichR'
Group By
  ck05a_rsform_submission_values.FieldName,
  ck05a_rsform_submission_values.FormId
Union
Select
  'Flure und Verkehrsflächen' As Column1,
  Avg(ck05a_rsform_submission_values.FieldValue) As Avg_FieldValue
From
  ck05a_rsform_submission_values
Where
  ck05a_rsform_submission_values.FieldName = 'FlurR' And
  ck05a_rsform_submission_values.FormId = 14
Group By
  ck05a_rsform_submission_values.FieldName,
  ck05a_rsform_submission_values.FormId
Union
Select
  'Treppenhäuser und Aufzüge' As Column1,
  Avg(ck05a_rsform_submission_values.FieldValue) As Avg_FieldValue
From
  ck05a_rsform_submission_values
Where
  ck05a_rsform_submission_values.FieldName = 'TreppenhauserR' And
  ck05a_rsform_submission_values.FormId = 14
Group By
  ck05a_rsform_submission_values.FieldName,
  ck05a_rsform_submission_values.FormId
Union
Select
  'Büro und Besprechungsräume' As Column1,
  Avg(ck05a_rsform_submission_values.FieldValue) As Avg_FieldValue
From
  ck05a_rsform_submission_values
Where
  ck05a_rsform_submission_values.FieldName = 'BuroR' And
  ck05a_rsform_submission_values.FormId = 14
Group By
  ck05a_rsform_submission_values.FieldName,
  ck05a_rsform_submission_values.FormId
Union
Select
  'Sanitärbereiche' As Column1,
  Avg(ck05a_rsform_submission_values.FieldValue) As Avg_FieldValue
From
  ck05a_rsform_submission_values
Where
  ck05a_rsform_submission_values.FieldName = 'SanitarbereicheR' And
  ck05a_rsform_submission_values.FormId = 14
Group By
  ck05a_rsform_submission_values.FieldName,
  ck05a_rsform_submission_values.FormId
Union
Select
  'Küchen und Kantinen' As Column1,
  Avg(ck05a_rsform_submission_values.FieldValue) As Avg_FieldValue
From
  ck05a_rsform_submission_values
Where
  ck05a_rsform_submission_values.FieldName = 'KucheR' And
  ck05a_rsform_submission_values.FormId = 14
Group By
  ck05a_rsform_submission_values.FieldName,
  ck05a_rsform_submission_values.FormId
Union
Select
  'Technik und Kelleräume' As Column1,
  Avg(ck05a_rsform_submission_values.FieldValue) As Avg_FieldValue
From
  ck05a_rsform_submission_values
Where
  ck05a_rsform_submission_values.FieldName = 'TechnikR' And
  ck05a_rsform_submission_values.FormId = 14
Group By
  ck05a_rsform_submission_values.FieldName,
  ck05a_rsform_submission_values.FormId
Union
Select
  'Klassen und Kellerräume' As Column1,
  Avg(ck05a_rsform_submission_values.FieldValue) As Avg_FieldValue
From
  ck05a_rsform_submission_values
Where
  ck05a_rsform_submission_values.FieldName = 'KlassenR' And
  ck05a_rsform_submission_values.FormId = 14
Group By
  ck05a_rsform_submission_values.FieldName,
  ck05a_rsform_submission_values.FormId
Union
Select
  'Aufenthalts - und Umkleideräume' As Umkleideräume,
  Avg(ck05a_rsform_submission_values.FieldValue) As Avg_FieldValue
From
  ck05a_rsform_submission_values
Where
  ck05a_rsform_submission_values.FieldName = 'AufenthaltsraumR' And
  ck05a_rsform_submission_values.FormId = 14
Group By
  ck05a_rsform_submission_values.FieldName,
  ck05a_rsform_submission_values.FormId
Union
Select
  '''Sonstige Nutzflächen' As Column1,
  Avg(ck05a_rsform_submission_values.FieldValue) As Avg_FieldValue
From
  ck05a_rsform_submission_values
Where
  ck05a_rsform_submission_values.FieldName = 'SonstigeR' And
  ck05a_rsform_submission_values.FormId = 14

After pasting the query above the loading bar of vChart didn't not disappear. Is there something in the query, that vChart didn't support?

In the Attachment i add the Sample Query.


Thx and regards,
Orhan

Please Log in or Create an account to join the conversation.