mysql - row for columns gravity forms

Question

mysql - row for columns gravity forms

Navigation

#1 by (2 votes)

2

Good afternoon, I'm a good beginner in database and programming, but I like to tinker when it's needed. I have a table in the database with answers of a form made in wordpress by gravity forms that presents the responses online such that:


id  lead_id field_number    value
1   1       1               título1
2   1       2               descrição1
3   1       3               movimento1
4   1       4               status1
5   1       5               lat1
6   1       6               long1
7   1       7               nome1
8   1       8               email1
9   2       1               titulo2
10  2       2               descrição2
11  2       3               movimento2
12  2       4               status2
13  2       5               lat2
14  2       6               long2
13  2       7               nome2
14  2       8               email2

Since lead_id is the identifier of the form's responses made by each user, field_number the identifier of each question in each form and value is the answer given to each question. I already tried to turn the form's responses into a new table, but when they were edited in wordpress the answers would not be updated. I want my final visualization inside the database in a new table that will be in columns instead of lines, like this:

%pr_e%

I tried several answers here with similar topics, but I can not go very far, always giving error. It is worth remembering that the new table must be dynamic, since the table of the form will grow according to the answers. Could any good soul help? Thank you.

sql

asked by anonymous 14.06.2016 / 22:39

1 answer

How to put two Google Charts on the same page Problem installing SASS

score 2 · Answer 1

I was able to solve this question on the platform in English.

link

In my case I have adapted to the following code

SELECT lead_id, MAX(CASE WHEN field_number =1 THEN value END ) titulo , MAX (CASE WHEN field_number = 2 THEN value END) descricao , MAX (CASE WHEN field_number = 3 THEN value END) movimento , MAX (CASE WHEN field_number = 4 THEN value END) status , MAX (CASE WHEN field_number = 5 THEN value END) lat , MAX (CASE WHEN field_number = 6 THEN value END) long , MAX (CASE WHEN field_number = 7 THEN value END) nome , MAX (CASE WHEN field_number = 8 THEN value END) email FROM or1_rg_lead_detail GROUP BY lead_id