nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

What's new today report shows attachments in a workflow

Steven_Knight_(EllaNUser1_(Delete)_2275084)

I have a "Employee Referral" workflow, which is manager by the recruiting group. Any user who runs the "What's new" reports, can see the attachments in workflows as a result of this LiveReport.Any ideas on how to stop this?

Find more posts tagged with

Comments

eLink User

Message from Xu Moua via eLinkYou can modify the Livelink report to exclude workflow attachments. Modifythe SQL in the "What's New Today" LiveReport to the SQL shown below:select * from DTree where (CreateDate>%1) and %2 and subtype != 154 order byCreateDate descXuProduct Specialist-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: July 13, 2000 3:26 PMTo: eLink RecipientSubject: What's new today report shows attachments in a workflowWhat's new today report shows attachments in a workflowPosted by EllaNUser1 on 07/13/2000 03:22 PMI have a "Employee Referral" workflow, which is manager by the recruitinggroup. Any user who runs the "What's new" reports, can see the attachmentsin workflows as a result of this LiveReport.Any ideas on how to stop this?[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

Steven_Knight_(EllaNUser1_(Delete)_2275084)

Was that SQL for SQL Server or Oracle?I'm using Oracle, and the results looked exactly the same.

eLink User

Message from Xu Moua via eLinkIt should not matter what type of database since it is standard SQL.Workflow attachments have subtype of 154. The new SQL statement imposed acondition of:"and subtype != 154"which should not return workflow attachments. Unless the attachments arealiases and folders containing documents, in which case you can modify theSQL to the following:select * from DTree where (CreateDate>%1) and %2 and parentid not in (selectdataid from dtree where subtype = 154) and subtype != 154 order byCreateDate descLet me know if that helped.Xu-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: July 14, 2000 11:32 AMTo: eLink RecipientSubject: RE- RE- What's new today report shows attachments in a workflowRE- RE- What's new today report shows attachments in a workflowPosted by EllaNUser1 on 07/14/2000 11:28 AMWas that SQL for SQL Server or Oracle?I'm using Oracle, and the results looked exactly the same.[To reply to this thread, use your normal e-mail reply function.]============================================================Topic: What's new today report shows attachments in a workflowhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2311585&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

Scott_Herman_(webmadmin_-_(deleted))

Where is information such as the fact that subtype 154 is a workflow attachment available?

eLink User

Message from Xu Moua via eLinkLog into Livelink as the Admin user, go to the Administration page and clickon the help icon (the question mark at the top right corner). Expand 'AdminOnline Guide', expand 'opentext.ini Reference', click on 'Node Type Numberto Mappings'.-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: July 25, 2000 3:49 PMTo: eLink RecipientSubject: RE- RE- RE- RE- What's new today report shows attachments in aworkflowRE- RE- RE- RE- What's new today report shows attachments in a workflowPosted by WebMAdmin on 07/24/2000 02:55 PMWhere is information such as the fact that subtype 154 is a workflowattachment available?[To reply to this thread, use your normal e-mail reply function.]============================================================Topic: What's new today report shows attachments in a workflowhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2311585&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

Steven_Knight_(EllaNUser1_(Delete)_2275084)

I do not see the "admin online guide"

eLink User

Message from Xu Moua via eLinkThe Admin Help pages are only available in Livelink v8.1.5.There are two different Help pages, one for the administrator and the otherfor the public. To access the administrator's Help pages you must be loggedin as the Admin user and MUST be at the administration page (iehttp://..../livelink.exe?func=admin.index) when clicking on the help icon(question mark).If the title of of the Help page is 'Livelink Help Contents' then you arenot at the right place when clicking on the help icon (question mark).The admin help page is titled 'Admin Help Contents'.-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: July 26, 2000 7:37 AMTo: eLink RecipientSubject: RE- RE- RE- RE- RE- RE- What's new today report showsattachments in a workflowRE- RE- RE- RE- RE- RE- What's new today report shows attachments in aworkflowPosted by EllaNUser1 on 07/26/2000 07:36 AMI do not see the "admin online guide"[To reply to this thread, use your normal e-mail reply function.]============================================================Topic: What's new today report shows attachments in a workflowhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2311585&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe