- 3,728,131 Users
- 2,245,555 Discussions
- 7,853,351 Comments
- 17.8K All Categories
- Industry Applications
- 3.2K Intelligent Advisor
- 1.7K On-Premises Infrastructure
- 594 Analytics Software
- 51 Application Development Software
- 1.8K Cloud Platform
- 700.5K Database Software
- 17.5K Enterprise Manager
- 22 Hardware
- 276 Infrastructure Software
- 142 Integration
- 75 Security Software
How to filter the entity collect incidents
I have a model that will allow users to load data from a custom object that is a child of an existing incident. I want to give the user the ability to add new records to the custom object so I'm using the entity collect control.
This custom object will contain a long history of records for the customer. I only want to show the customer a subset of the records. But unlike the entity container control, there is no filter capability on the entity collect control. I do this frequently, so having the ability to filter existing instances from within an entity collect control is pretty important. How do I do this?
For example, for a grant applicant, they may have applied for several projects to be funded, but we did not award some of them. When they load the grant application into the closeout report model from OSvC, I want to filter out the projects that were not awarded and only let them submit dollars spent for the awarded projects.
I can lock them out of the not awarded instances easily enough, but they will still see them, they will not be in any sorted order, and they will clutter up the screen with unneeded information. They may have dozens of entries from budget change requests over the life of the grant and I only want to show them the current budget items to add the monies spent. I can't use an ad hoc query for this because that entity wouldn't be allowed to map out to OSvC. I can't use a regular entity container because the user can't add new records.
Is there an approach that will allow me to show them only the approved budget line items for the grant, add new line items, and save it all back to the existing incident records?