Using script in widget filter

[JJG]

Hello,

I have a service portal page with a 'data table from instance definition' widget. It displays records from my 'hours logged' table. I need to use a script to filter the records that it shows, however, I am getting a strange result.

Filter Script:

javascript:var name = name_of_employee;
var date = date;
var getStart = new GlideRecord('x_utsll_time_manag_time_management');
getStart.addQuery('name_of_employee', name);
getStart.query();
if(getStart.next()){
var start = getStart.pay_period_start
};
date > start; //Only records that are after the getStart.pay_period_start date should be shown
name_of_employee=javascript:gs.getUserDisplayName(); //Only records that match the currently logged in user name

RESULT:

[Indrajit]

Hey JJG,

I think the filter in widget that you are showing is not for scripting purpose these are for the encoded query like active=true. so try encode query to fulfill your displays records from 'hours logged' table.

Mark Correct and Helpful if it useful.

Regards,

Indrajit.