Popular Tags

  • What is the format of the "TS_CONTENTS" field in TS_FILE_OBJS and TS_FILE_OBJS_TEMP tables?

    When using a File type field, the file added frequently a unique file name in the "TS_CONTENTS" field in the TS_FILE_OBJS_TEMP and TS_FILE_OBJS tables. The unique name seems to have the format " [original filename]_[Item Table ID]_[Item Record ID]_[Add…

  • How to archive inactive items in Serena.

    Hi, I want to archive all inactive items prior to some date including all attachments of those items. We are storing attachments in database. Our Serena database growth is rapid, so we want to move some items to archives to increase performance. Is…

  • Reports are taking too long to fetch results in workcenter

    I have a project as "IT Work management" and this projects have two applications as "Work Requests" and "Project Requests" I am creating a listing reports in work center with one application "Work requests" is selected as Report Project. I have used…

  • How to get the values of System table fields through SBM App script.

    I want to get the records of TS_LASTIDS tables to get a LAST id of a particular table. I have written below piece of code. Set lastIdRec = Ext.CreateAppRecordList(Ext.TableID("TS_LASTIDS")) whereClause = "TS_TABLEID = "

  • Database Schema help

    I'm trying to create a SQL query that would allow me to view the dependencies between two user defined fields. For example I have created a single selection field called "system name" and made it dependent to a user field called "manager". I'm trying…

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.