Contact Us Today! | vcare@wdmtech.com

WDMtech

Topic-icon Gettings Started

More
5 months 4 days ago #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
  • Fresh Boarder
  • Fresh Boarder
More
5 months 4 days ago #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
5 months 4 weeks ago #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
  • Fresh Boarder
  • Fresh Boarder
More
5 months 4 weeks ago #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
5 months 4 weeks ago #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
  • Fresh Boarder
  • Fresh Boarder
More
6 months 9 hours ago #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
6 months 10 hours ago #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
  • Fresh Boarder
  • Fresh Boarder
More
6 months 11 hours ago #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
6 months 11 hours ago #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
  • Fresh Boarder
  • Fresh Boarder
More
6 months 2 days ago #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.