All Questions
7 questions
1
vote
1
answer
85
views
Joomla mysql query - group_contact
I have mysql query:
// Get a db connection.
$db = JFactory::getDbo();
// Create a new query object.
$query = $db->getQuery(true);
$formId = 21;
$query = "select * from #...
- 83
1
vote
1
answer
70
views
PieChart For RSForm for PlotaLot based on a dropdown field
So I got this Pie Chart to display the Count of Voters vs Position and it's working fine.
SELECT Position,
COUNT(1) AS count
FROM (
SELECT
MAX(IF(FieldName = 'Position', FieldValue, NULL)) ...
- 113
1
vote
1
answer
285
views
Create Plotalot chart from RSForm Pro data using pivot query
I'm trying to extract RSForm Pro form data from the database to create Plotalot charts.
There is a field on the form called "resolved" to which users respond "Yes or No". I would ...
- 13
1
vote
2
answers
222
views
How to count aggregate data from RSForm submission values with Joomla's query building methods?
user
SubmissionId
FormId
FieldName
FieldValue
bob
2
16
state
mystate1
bob
2
16
qda
myqad1
bob
2
16
city
mycity1
rob
3
16
state
mystate2
rob
3
16
qda
myqad1
rob
3
16
city
mycity1
jac
4
16
state
...
- 43
2
votes
1
answer
133
views
PlotALOT RSForm Query showing only one result
After being helped very well by Stack community and learning a bit I created a query to show the sum of payments per client. A client can pay multiple times. I would like to know the sum of payments ...
- 47
2
votes
2
answers
310
views
How to refactor two select queries on RSForm submission data?
I was wondering if anyone could help me JOIN multiple queries into one query. Currently, these 2 blocks of code retrieve information from the DB. I am using the "Sourcerer" plugin to add custom PHP ...
- 265
2
votes
2
answers
686
views
How to retrieve RSForm submission data grouped by SubmissionId?
I have a table with 3 columns: SubmissionId, FieldName and FieldValue.
1) SubmissionId keeps ID submission.
2) FieldName stores field name of a form.
3) FieldValue stores field value of form field.
...
- 217