Gettings Started
- Daniel
-
- Offline
- Administrator
-
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
-
Topic Author
- Offline
- New Member
-
- Posts: 5
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.
- Daniel
-
- Offline
- Administrator
-
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
-
Topic Author
- Offline
- New Member
-
- Posts: 5
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.
- Daniel
-
- Offline
- Administrator
-
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
-
Topic Author
- Offline
- New Member
-
- Posts: 5
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.
- Daniel
-
- Offline
- Administrator
-
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
-
Topic Author
- Offline
- New Member
-
- Posts: 5
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.
- Daniel
-
- Offline
- Administrator
-
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
-
Topic Author
- Offline
- New Member
-
- Posts: 5
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.