ARI Soft - SQL Query getting form ID, but not submitted data

Home

News

Forum

About Us

Demos

Products

F.A.Q.

Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin

e-mail: info@ari-soft.com

Shopping Cart

You currently have 0 items in your cart.

Show Cart

Recent Events

31/12/2023 New Year SALE

We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

more...
21/11/2023 BLACK FRIDAY 23 is coming

BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.

more...

2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft.

Welcome, Guest
Please Login or Register. Lost Password?

ARI Soft Forum

Joomla components

ARI Data Tables

SQL Query getting form ID, but not submitted data

(1 viewing) (1) Guest

Page: 123

TOPIC: SQL Query getting form ID, but not submitted data

Forum Tools

#28754

Re:SQL Query getting form ID, but not submitted data 12 Years, 1 Month ago	Karma: 0
Can anyone help me with getting the SQL DUMP?? I really need help and am against a deadline by Friday. I appreciate any help through this.

pfinkie

The administrator has disabled public write access.

#28775

Re:SQL Query getting form ID, but not submitted data 12 Years, 1 Month ago	Karma: 748
You can read how to create a SQL dump file in PHPMyAdmin here. Send SQL dump (not CSV or any other) please. PS: You can also ask about an SQL query "RSForm" support. Regards, ARI Soft

admin

The administrator has disabled public write access.

#28778

Re:SQL Query getting form ID, but not submitted data 12 Years, 1 Month ago	Karma: 0
Attached is the exact table dump. What I am trying to display is the column headers to be the FieldNames and the FieldValues to populate under those headers. I have tried RSJoomla Support, but they don't moderate their Forums and I submitted a ticket a week ago. Thanks for your help on this! File Attachment: File Name: _j17_rsform_submission_values_.zip File Size: 22958

pfinkie

Last Edit: 2012/05/31 06:58 By pfinkie.Reason: SQL File Zipped

The administrator has disabled public write access.

#28782

Re:SQL Query getting form ID, but not submitted data 12 Years, 1 Month ago Karma: 748

An SQL query looks like:

Code:



SELECT

 SV_Date.FieldValue AS Date,

 SV_FirstName.FieldValue AS FirstName,

 SV_LastName.FieldValue AS LastName

FROM

 #__rsform_submission_values SV_Date LEFT JOIN #__rsform_submission_values SV_FirstName

    ON SV_Date.SubmissionId = SV_FirstName.SubmissionId

 LEFT JOIN #__rsform_submission_values SV_LastName

    ON SV_Date.SubmissionId = SV_LastName.SubmissionId

WHERE

 SV_Date.FieldName = 'Date'

 AND

 SV_FirstName.FieldName = 'First Name'

 AND

 SV_LastName.FieldName = 'Last Name'

GROUP BY

 SV_Date.SubmissionId

It is necessary to add new "JOIN" construction for each submitted field to the query.

Regards,
ARI Soft

admin

The administrator has disabled public write access.

#28783

Re:SQL Query getting form ID, but not submitted data 12 Years, 1 Month ago	Karma: 0
Thank you so much for looking into this! At first glance, it is working and I will see if I can build upon it. I will be sure to try in the morning. Thanks again for all that you do here!

pfinkie

The administrator has disabled public write access.

#28801

Re:SQL Query getting form ID, but not submitted data 12 Years, 1 Month ago Karma: 0

I tried adding the new "JOIN" construction following what you had which didn't work. Did I do something wrong with the syntax? I'm new to this flow.

Thank you for your quick replies,
Paul

Code:

SELECT

 SV_Date.FieldValue AS Date,

 SV_FirstName.FieldValue AS FirstName,

 SV_LastName.FieldValue AS LastName,

 SV_EventNumber.FieldValue AS EventNumber

FROM

 #__rsform_submission_values SV_Date

 LEFT JOIN #__rsform_submission_values SV_FirstName

    ON SV_Date.SubmissionId = SV_FirstName.SubmissionId

 LEFT JOIN #__rsform_submission_values SV_LastName

    ON SV_Date.SubmissionId = SV_LastName.SubmissionId

 LEFT JOIN #__rsform_submission_values SV_EventNumber

WHERE

 SV_Date.FieldName = 'Date'

 AND

 SV_FirstName.FieldName = 'First Name'

 AND

 SV_LastName.FieldName = 'Last Name'

 AND

 SV_EventNumber.FieldName = 'Event Number'

GROUP BY

 SV_Date.SubmissionId

pfinkie

Last Edit: 2012/05/31 22:20 By pfinkie.Reason: Missed comma (,)

The administrator has disabled public write access.

Page: 123

Useful Links