Unable to create Interactive filter on Task_sla, unable to do Dot-Walking 'L1 Unit' field.

[chanikya]

Hi All,
I want to filter the TASK SLA report data in Dashboard  record based on  CSM Task record 'L1 Unit ' field( dropdown)

PROBLEM:
While creating Interactive Filter Reference on 'Task_sla' , I'm not able to select "L1 Unit" field from Dot-walkin as Task.Task.L1 Unit . but same thing I am able to do in report , added as row.  if that is getting possible add 'L1 Unit' field in Task_SLA report then why not in 'Task_Sla' interactive filter.

Kindly help me on this issue , how can I fix this one, how to create Interactive Filter on TASK_SLA and do dot-walking 


CSM TASK Record :

Dashboard :


CREATED REPORT ON "TASK_SLA" table, showing data as per CSM TASK "L1 Unit".



Now I want to create interactive filter and populated data in Dashboard report which I selected in Interactive filters.




PROBLEM:
While creating Interactive Filter Reference on 'Task_sla' , I'm not able to select "L1 Unit" field from Dot-walkin as Task.Task.L1 Unit . but same thing I am able to do in report , added as row.  if that is getting possible add 'L1 Unit' field in Task_SLA report then why not in 'Task_Sla' interactive filter.

[lauri457]

You can just insert the reference record with a script, note the ref_ in front of the child table name

var a = new GlideRecord("sys_ui_hp_reference");
a.setValue("publisher_reference", "d069a8608313f610557ff0d6feaad39c")
a.setValue("reference_table", "task_sla")
a.setValue("reference_field", "task.ref_sn_customerservice_case.account")
a.setWorkflow(false)
a.insert()

[chanikya]

Hi @lauri457 ,
Thanks for your reply ,

Kindly help me where do I write this code in interactive filters?

I have inserted from background script:


Should I take  "task.ref_sn_customerservice_task.u_l1_unit" or  "task.ref_task.u_l1_unit");

which is right ?

var a = new GlideRecord("sys_ui_hp_reference");

a.setValue("publisher_reference", "b478fb1893d332101a1bf6fa3d03d671");

a.setValue("reference_table", "task_sla");

a.setValue("reference_field", "task.ref_sn_customerservice_task.u_l1_unit");

a.setWorkflow(false);

a.insert();

[lauri457]

Yes as bg script

[chanikya]

ACD has data, but after selecting it report not giving any data.

So Should I take  "task.ref_sn_customerservice_task.u_l1_unit" or  "task.ref_task.u_l1_unit");

which is right please ?

var a = new GlideRecord("sys_ui_hp_reference");

a.setValue("publisher_reference", "b478fb1893d332101a1bf6fa3d03d671");

a.setValue("reference_table", "task_sla");

a.setValue("reference_field", "task.ref_sn_customerservice_task.u_l1_unit");

a.setWorkflow(false);

a.insert();