Asset "name" field
As I understand it, when creating custom asset types the first field in a table is automatically created and named "name". In one forum post this field is identified as a unique key. In one of the asset management videos however the "name" field is shown with several non-unique values. Also I understand that there is a record ID automatically created for each record.
Is is necessary to have or use this "name" field?
Can it be renamed?
Is it designed as a key and therefore must be unique?
Is is necessary to have or use this "name" field?
Can it be renamed?
Is it designed as a key and therefore must be unique?
0 Comments
[ + ] Show comments
Answers (3)
Please log in to answer
Posted by:
GillySpy
12 years ago
it is not unique, but you would be well advised to treat it as unique since the ID is not obvious in the UI. It is commonly flagged as unique "PK" when importing data from a csv. You can flag any field (or combination of fields) as the "PK" for a given import, but it's not relevant to database structure since IDs will keep everything unique anyway.
Posted by:
cblake
12 years ago
The Name field is required in the asset type and must be called name; but can be null in the asset itself. As Gerald said, it does not have to contain unique information. You'll often hear it called the key, because it always exists. The name field is the only fixed field because we have to have something common to query to display data in other places that leverage the assets such as tickets, or other assets that have a linked asset type field.
Hope that helps.
Hope that helps.
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.