I have a KCF Single Autocomplete customfield. This customfield appears in Create screen and in transition1 screen. This customfield has a Datasource SIL script associated.
I need to launch a different sql in "create" transition and than in "transition1" transition.
The problem is that argv["screen"] returns "" in both cases and I don't know how specify in the datasource sil script this case.
I thought to do something like that:
query += "SELECT c.servicio"; if (argv["screen"]=="create"){ query += " from vmmet_catalogoactivo c, vmmet_grupos g"; query += " where c.issue_id=g.issue_id and"; } else { query += " FROM vmmet_catalogoactivo c"; query += " WHERE "; } query += " c.proy_key='"+proyecto+"'";
But argv["screen"] returns always null.
Anyone knows how can I do this?
Hi Begoña,
As long as you have JJUPIN installed & enabled, argv["screen"] should always return the right values (view/create/edit/trans_x).
Have you tried to set the log level on DEBUG and check why is the value of the screen coming wrong?
Best Regards,
Alexandra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I've seen your comment. My bad, I forgot that you're not using this via Live Fieds, but via KCF Pro.
That's why it doesn't work: KCF Pro only knows how to get the values for the dependent fields.
Unfortunately, I think that at the moment there's no way to get the screen value on a datasource.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ok Alexandra, then I'll use a customfield to charge on it an specific value depending on the transition and then I'll define it as dependen field for the KCF. It's a trick but I think it'll work.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, this should work. Good luck!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It doesn't work........
I can see the customfield with value on the screen but the argv returns "" also......
My code:
In Main script:
if (arrayElementExists(transCAMBIAR_GRUPO_SOPORTE, pantalla)) { lfInstantHook({"project"}, "/datos_apl/jira/silprograms/proyectos_soporte/transiciones/trans_cambiarGrupoSoporte/cargaInicial_trans_cambiarGrupoSoporte.sil"); }
In cargaInicial_trans_cambiarGrupoSoporte.sil:
lfSet("cf_TRANS","CGS");
In datasource:
string transicion=argv["customfield_25800"]; //TRANS customfield string[] resultado; string query=""; string tipos_de_grupos=""; string id_servicio_issue = #{SERVICIO_ISSUE}; if (transicion=="CSC"){ tipos_de_grupos="'A','EI','EESS'"; } if (transicion=="CGS"){ tipos_de_grupos="'EI','EESS'"; } if (transicion=="ECS"){ tipos_de_grupos="'EECS'"; } query += " Select distinct grupo "; query += " From vmmet_grupos"; query += " Where issue_id="+id_servicio_issue; query += " and tipo_grupo in ("+tipos_de_grupos+")"; query += " and proy_key='"+proyecto+"'"; resultado = sql("JiraDB",query); return resultado;
And the result in log:
2016-06-17 14:28:40,380 http-bio-8080-exec-16 ERROR bonet_beg 868x37797x1 2m6kma 10.178.169.22,10.178.169.22,172.27.146.22 /rest/keplerrominfo/kcf-pro/latest/optionscf/autocomplete [sil.lang.routines.SQLRoutine] Could not execute SQL >>Select distinct grupo From vmmet_grupos Where issue_id=224256 and tipo_grupo in () and proy_key='SIP'<< on database JiraDB.
Any idea?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The KCF PRO is with autocomplete, isn't it?
Have you added the new field as a dependent one? Is the new field a simple text field?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry! It was my fault!
I'll need to incluye TRANS customfield as Dependent customfileld and now it works!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Great
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I've included the "logprint" clause in the code:
logPrint("DEBUG", "THE SCREEN IS = " + argv["screen"]); query += "SELECT c.servicio"; if (argv["screen"]=="create"){ query += " from vmmet_catalogoactivo c, vmmet_grupos g"; query += " where c.issue_id=g.issue_id and"; } else { query += " FROM vmmet_catalogoactivo c"; query += " WHERE "; } query += " c.proy_key='"+proyecto+"'";
And in log file this is the result:
2016-06-15 08:53:54,575 http-bio-8080-exec-6 DEBUG bonet_beg 533x7848x1 19h66wp 10.178.169.22,10.178.169.22,172.27.146.22 /rest/keplerrominfo/kcf-pro/latest/optionscf/autocomplete [sil.lang.grammar.ASTBinaryOpNode] Interpreting PLUS node >>argv<<, line : 39, column 40 2016-06-15 08:53:54,575 http-bio-8080-exec-6 DEBUG bonet_beg 533x7848x1 19h66wp 10.178.169.22,10.178.169.22,172.27.146.22 /rest/keplerrominfo/kcf-pro/latest/optionscf/autocomplete [sil.lang.grammar.ASTValueNode] Interpreting VALUE node >>THE SCREEN IS = <<, line : 39, column 19 2016-06-15 08:53:54,575 http-bio-8080-exec-6 DEBUG bonet_beg 533x7848x1 19h66wp 10.178.169.22,10.178.169.22,172.27.146.22 /rest/keplerrominfo/kcf-pro/latest/optionscf/autocomplete [sil.lang.grammar.ASTValueNode] Interpreting VALUE node >>screen<<, line : 39, column 45 2016-06-15 08:53:54,576 http-bio-8080-exec-6 DEBUG bonet_beg 533x7848x1 19h66wp 10.178.169.22,10.178.169.22,172.27.146.22 /rest/keplerrominfo/kcf-pro/latest/optionscf/autocomplete [sil.lang.grammar.ASTFieldNode] Getting variable named : 'argv'. 2016-06-15 08:53:54,576 http-bio-8080-exec-6 DEBUG bonet_beg 533x7848x1 19h66wp 10.178.169.22,10.178.169.22,172.27.146.22 /rest/keplerrominfo/kcf-pro/latest/optionscf/autocomplete [jira.commons.ivm.IssueVariableResolver] Issue variable resolver: Retrieving variable >>argv<< 2016-06-15 08:53:54,576 http-bio-8080-exec-6 DEBUG bonet_beg 533x7848x1 19h66wp 10.178.169.22,10.178.169.22,172.27.146.22 /rest/keplerrominfo/kcf-pro/latest/optionscf/autocomplete [keplerrominfo.sil.lang.VariableResolver] Found variable in context [0] 2016-06-15 08:53:54,576 http-bio-8080-exec-6 DEBUG bonet_beg 533x7848x1 19h66wp 10.178.169.22,10.178.169.22,172.27.146.22 /rest/keplerrominfo/kcf-pro/latest/optionscf/autocomplete [keplerrominfo.sil.lang.VariableResolver] Attempting to retrieve variable >>argv<<, com.keplerrominfo.jira.commons.ivm.DefaultIssueVariableResolver, context[0] 2016-06-15 08:53:54,576 http-bio-8080-exec-6 DEBUG bonet_beg 533x7848x1 19h66wp 10.178.169.22,10.178.169.22,172.27.146.22 /rest/keplerrominfo/kcf-pro/latest/optionscf/autocomplete [keplerrominfo.sil.lang.VariableResolver] Found variable in context [0] 2016-06-15 08:53:54,576 http-bio-8080-exec-6 DEBUG bonet_beg 533x7848x1 19h66wp 10.178.169.22,10.178.169.22,172.27.146.22 /rest/keplerrominfo/kcf-pro/latest/optionscf/autocomplete [keplerrominfo.sil.lang.VariableResolver] Current value is: [STRING[]] {, , , , , , , , , , , , , , , , , , , , , #keys: customfield_23701->0, customfield_24900->21, customfield_24901->20, customfield_23703->3, customfield_20001->18, customfield_17300->4, customfield_22110->15, query->5, customfield_17700->17, description->1, project->2, customfield_19116->13, customfield_19117->14, customfield_14214->12, customfield_13205->19, cf_SeleccionarCiAfectadoSW->10, customdield_22904->6, customfield_14703->16, customfield_20806->11, customfield_20901->9, customfield_20900->8, customfield_21500->7} 2016-06-15 08:53:54,576 http-bio-8080-exec-6 DEBUG bonet_beg 533x7848x1 19h66wp 10.178.169.22,10.178.169.22,172.27.146.22 /rest/keplerrominfo/kcf-pro/latest/optionscf/autocomplete [jira.commons.ivm.IssueVariableResolver] Issue variable resolver: >>argv<< is already defined or even used as >>argv<< 2016-06-15 08:53:54,576 http-bio-8080-exec-6 DEBUG bonet_beg 533x7848x1 19h66wp 10.178.169.22,10.178.169.22,172.27.146.22 /rest/keplerrominfo/kcf-pro/latest/optionscf/autocomplete [sil.lang.grammar.ASTCallNode] Interpreting CALL node >>logPrint<<, line : 39, column 1 2016-06-15 08:53:54,576 http-bio-8080-exec-6 DEBUG bonet_beg 533x7848x1 19h66wp 10.178.169.22,10.178.169.22,172.27.146.22 /rest/keplerrominfo/kcf-pro/latest/optionscf/autocomplete [sil.lang.grammar.ASTCallNode] CALL >>logPrint<<, parameter list size = 2 2016-06-15 08:53:54,576 http-bio-8080-exec-6 DEBUG bonet_beg 533x7848x1 19h66wp 10.178.169.22,10.178.169.22,172.27.146.22 /rest/keplerrominfo/kcf-pro/latest/optionscf/autocomplete [sil.lang.routines.LogPrintRoutine] THE SCREEN IS =
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.