Gettings Started

More
20 Apr 2017 07:52 #4164 by Daniel
Replied by Daniel on topic Getting Started
Hello,
Standard fields point have been explained to you. Here it is:

It will display the columns only with the following data types: "int", "long", "smallint", "double", "date", "datetime", "varchar", "tinyint", "mediumint", "bigint", "bigint", "decimal", "float", "var"

Assisting you in writing an SQL query, would be chargeable. A reply has been also been sent to you for the same. Please reply to that email.

Thanks
Daniel

Please Log in to join the conversation.

  • Art van der Pol
  • Topic Author
  • Offline
  • New Member
  • New Member
More
20 Apr 2017 07:37 #4163 by Art van der Pol
Replied by Art van der Pol on topic Getting Started
Hello,
trust this message finds you well. After sending emails with my details unfortunately, no reply came from your organisation. I saw there were logins and such but not a solution for my problem.

I still hope you can help me.
I figured this out but am unable to see columns in a table chart, so even other graphs I am not going to try yet. All results are under each other. How can I solve this?

SELECT `FieldValue` FROM #__rsform_submission_values WHERE `FormId`='3' AND `FieldName`='Shelter' OR `FieldName`='Manager'

kind regards,
Art

Please Log in to join the conversation.

More
27 Mar 2017 06:55 #4072 by Daniel
Replied by Daniel on topic Getting Started
Please share the details via Contact us form....

Thanks
Daniel

Please Log in to join the conversation.

  • Art van der Pol
  • Topic Author
  • Offline
  • New Member
  • New Member
More
27 Mar 2017 06:47 #4071 by Art van der Pol
Replied by Art van der Pol on topic Getting Started
Hi Daniel,
can I send you some backend login details and some screenshots that you can have a look yourself.
As said, I don't have sql skills, so I even can't write my own query. With some help and working example, I can work the rest out).
kind regards,
Art

Please Log in to join the conversation.

More
26 Mar 2017 03:51 #4066 by Daniel
Replied by Daniel on topic Getting Started
Hello,
What do you mean by Standard fields? You would see all the available columns when you select the database table.

Thanks
Daniel

Please Log in to join the conversation.

  • Art van der Pol
  • Topic Author
  • Offline
  • New Member
  • New Member
More
24 Mar 2017 13:23 #4061 by Art van der Pol
Replied by Art van der Pol on topic Getting Started
Thanks! I just checked it but still don't understand how I can access the needed database and what to do with it.

I created a form and need to access the submitted data. I know in what table the data should be but don't see any other fields then the standard ones.

Hope you can help me out.
Kind regards,
Art

Please Log in to join the conversation.

More
24 Mar 2017 12:31 #4060 by Daniel
Replied by Daniel on topic Getting Started
Hello,
Please check that link now. If you can not find something, Please ask us here, We'll let you know about that.

Thanks
Daniel

Please Log in to join the conversation.

  • Art van der Pol
  • Topic Author
  • Offline
  • New Member
  • New Member
More
24 Mar 2017 12:03 #4059 by Art van der Pol
Replied by Art van der Pol on topic Getting Started
I get an error when I want to view that.
Also, I have seen that page. I tried to find out but your documentation page is not that extended for people who are new to sql.

Somehow I don't see the correct database results I am looking for.

Please Log in to join the conversation.

More
24 Mar 2017 11:53 #4058 by Daniel
Replied by Daniel on topic Gettings Started
Hi,
Please follow the documentation here: www.wdmtech.com/vchart-documentation-dif...t-chart-data-section and find "Chart Data Existing Database" on this page.

Thanks
Daniel

Please Log in to join the conversation.

  • Art van der Pol
  • Topic Author
  • Offline
  • New Member
  • New Member
More
22 Mar 2017 15:25 #4053 by Art van der Pol
Gettings Started was created by Art van der Pol
Hi there,
I am really new in SQL and also working with Databases. I bought VChart hoping that I could easily connect my database with VChart and select fields to create a table, or chart.

I would like some help with the basics of calling the database and then how to call columns in order to show fields. Is there someone who can assist?

Kind regards,
Art

Please Log in to join the conversation.

Cron Job Starts