Timeline for Get Custom CiviCRM Data by ContactID This is not a duplicate
Current License: CC BY-SA 4.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 19, 2018 at 15:52 | vote | accept | David Richmond | ||
| Aug 14, 2018 at 23:42 | answer | added | Demerit | timeline score: 0 | |
| Aug 14, 2018 at 23:37 | answer | added | Demerit | timeline score: 1 | |
| Aug 14, 2018 at 4:44 | comment | added | David Richmond | No one has a query to solve this problem using the above real sample? | |
| Aug 6, 2018 at 15:02 | answer | added | Hassan Farooq | timeline score: 0 | |
| Aug 6, 2018 at 13:56 | comment | added | David Richmond | Aim is to produce a SQL query for Crystal reporting to match to another data source, I would like to have all custom fields added to the report in a left join to display their actual labels vs value fields. If I could get the SQL to generate the label vs the value above i could extrapolate all of the fields myself. | |
| Aug 6, 2018 at 10:12 | comment | added | Aidan♦ | Why do you want to do this in SQL? As you are finding, the relationships between some of the tables are complex. The recommended way to get data out of Civi is to use the API. Maybe step back a bit and tell us what the overall aim is and we can guide you to another solution. | |
| Aug 6, 2018 at 10:05 | history | edited | Aidan♦ | CC BY-SA 4.0 |
edited title
|
| Aug 6, 2018 at 3:22 | history | edited | David Richmond | CC BY-SA 4.0 |
edited title
|
| Aug 5, 2018 at 23:10 | comment | added | David Richmond | How could i get the results using this exact SQL query, the proposed duplicate question does not answer this | |
| Aug 4, 2018 at 19:58 | comment | added | David Richmond | I would like to delete that question and use this one, i was unable to edit the other one and it seemed like I had too many comments can you help with that? | |
| Aug 4, 2018 at 15:40 | review | Close votes | |||
| Aug 19, 2018 at 3:05 | |||||
| Aug 4, 2018 at 15:24 | comment | added | Demerit | Possible duplicate of MySQL Query to return all custom values | |
| Aug 4, 2018 at 6:35 | history | asked | David Richmond | CC BY-SA 4.0 |