How to find the list of records whose character length has exceeded 80 from question choice table

[Suvetha S]

Hi All,

We have to fetch the list of records from the question_choice table whose length exceeded 80. Please help with the fix script

[Saurav11 · Accepted solution]

Hello

Please use the below script

var inc = new GlideRecord('question_chooce');

inc.query();

while(inc.next()){

  if(inc.replacethefieldnamewhichyouwanttocompare.toString().length > 80){

    gs.print(inc.sys_id);

}

}

Please mark answer my answer as correct based on impact 

[Saurav11 · Accepted solution]

Hello

Please use the below script

var inc = new GlideRecord('question_chooce');

inc.query();

while(inc.next()){

  if(inc.replacethefieldnamewhichyouwanttocompare.toString().length > 80){

    gs.print(inc.sys_id);

}

}

Please mark answer my answer as correct based on impact 

[Pavankumar_1 · Accepted solution]

Hi @Suvetha S ,

Try below script

var grch = new GlideRecord('question_choice');
grch.query();
while(grch.next()){
  if(grch.text.toString().length > 80){
    gs.info(grch.sys_id);
}
}

[Suvetha S]

Thank you both