Dynamic Reference Qualifier

keviningleby
Tera Expert

I am trying to create a Dynamic Reference Qualifier and not having much luck.

(Personal development instance - Helsinki latest patch)

The objective is - on a Task Form - e.g. Incident -

select a "Company" value -

and then use a dynamic filter on the "Business Service" search pop-up to restrict choices to only those services that have their company attribute set to the same value.

My Script Include:   (as you can see - I tried various ways to get the company value)

script-include.jpg

My Dynamic Filter

dynamic filter.jpg

My Dictionary entry

dictionary.jpg

I have tried lots of permutations but nothing seems to work

Any clues, hints, tips would be most welcome

Best Regards

Kevin

1 ACCEPTED SOLUTION

Actually.. if you're just trying to filter based on the current company, you don't have to run a lookup script at all.



In your dynamic qualifer, you can just have this one line:


return "company=" + current.company;



When this is the case, I prefer to simplify the whole thing and use an "advanced" reference qualifier instead of dynamic:


javascript:"company=" + current.company



Screen Shot 2017-04-05 at 11.20.24 AM.png


View solution in original post

26 REPLIES 26

Yes


Ahmed Hussein
Tera Contributor

if you need to use dynamic filter you will need to modify the script, make it returns query instead of the sysiDs

it should be like the following 

var query = "sys_idIN" + services.join();
gs.log("queryresult" + query);
return query;