Verified Answers

If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Verified Answer
  • Replies replies
    2
  • Subscribers subscribers
    19
  • Views views
    83
  • Users 0 members are here
Related
Options

Sequential Number in New Custom Table

ulto1

hi Experts,

I need your help please.

I am new to SMAX so please excuse my ignorance Slight smile

I am trying to create a new table and when i reach the Primary Key Define, there are 3 options: 
- No primary key
- Use 'Display Label' field
- Create new field

and no matter what we do, the ID field is created and Display label is set as a primary key or mandatory.

This table that i am creating is used for reporting and data shouldn't be unique (display label or anything) we can have multiple records having the same values.

My question is, is there a way to configure a sequential number to add it to the display label or id field for that particular table? for example the structure will be "prefix" + last value + 1

For example the ID field for the first record will be Rep1
For the second record it will be Rep2
for the third record it will be Rep3

Please let me know.

Thanks

  • Verified Answer

    +1  

    Hi Ulto,

    I think here it depends how you want to implement this table. Basically from what you are suggesting you don't really require a Primary Key. So you can let SMAX generate an Id for you. If you use Display Label then yes this field needs to be unique which is were you'll need to setup rules in order to make sure you can keep some form of naming convention. Otherwise you use a custom field and set that to work in a similar manner.

    As you don't really care about having a unique display label I'd go for using No Primary key. Then you can create as many reports as you'd like having the same value. Just like you could for the Request or Change modules.

    I'm not sure you really want to go to the length of trying to create your own Id field and use concat rules to add number sequences if you don't have too. Maybe just let SMAX handle the Id field numbers knowing they will be unique. Then enter the relevant Display Label for that Report record. Here is an example of what I mean:

    As you can see there is two records and both are called Network. SMAX auto-created the Id number with No Primary Key assigned.

    Hope that helps to explain it a bit better.

  • 0 in reply to   

    Thanks Dave

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.