Please your help with a system field

[Christian Jaya]

I have a system filed that contein a resume of a jira ticket, i need to capture tha value in a sil validation program 

please can you help me??

is so urgent

thank you so much

that is the screem that i have went a i'm going create a JIRA ticket

what is highlighted in the red circle is the system field whose value I want to capture

[Schuyler Bishop]

Hi Christian, 

Can you be more specific about the sil validation program? What exactly are you trying to do with the resumen (summary) field value? 

Best,

Schuyler

[Christian Jaya]

I need this value to find the ticket en the jira database in a jiraissue table, i will be this with a SQL sentences, is to dificult to explain all the teme jejeje

sil validation allow the you develop a little script whit sql sentences , so i need that field to develop a select based on that parameter

[Christian Jaya]

that is the reason why i need to capture that value

[Christian Jaya]

Schuyler good afternoom 

please can you help with the subjet that i ask you yerterday, is so urgent capture the data on the Resumen system field

pelase help me

[Nic Brough -Adaptavist-]

It is not clear what you are trying to do.  "Capture the data" does not make sense because the field will be filled in by the user and hence "captured".  You can't "find the ticket in the database" because there is no data until after they enter the issue, and at that point it is too late.

[Christian Jaya]

good morning

I explain, once you enter the ticket it is registered in the database, I have a transition called Request Apply, in this I do a validation, at this point I need the data that is saved in the Summary system field or the number of the ticket, but I can not access this data because I do not know how to use the data that was registered in the system fields.

In a field created by the user, simply use the name of the field and access the information that is registered there, but in a system field it is not that way

that's why I ask for your help to understand how I can do what I described to you

[Christian Jaya]

I send you an example of my validation

string usua = userFullName(CTI_Delegador);
string caracter = sql("Prueba_SQL", "select charindex(';', Nombre) from usuarios where Nombre like '%"+usua+"%'");
number local = (number)caracter;

CTI_Delegador, is a user field that was created to delegate an action, in this case I would need to use the system field

[Nic Brough -Adaptavist-]

Ok, I think that has helped.

In a validator, you have direct access to the issue being worked on.  The system fields are directly accessible on that, you should be able to simply use issue.getSummary() for the summary.

[Christian Jaya]

thank you so much

only one more question, the sentence issue.getSummary(), is issue  the name of the transition??

beacuse i use the sentece in a validator and send me and error

issue is not defined

thanks for your help

[Nic Brough -Adaptavist-]

No, issue is the issue, not the validator, and getSummary should give you the content of the summary field on the issue.  The issue should be available in validator code, it really is "the current issue"

[Christian Jaya]

I send you a screenshot with the error, I do not know if it is necessary to import any libraries to use these sentences issue.

Sorry for the inconvenience but it's the only thing I need to deliver a project

[Nic Brough -Adaptavist-]

I am very sorry, I've been thinking about the wrong thing, a bit.  I've been thinking in "Script Runner", rather than SIL.

I don't use SIL, and I only know the basics of it.  I am not sure how or where your validator is running (if it were SR, then that hooks into standard Jira validators, so when you said validator, I assumed it was a transition validator which does have access to the "issue" object".

The principles should be the same, but SIL and the problems you face make me suspect I am looking in the wrong place.  Could you explain where this validator happens?  How do you configure it?