Add conditions to list displayed by Related List Action in Agent Workspace

[Nico8]

Hi,

I've created an "Add" button for a related list in Agent Workspace that display all Locations.

However I need only to display Locations type Country.

How can I achive that?

Thanks.

[Nico8]

In this case, each related list need different conditions.

[anayna]

Hi Maik i have the similar requirement but i want to display the add relation button on few tables only like incident ,case,problem.So how can i achieve this:

my extension point is as follows:

var TaskRelTaskCandidateFilter = Class.create();
TaskRelTaskCandidateFilter.prototype = {
initialize: function(tableName, parentFieldName, parentRecordSysId, referencedFieldName) {
this.tableName = tableName;
this.parentFieldName = parentFieldName;
this.parentRecordSysId = parentRecordSysId;
this.referencedFieldName = referencedFieldName;
},
getFilterQuery: function() {
var selectedRecord = new GlideRecord(this.tableName);
//selectedRecord.addEncodedQuery("this.tableName='incident'^ORthis.tableName='sc_req_item'");
selectedRecord.addQuery(this.parentFieldName, this.parentRecordSysId);
selectedRecord.query();
var result = [];
while (selectedRecord.next()) {
result.push(selectedRecord.getValue(this.referencedFieldName));
}

if (result.length)
return "sys_idNOT IN" + result.join(",");

return "";
},

handles: function(thing){
return thing == "sap_add_relation";
},

type: 'TaskRelTaskCandidateFilter'
};

[SGuha1997]

Hi Maik,
This was indeed very helpful in my use case.
What we want is, certain condition to be default on form load but allow user to update/edit filters later as per need.

In the screenshot you can see the filters are empty so adding new filter just return 'No record' as the filter mentioned in script include is still being applied.

Thanks,
Shubhanshu