AnsweredAssumed Answered

Displaying count of active attachments in tab

Question asked by andholmes on Mar 15, 2016
Latest reply on Mar 29, 2016 by andholmes

We have implemented a modification to display the attachments tab with a count of the number of attachments so that a person can tell without having to check the attachments tab whether or not there are any attachments to look at.  Below is the modification we've made, and it works great except for one thing.  It includes inactive attachments.

<PDM_MACRO name=tab title="Attachments($args.attachments.length)" height=350 id=attmnt src="OP=SHOW_DETAIL+HTMPL=xx_attmnt_tab.htmpl+FACTORY=cr+PERSID=$args.persistent_id+NO_DP=yes">

attachments is a BREL to the lrel_attachments_requests table.  In the lrel_attachments_requests table is the SREL to attmnt where the delete_flag is located.

Is there a way to do this where we can exclude records where the attmnt value in the delete_flag is 0?