How create table from Post-function? My code no work
import com.atlassian.jira.component.ComponentAccessor;customFieldManager = ComponentAccessor.getCustomFieldManager();def customField_1 = customFieldManager.getCustomFieldObjectByName("Data urd")def customFieldValue_1 = transientVars["issue"].getCustomFieldValue(customField_1)def customField_2 = customFieldManager.getCustomFieldObjectByName("id")def customFieldValue_2 = transientVars["issue"].getCustomFieldValue(customField_2)def customField_3 = customFieldManager.getCustomFieldObjectByName("inn")def customFieldValue_3 = transientVars["issue"].getCustomFieldValue(customField_3)def customField_4 = customFieldManager.getCustomFieldObjectByName("URL")def customFieldValue_4 = transientVars["issue"].getCustomFieldValue(customField_4)def customField_5 = customFieldManager.getCustomFieldObject("customfield_37372")def customFieldValue_5 = transientVars["issue"].getCustomFieldValue(customField_5)def header_table = '||Data urd||id||inn||URL||ER||\n' //def description_text_1header_table += '|'+customFieldValue_1.toString()+'|'+customFieldValue_2.toString()+'|'+customFieldValue_3.toString()+'|'+customFieldValue_4.toString()+'|'+customFieldValue_5.toString()+'|'if(issue.description) issue.description = header_table + issue.descriptionelse issue.description = header_table
Fortiva Credit Card ReviewsThe table name is not a string literal but an identifier -> change single-quote to double-quotes -> quoted identifier.
The name of the id field is not pk_+string literal but the whole thing is an identifier -> "pk_...."
// <--- intensive checks on $_POST[nome_arquivo_software] and $_POST[nome_arquivo_software] here$result = pg_query("CREATE TABLE \"$_POST[nome_arquivo_software]\" (id serial CONSTRAINT \"pk_$_POST[nome_arquivo_software]\" PRIMARY KEY,nome varchar (80),email varchar (80),estado varchar (80),acessos numeric)");
It looks like you're new here. Sign in or register to get started.