I have created a database view (between attachment & incident table)

[utsavjaiswa]

Hello Everyone, I have created a database view between attachment & incident table..with clause as:-

incident_sys_id=attachment_table_sys_id

By this clause it is working as expected.But suppose if a incident record is having 5 attachments then it is showing same 5 records differently..I want to make it a single to reduce the duplication.

Is there any way??

Warm Regards

Utsav

[Brad Bowman]

Database Views are limited in the where clause, but this is not even conceptually possible as you would be mis-representing the data in the two tables.  The only other avenue that I'm thinking of is to use a string field on the (case) table, populated with a comma or newline separated list of all of the attachment file names, then you would only need a list view or report on the case table, if that's what you want to see.  You would use a Fix Script to initially populate this new or un-used/re-purposed string field, then a Business Rule to keep it in sync as attachments are added and deleted.

[RaghavSh]

@utsavjaiswa There are somethings which has to be handled as part of training and user education. On your database view the users should be trained to use a group by case number. 

Doing additional coding will only complicate the system. Database view is working fine and should solve your purpose, its just the user education and training.