Search Results

A few points: You have really made a rod for your back by not "normalizing" your org table. My strong recommendation is to restructure your org table to have a type column versus three static colum …

For your dynamic pivot, you can pre-fetch all #__fields titles, and create a pivot query on the fly in PHP. … Alternatively, there is nothing wrong with grabbing my very first (non-pivot) query, extracting all of the unique title values from the verbose result set, then iterating your result set to manually group …

From this sample data: INSERT INTO `o2pe0_rsform_submission_values` (`SubmissionValueId`, `FormId`, `SubmissionId`, `FieldName`, `FieldValue`) VALUES (2124732, 23, 47529, 'SHELTER', 'Bellville'), (212 …

I really can't see the use in retrieving the SubmissionValueIds or FormIds associated with the rows of data after you pivot into an associative structure. … If you already know all of the FieldName values that you are going to processing, you can most simply use a pivot technique -- here are MANY demonstrations that I've posted. …

This will rely heavily on the magic of a "pivot" technique. Here are some more examples in JSE to compare/contrast with https://joomla.stackexchange.com/questions/tagged/pivot. … If you need more examples, I have a few Stack Overflow pivot answers too. 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. …

I think the simplest way forward is to use a JOIN to relate your first query to your second query. An INNER JOIN (same as JOIN) will only generate rows in the result set where both "derived" queries …

This technique is commonly referred to as a PIVOT. You can find my other Joomla-related pivot queries on Joomla Stack Exchange. … I will show a classic pivot query with an INNER JOIN and another query that uses a subquery with EXIST to isolate the unique counts. …

If you are new, then I'd like to include some basic error checking as well as printing out the generated query and the 2-column resultset. Untested Code: $db = JFactory::getDBO(); try { $query …

What is best suited is a "pivot" technique. There is no cleaner way to deal with rsform's submission data. …

The cleanest, most direct way to perform this task is with a "pivot" technique. … $e->getMessage(), 'error'); // never show getMessage() to public } If you would like to see this technique in other contexts, here are some other pivot solutions that I have posted: https://joomla.stackexchange.com …

Raw Pivot Query SELECT ju.username, ju.name, MAX(IF(jfv.field_id = 2, jfv.value, NULL)) AS `door`, MAX(IF(jfv.field_id = 3, jfv.value, NULL)) AS `staircase`, MAX(IF(jfv.field_id …

called "genre" 2 relates to the custom field called "somethingelse" To use pure sql to extract a single article's custom values and assign meaningful column aliases you can use a technique called a pivot … Not using a pivot will mean your result set will have n rows with one value in each row. …

Use a pivot technique instead of making multiple JOINs. This table is often gigantic and the fewer times you need to join the whole table in your sql, the better. …

Add a HAVING clause that pre-qualifies aggregrate data in your derived table. The following condition will require that a submission contains a Part No value of 5. HAVING COUNT(FieldName = 'Part No' …

It looks like you found the pivot pages on JSE -- well done. Also, you coding attempt is very close -- you just need to create two-column rows for PlotALot. …