Concatenate Strings

Question

Good Mornig

i need a little help, I have a table grid editor with 3 columns, the 1 and 2 columns contains data from extracted to a data base, the column 3 es the result of concatenate the second column with a text like "PRY_2017", can you help me,

In the jira page, i find the concat sentece , but i don't totaly undestand how to use then

I hope you can help me, thank you so much

Christian Jaya · Answer

Hi Francis

excuse me for my persistence, I need your help with the sentence concat, I'm still waiting for your answer, I send you the configuration of my table grid

thank you very much

Christian Jaya · Answer

Hi Francis

thanks for your answer

I send you a configuration of my table grid, please help me with this teme

######################################
# Definición de Columnas

gd.columns = iProyecto, iLider, iCodigo
gd.tablename = Fso_prueba
gd.ds = jira

######################################
# Definición iProyecto

col.iProyecto = Nombre de Proyecto
col.iProyecto.type = list
col.iProyecto.query = select Proy_nom, Proy_id, Lider_id from [UsuarioWorkFlow].[dbo].[Proyectos] order by Lider_id
col.iProyecto.query.ds = Usua_SQL
col.iProyecto.autocomplete = true
col.iProyecto.width = 60

########################################
# Definición iLider

col.iLider = Lider Proyecto
col.iLider.type = string
col.iLider.formula = queries:value('Usua_SQL','select Lider_nom from [UsuarioWorkFlow].[dbo].[Lideres]Lideres where Lider_id = ' + {iProyecto.lider_id})

########################################
# Definición de iCodigo

col.iCodigo = Codigo Proyecto
col.iCodigo.type = string
col.iCodigo.formula = {issue:i.Proyecto.concat('PRY_2018')}
col.iCodigo.width = 80

The iCodigo column must have a concatenate string formed by iProyect column plus "PRY-#"

Stay tuned to your answer

francis · Answer

Hi Christian,

Could you provide your grid configuration (or send it to support.tge@idalko.com)

We'll be able to help you further

Francis