Topic-icon Gettings Started

More
20 Apr 2017 07:52 #4164

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 or Create an account to join the conversation.

  • Art van der Pol
  • Art van der Pol's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
20 Apr 2017 07:37 #4163

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 or Create an account to join the conversation.

More
27 Mar 2017 06:55 #4072

Please share the details via Contact us form....


Thanks
Daniel

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

  • Art van der Pol
  • Art van der Pol's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
27 Mar 2017 06:47 #4071

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 or Create an account to join the conversation.

More
26 Mar 2017 03:51 #4066

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 or Create an account to join the conversation.

  • Art van der Pol
  • Art van der Pol's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
24 Mar 2017 13:23 #4061

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 or Create an account to join the conversation.

More
24 Mar 2017 12:31 #4060

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 or Create an account to join the conversation.

  • Art van der Pol
  • Art van der Pol's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
24 Mar 2017 12:03 #4059

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 or Create an account to join the conversation.

More
24 Mar 2017 11:53 #4058

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 or Create an account to join the conversation.

  • Art van der Pol
  • Art van der Pol's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
22 Mar 2017 15:25 #4053

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 or Create an account to join the conversation.

Cron Job Starts