question Filter condition for a module with javascript? in Developer forum

Filter condition for a module with javascript?

regizzle — Tue, 24 Mar 2015 21:35:08 GMT

So, i know its very possible to use a javascript: bit of code within a filter however, I am facing an issue.

I am trying to use:

javascript:gs.getUserID().getRecord().getValue('u_site')

Where u_site is a reference to core_company.

so its: Site is javascript:gs.getUserID().getRecord().getValue('u_site')

However, when i go and actually click the module it returns (empty), yet, when I do a test via business rule returning a gs.addInfoMessage, it returns the sys id properly.

Where am i going wrong?

Thanks,

Roland

Re: Filter condition for a module with javascript?

manikorada — Tue, 24 Mar 2015 22:03:20 GMT

Roland,

Try something like this:

1) Have a script include like:

Name : getMyFilter()

Client Callable : true

Script:

return gs.getUserID().getRecord().getValue('u_site');

2) Have the filter as javascript:getMyFilter()

Re: Filter condition for a module with javascript?

regizzle — Tue, 24 Mar 2015 22:38:05 GMT

Hey Mani,

It gives me an Invalid Return.

I'm pretty sure my script is incomplete if all I put is :

return gs.getUserID().getRecord().getValue('u_site');

Re: Filter condition for a module with javascript?

ahaz86 — Wed, 25 Mar 2015 00:43:12 GMT

did you try:

gs.getUser().getRecord().getValue('u_site')

Re: Filter condition for a module with javascript?

ahmeid — Wed, 25 Mar 2015 12:13:38 GMT

Hi Roland,

What are you actually trying to do?

Re: Filter condition for a module with javascript?

regizzle — Wed, 25 Mar 2015 14:10:45 GMT

I did, no marbles.

Re: Filter condition for a module with javascript?

regizzle — Wed, 25 Mar 2015 14:15:00 GMT

I am trying to make a filter on a module return users or assets that are assigned to the same company as the user loading the list.

In other words:

Site (which is company) is javascript:gs.getUser().getRecord().getValue('u_site')

however i get site = (empty)

when i put it in a script include i cannot save the script include because it is as follows:

function getMySite()
{

return gs.getUser().getRecord().getValue('u_site');

}

and that is invalid for the script include so it seems, that or it returns the same "(empty)"

Re: Filter condition for a module with javascript?

regizzle — Wed, 25 Mar 2015 18:50:23 GMT

tested and tested again, still no dice. I cannot understand what I am missing. Perhaps a problems with an ACL?
however i do not think so.

Re: Filter condition for a module with javascript?

regizzle — Thu, 26 Mar 2015 15:52:35 GMT

So this began to work, all of a sudden. which is odd. However, now i have a second issue. I am trying to create a script include to provide some security to the instance and seperation to departments, however, when i try to get the value of a reference field that links the user back to their department, its returning nothing. Blank.

I created a business rule to call the script include, yet, it is returning nothing in the gs.addInfoMessage. Am I going wrong somewhere? The field it is calling is from a user created table, perhaps something is not right with the table? any and all help would be greatly appreciated.

Re: Filter condition for a module with javascript?

regizzle — Thu, 26 Mar 2015 15:59:22 GMT

and now it is working, i am completely dumbfounded by this, is this a cache related problem?

Re: Filter condition for a module with javascript?

manikorada — Thu, 26 Mar 2015 16:00:11 GMT

Roland,

This might be caching issue. sometimes in the Dev environment you might need to do cache flush to get the results.

Re: Filter condition for a module with javascript?

ahaz86 — Thu, 26 Mar 2015 16:11:32 GMT

try running a cache.do (during non peak hours or when its a good time for the instance to possibly be down for a few minutes)

Re: Filter condition for a module with javascript?

regizzle — Thu, 26 Mar 2015 16:20:21 GMT

Thanks for the command!

Will it always go down or is that a its gonna be so slow its down type of "go down"?

Re: Filter condition for a module with javascript?

ahaz86 — Thu, 26 Mar 2015 16:22:46 GMT

will not always go down, but may cause degradation of service