Obtaining the File Number for an Object

Greg Kellogg

I am trying to create a LiveReport for a bureau of DOI that displays the File Number from the Records Detail tab for an object.  In the image attached this is displayed as 1.4.15.  When I search the DB (SELECT * FROM RM_CLASSIFICATION WHERE FileNumber='.15') I can see the FileNumber which gives me the last part of the necessary data.  I just can't figure a way to get the full file number for a specific dataid. I need to tie this number to a specific object (in this case a folder).

Any help is greatly appreciated.

SQLResults.jpg

FileNumber.jpg

Brian_Walsh

Hi Greg,

 

Based on that screenshot you have the wrong value in your query. It is returning what you ask for where FileNumber = ‘.15’

1.4.15 is not the same. If you want that to work then you need to use LIKE ‘%%.15%%’ instead or use the actual value.

 

Brian G Walsh
Principal Technical Analyst

Content Server Team

OpenText Corporation
1-800-540-7292
bwalsh@opentext.com

 

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, March 14, 2017 12:51 PM
To: eLink Recipient
Subject: Obtaining the File Number for an Object

 

Obtaining the File Number for an Object

Posted by Kellogg, Greg On 03/14/2017 12:44 PM

 

I am trying to create a LiveReport for a bureau of DOI that displays the File Number from the Records Detail tab for an object.  In the image attached this is displayed as 1.4.15.  When I search the DB (SELECT * FROM RM_CLASSIFICATION WHERE FileNumber='.15') I can see the FileNumber which gives me the last part of the necessary data.  I just can't figure a way to get the full file number for a specific dataid. I need to tie this number to a specific object (in this case a folder). Any help is greatly appreciated.

 

Attachment Links:

FileNumber.jpg (109 KB)

SQLResults.jpg (36 KB)

---

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center CS16