Sharing the report and the records as per their individual assignment group

[Sanket Choughul]

Hi Community,

I have a requirement were I need to share the retired assets record's report with the assignment group they are tagged to. And I have to used scheduled report and scheduled job for the same. The challenge is that end user should only see the reports of the records that are in his assignment group. I am unable to understand how I am going to pass the value from scheduled job to scheduled report for dynamic assignment group. For example-

If there are 50 retired assets, out of which 20 are assigned to 'XYZ' group and 30 are assigned to 'ABC' group. Only one report should be called and this report shall only show the records of their assignment group. Currently I am calling this report through scheduled report and passing the value of assignment groups through scheduled job/script but it is showing all the 50 records to both the groups.

Is there any encoded query which I can use on my scheduled job?

[Ankur Bawiskar]

@Sanket Choughul 

why not do this?

1) when you run scheduled job at that time you update the report condition dynamically and scheduled report will pick records as per that

2) update the report filter condition by keeping a sleep of 15-20seconds so that in that time frame the 1st report is sent out and then the report filter condition gets updated

[Sanket Choughul]

Is that doable? How can we update report condition through script? My report is in custom application table.

Can u give one example