Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 14856

For question regarding Joomla 3.x of the Content Management System. This includes versions 3.0 up to 3.10.

0 votes

How to count aggregate data from RSForm submission values with Joomla's query building methods?

tank you @mickmackusa I change to this code SELECT count(DISTINCT a.SubmissionId) FROM `#__rsform_submission_values` a JOIN `jwqt5_rsform_submission_values` b ON(a.submissionid=b.su …
saeed's user avatar
  • 43
0 votes
1 answer
112 views

How to conditionally add filters to my query of the rsform_submission_values table?

$FormId=23; $qustioan1=qka1; <form method="post" action="#"> <select name="state" onChange="irancitylist(this.value);"> <option value="">--select state --</option> <option value=" …
saeed's user avatar
  • 43
0 votes

How to show multidimensional data in my CanvasJS chart?

solved by changing foreach($countMartabehName as $row) { $dataPoints = array( array("label"=> $row->MartabehName , "y"=> $row->$key) ); } to $dataPoints = array(); foreach($countMarta …
saeed's user avatar
  • 43
1 vote
2 answers
315 views

How to show multidimensional data in my CanvasJS chart?

<?php $db->setQuery("SELECT MartabehName, COUNT(MartabehCode) FROM `#__dimteacher` GROUP BY MartabehName"); $countMartabehName = $db->loadObjectList(); foreach($countMartabehName as $row) { fore …
saeed's user avatar
  • 43
1 vote
2 answers
214 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 ja …
saeed's user avatar
  • 43