How to configure data certification for the users having multiple asset assigned

[Srinanda1]

How to configure data certification for the users having multiple asset assigned?
What will be the certification filter condition for the data certification schedule to achieve this? Can the condition be scripted? Thanks in advance.

[ronprice]

When you say "users having multiple asset assigned", do you mean to only include a certification if a user has >1 asset assigned to them?

Regarding scripting - there is not currently functionality for scripting filter conditions.

[Srinanda1]

Yes ronprice,  only include a certification if a user has >1 asset assigned to them. Any idia how can be achieved?

[ronprice · Accepted solution]

Other than building your own version of Data Certification, there are a couple ways that I could think to do this, both of which require a little customization.

First, you could add a field to the User record to track a count of assets assigned to that user (sys_user.u_asset_count).  You would then either need some business rules or a scheduled job to maintain that count.  Then you could set up your filter on the asset table and dot-walk to the user record to check that the sys_user.u_asset_countis >1.  This is probably the cleanest method.

Alternatively, you could create a custom table that is linked to the asset table and have a scheduled job that runs before your Certification and it would ONLY create a record in the custom table when a user has more than 1 asset assigned to them.  But it would create a record in the custom table for every asset that the user had assigned to them when this condition is true.  The table would have a reference to the asset and you could then use the custom table as the filter source, with dot-walking to get to the asset fields that you want to have displayed and certified.