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

utsavjaiswa
Mega Contributor

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

6 REPLIES 6

@utsavjaiswa 

 

Did you get a chance to review this ?

 

If my response helped to answer your query, please mark it helpful & accept the solution.

 

Thanks,

Bhuvan

@utsavjaiswa 

 

Thanks for marking the post as helpful.

 

Please review and if my response helped to guide you or answer your query, please accept the solution.

 

Thanks,

Bhuvan