Timeline for How to join custom fields data to users table without extra rows in result set
Current License: CC BY-SA 4.0
22 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 18, 2023 at 21:27 | answer | added | Justin White | timeline score: 0 | |
| Feb 21, 2023 at 2:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 24, 2022 at 1:04 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 26, 2022 at 1:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Feb 26, 2022 at 0:04 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 26, 2022 at 23:25 | answer | added | mickmackusa | timeline score: 1 | |
| Jan 26, 2022 at 20:20 | comment | added | Josef Zeevi | I uploaded the files to zeevi.org/mickmackusa. There are 4 that sort of match the code above. Additionally, the INNER joins have become LEFT joins. | |
| Jan 25, 2022 at 22:19 | comment | added | mickmackusa | I may be able to set it up for you if you create a pastebin with your data -- comment the "public" pastebin.com link. | |
| Jan 25, 2022 at 20:35 | comment | added | Josef Zeevi | I have the four database exports randmized as csv files. However, I'm not exactly sure how to create the db_fiddle with them. Help? | |
| Jan 25, 2022 at 19:43 | comment | added | Josef Zeevi | Trying to get to that. My regular job is kicking my butt at the moment. | |
| Jan 25, 2022 at 0:07 | comment | added | mickmackusa | I haven't given up on you Josef. I am still very prepared to help, but first I need to see some sample data from your database (it only needs to be a handful of rows from each table so that I can verify the accuracy of my advice). I am not near my "Joomla computer", so I must wait for you to create a minimal, complete, verifiable example (mcve). Export the targeted table data from PHPMyAdmin (or whatever RDBMS you use) and pasted it into the db-fiddle page. | |
| Jan 24, 2022 at 19:08 | history | edited | Josef Zeevi | CC BY-SA 4.0 |
added 2428 characters in body
|
| Jan 21, 2022 at 20:17 | comment | added | mickmackusa | Let's not abandon this posted question. Please post what you did to resolve your question. Perhaps I can reverse engineer a cleaner solution once I see yours. Your question is a great opportunity to share knowledge; I want to see it through to a proper resolution. Do you know how to export/dump your db tables and paste them into a db-fiddle? You can remove/obfuscate any private/identifiable data so that you don't breech confidentiality. Let me know if I can help further. | |
| Jan 21, 2022 at 15:44 | comment | added | Josef Zeevi | @mickmackusa - thank you for your input and guidance. It seems that subqueries were the way for me to solve the problem so I wound up getting all the field names in one query, then a second query with records for each user, one field per record. Of course, only the filled in fields per-user where returned. I then built an array of one user with ALL the records they had filled in and used that to iterate (in the oputput) printing an empty string where fields aren't filled in and the data that existed. | |
| Jan 15, 2022 at 3:15 | comment | added | mickmackusa | I included two db-fiddle demos in this answer. By building a runnable example of your exported database table(s), volunteers can test their advice without having to see up a test on their own server. | |
| Jan 15, 2022 at 1:05 | comment | added | Josef Zeevi | what is a db-fiddle? | |
| Jan 12, 2022 at 22:24 | comment | added | mickmackusa |
This answer may inspire: joomla.stackexchange.com/a/29134/12352 ...on second thought, I don't think you need a pivot query. It is more likely that you just need to join on field_id AND item_id instead of only joining on item_id. And a LEFT JOIN will be appropriate.
|
|
| Jan 12, 2022 at 22:21 | history | edited | mickmackusa | CC BY-SA 4.0 |
Removed irrelevant thanks and josef from question body, adjusted tags
|
| Jan 12, 2022 at 22:14 | comment | added | mickmackusa |
Thank you very much for joining JSE and posting a clear question that includes proof of research/toil -- I always upvote "good" questions like these. The #__fields_values table typically contains multiple rows for a given "id" -- this is deliberate. The table allows you to store multiple pieces of data for a single entity (e.g. a user's hometown, bloodtype, favorite comic book hero, etc). You are likely to need to specify an additional filter to access a particular field value or use aggregate functions. To make your question more clear, please offer a db-fiddle and your desired result.
|
|
| Jan 12, 2022 at 17:34 | history | edited | Josef Zeevi | CC BY-SA 4.0 |
Tried to get the values, got too many records.
|
| S Jan 12, 2022 at 14:44 | review | First questions | |||
| Jan 12, 2022 at 22:14 | |||||
| S Jan 12, 2022 at 14:44 | history | asked | Josef Zeevi | CC BY-SA 4.0 |