SIL Datasource: How can I make reference to the "screen" value when creating an issue?

[Begoña Bonet]

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?

[Alexandra Topoloaga · Accepted solution]

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 

[Begoña Bonet]

I've added the results in log. Do you find any clue?

[Alexandra Topoloaga]

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. 

[Begoña Bonet]

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.

[Alexandra Topoloaga]

Yes, this should work. Good luck!

[Begoña Bonet]

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?

[Alexandra Topoloaga]

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? 

[Begoña Bonet]

Sorry! It was my fault!

I'll need to incluye TRANS customfield as Dependent customfileld and now it works!!

[Alexandra Topoloaga]

Great 

[Begoña Bonet]

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 =