| (One intermediate revision by the same user not shown) | |||
| Line 2: | Line 2: | ||
| project_name = EUProject.name | | project_name = EUProject.name | ||
| project_name_slo = EUProject.name_slo | | project_name_slo = EUProject.name_slo | ||
| − | | org_name = coalesce(EUProject.department,EUProject.producer) | + | | org_name = coalesce(nullif(EUProject.department,''),EUProject.producer) |
| − | | org_name_slo = EUProject.producer_slo | + | | org_name_slo = coalesce(nullif(EUProject.department_slo,''),EUProject.producer_slo) |
| org_status = EUProject.status | | org_status = EUProject.status | ||
| year = EUProject.year | | year = EUProject.year | ||
| Line 9: | Line 9: | ||
| eu_project = EUProject.eu_program | | eu_project = EUProject.eu_program | ||
| role = EUProject.role | | role = EUProject.role | ||
| − | | link = coalesce(EUProject.department_link,EUProject.producer) | + | | link = coalesce(nullif(EUProject.department_link,''),EUProject.producer) |
| project_link = EUProject.url | | project_link = EUProject.url | ||
| ccp_link = EUProject.ccp | | ccp_link = EUProject.ccp | ||
Latest revision as of 22:01, 24 August 2016
[]
