nofc_fro
Member
Hi,
I have a few cases to ask, forgive me
CASE 1. Database join in "ccc" list
I have this situation:
Two tables called "aaa" and "bbb".
The "aaa" table has two elements: id, name (e.g. 100, frank)
The "bbb" table has three elements: id, aaa_id, surname (e.g. 201.100, smith)
I create a new "ccc" list that has two elements: id,namesurname(database join)
I would like to have this result: 999,frank smith
If I create an Element with Plug-in "Databasejoin" I go to the tabs "Data", I select the table "aaa", Value "id" and in "Concat label" what should I do?
CASE 2. Database join in "bbb" list
I have a similar situation:
Two tables called "aaa" and "bbb".
The "aaa" table has two elements: id, league,num (e.g. 100, nhl, 326)
The "bbb" table has three elements: id, month_id, name_month (e.g. 200, 326, april)
I would like to create a new "database join" element in the "aaa" table that gives me the name of the month
How can I do?
CASE 3. One to many
This is the most difficult case.
I have this situation:
Two tables called "aaa" and "bbb".
The "aaa" table has two elements: id, company (e.g. 100, corporationxxx)
The "bbb" table has three elements: id, company_id, attribute_id, value. BUT I have more records with aaa_id. E.g.->
"aaa" table
100,corporationxxx
200,corporationyyy
"bbb" table
1,100,10,sun
2,100,11,happy
3,100,12,sing
4,200,10,snow
5,200,11,sad
6,200,12,silence
I would like to create a new "database join" elements in the "aaa" table that gives me the list of values:
NEW "aaa" table 100,corporationxxx,sun,happy,sing
How can I do?
I have a few cases to ask, forgive me
CASE 1. Database join in "ccc" list
I have this situation:
Two tables called "aaa" and "bbb".
The "aaa" table has two elements: id, name (e.g. 100, frank)
The "bbb" table has three elements: id, aaa_id, surname (e.g. 201.100, smith)
I create a new "ccc" list that has two elements: id,namesurname(database join)
I would like to have this result: 999,frank smith
If I create an Element with Plug-in "Databasejoin" I go to the tabs "Data", I select the table "aaa", Value "id" and in "Concat label" what should I do?
CASE 2. Database join in "bbb" list
I have a similar situation:
Two tables called "aaa" and "bbb".
The "aaa" table has two elements: id, league,num (e.g. 100, nhl, 326)
The "bbb" table has three elements: id, month_id, name_month (e.g. 200, 326, april)
I would like to create a new "database join" element in the "aaa" table that gives me the name of the month
How can I do?
CASE 3. One to many
This is the most difficult case.
I have this situation:
Two tables called "aaa" and "bbb".
The "aaa" table has two elements: id, company (e.g. 100, corporationxxx)
The "bbb" table has three elements: id, company_id, attribute_id, value. BUT I have more records with aaa_id. E.g.->
"aaa" table
100,corporationxxx
200,corporationyyy
"bbb" table
1,100,10,sun
2,100,11,happy
3,100,12,sing
4,200,10,snow
5,200,11,sad
6,200,12,silence
I would like to create a new "database join" elements in the "aaa" table that gives me the list of values:
NEW "aaa" table 100,corporationxxx,sun,happy,sing
How can I do?