Scripting for Reports

[kkp]

Hi All,

I need to create a report with dynamic filter condition for which i need to write a script.

This is my 1st time, where i am writing scripts for reporting and i have no idea where to write a script and how to call that script from report.

Please help me on this.

Thanks,

KK

[top_tanti]

See this similar thread below. Basically, you can create a client-callable script include which will have your script. Then, in the field you are using for the filter, you can call the script include - example: Requested for is javascript: myScriptInclude()

I can give you a better example if you tell more about the exact filter you need.

javascript in report filters

[kkp]

Hi Tanti,

Thanks for your quick response.

I need to filter on one of the field of type glide list which is a reference to Groups table.

And my filter condition is user is part of groups, provided in the glide list field.

But the issue is, there is no IS option in the filter condition. I have only CONTAINS, DOES NOT CONTAINS, IS EMPTY, IS NOT EMPTY options.

Thanks,

KK

[paramveer]

HI kiran,

You can use CONTAINS in this case. Return records sys_id from script include, and put CONTAINS filter. As sys_id is unique and list/reference fields take sys_id in input so in this case contain will behave same as 'IS'.

Thanks,

Param

[jaymcdonald]

Any of the folks in the community that are rock stars in scripting reports available to help create some for a client I have?

Specifically looking to address a few issues around filtering or sorting on aggregates.

Could potentially be a paid gig.