question how to find if a script contains sub string in ITSM forum

how to find if a script contains sub string

learnSN — Sun, 29 Nov 2020 07:54:32 GMT

if we have two sub strings in string (GlideRecord ,Alert), how check the two sub strings

please write a program to check whether a string contains sub string

Re: how to find if a script contains sub string

Mark Roethof — Sun, 29 Nov 2020 08:30:22 GMT

Hi there,

Not sure what you exactly mean. Can you give an example?

Something like below might work.

if(your_string.indexOf(other_string) != -1) {
    ...
}

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list

Re: how to find if a script contains sub string

Hitoshi Ozawa — Sun, 29 Nov 2020 09:01:29 GMT

Not sure of the question.

Following code will find all records in Alerts table (em_event) that has a particular string.

var stringToSearch = '<string to search>';

var grAlert = new GlideRecord('em_event');
grAlert.addEncodedQuery('<query string>');
grAlert.query();
while (grAlert.next()) {
  gs.info(grAlert.sys_id);
}

Query string can be obtained by opening Alert table and setting filter conditions and running it. Right click on the filter breadcrumb and select "Copy query". Paste the query to the script above. "contains" filter can be used to find occurrence of a string in field.

Re: how to find if a script contains sub string

learnSN — Sun, 29 Nov 2020 13:29:19 GMT

hi expert!

How to check if a string contains sub string

Re: how to find if a script contains sub string

Ankur Bawiskar — Sun, 29 Nov 2020 13:38:52 GMT

@naresh

if you are referring to searching for substring in some field of your table when you are doing GlideRecord then it should be like this

var gr = new GlideRecord('incident');

gr.addQuery('short_description', 'CONTAINS', 'test');

gr.query();

var count = gr.getRowCount();

gs.info(count);

Regards
Ankur

Re: how to find if a script contains sub string

learnSN — Sun, 29 Nov 2020 14:03:51 GMT

Hello Ankur,

if i would say according to the recommendations using GlideRecord and alerts function in the client script is not best practices, so if it in case any client record contains both the above(gliderecord and alerts function)records it should show the like violation on custom UI Page(named it as 'show violation in my update set') table in that that case we consider gliderecord is one sub string and alert function is another sub string.we call them from separate 'upate set best practice' table.

so my question is how to write a script(in script include) to show them in violation table with their respective information.

Re: how to find if a script contains sub string

Ankur Bawiskar — Sun, 29 Nov 2020 14:10:56 GMT

Hi,

so you want to check

1) if client script contains alert or GlideRecord and add to your custom table with the type and the name of the script which contains that

try this sample script include functions which you can call

GlideRecord checking

checkClientScriptForGlideRecord: function(){

var rec = new GlideRecord('sys_script_client');

rec.addEncodedQuery('sys_class_name=sys_script_client^scriptLIKEnew GlideRecord(');

rec.query();

while(rec.next()){

var customRec = new GlideRecord('your custom table');

customRec.initialize();

customRec.u_type = 'Client Script';

customRec.u_substring = 'GlideRecord(';

customRec.u_name = rec.name;

customRec.insert();

}

},

Alert checking

checkClientScriptForGlideRecord: function(){

var rec = new GlideRecord('sys_script_client');

rec.addEncodedQuery('sys_class_name=sys_script_client^scriptLIKEalert(');

rec.query();

while(rec.next()){

var customRec = new GlideRecord('your custom table');

customRec.initialize();

customRec.u_type = 'Client Script';

customRec.u_substring = 'alert(';

customRec.u_name = rec.name;

customRec.insert();

}

},

Regards
Ankur

Re: how to find if a script contains sub string

learnSN — Sun, 29 Nov 2020 14:47:00 GMT

Hello there!

i have tried this with script include ,result is it is showing the violations with their respective sys_id also but here is the problem is alerts function table have different description and recommendation and GlideRecord have different too but both records contains GlideRecord description and recommendation.

please find the attachment so that you can

> first sys id contains alerts function

> last two sys id's contains Gliderecords

NOTE: please make sure code should be in dynamic way

thank you

Re: how to find if a script contains sub string

Ankur Bawiskar — Sun, 29 Nov 2020 15:50:38 GMT

Hi Naresh,

I believe the script which was required as per your question has been shared.

You will have to enhance it as per your requirement.

Regards
Ankur

Re: how to find if a script contains sub string

Ankur Bawiskar — Mon, 30 Nov 2020 05:05:49 GMT

Hi Naresh,

Any update on this thread?

Regards
Ankur