Property Define / Name | Prop No | Panagon name |
---- Item object attributes ---- |
SPI_ITEM_ID Item ID | 257 | idmId |
SPI_ITEM_OWNER Added by User | 258 | idmAddedByUser |
SPI_ITEM_GROUP Added by Group | 259 | idmAddedByGroup |
SPI_ITEM_CREATE_DATE Date Added | 260 | idmDateAdded |
SPI_ITEM_COMMENT Comment | 261 | idmComment |
SPI_ITEM_PROTECTED Protected? | 262 | idmDocProtected |
SPI_ITEM_ORIGINAL_FILE Original File Name | 263 | idmDocOriginalFile |
SPI_ITEM_FILE_CATEGORY Storage Category | 264 | idmDocFileCategory |
As you can see, some of these names are motivated by the original Mezzanine define names. This
makes things particularly hard to guess unless you happen to know Mezzanine. |
SPI_ITEM_CURVER_TRUNC_FILE Default Checkout File Name | 265 | idmDocCurVerTruncFile |
SPI_ITEM_VARIANTS Allow Secondary Version Lines? | 266 | idmDocVariants |
SPI_ITEM_ONLINE_LIMIT Online Limit | 267 | idmDocOnlineLimit |
SPI_ITEM_DISP_CATEGORY Archive Category | 268 | idmDocDispCategory |
Oddly, the use of the define name takes us back to the old pre-3.5 days, when men were men and archive
categories were still disposition categories. |
SPI_ITEM_CURVER_NUM Current Version ID | 269 | idmDocCurVerNum |
SPI_ITEM_DATE Current Version Date | 270 | idmDocCurVerDate |
SPI_ITEM_AUTHOR Current Version Author | 271 | idmDocOwner |
SPI_ITEM_ONLINE_COUNT Online Version Count | 272 | idmDocOnlineCount |
SPI_ITEM_ONLINE_SIZE Online Disk Space | 273 | idmDocOnlineSize |
SPI_ITEM_LAST_DATE Last Access Date | 274 | idmDateAccessed |
SPI_ITEM_LAST_VERSION_ID Last Access Version | 275 | idmDocLastVerId |
SPI_ITEM_CURVER_CHECKED_OUT Current Version Checked Out? | 276 | idmDocCurVerCheckedOut |
SPI_ITEM_ICON_TITLE Title | 277 | idmName |
As you may recall, the Mezzanine API specified no set use for this attribute.
However, SDM always used it for the title (as opposed to the filename) of each document. Panagon
is using a lot of SDM conventions (including the folder structure) and this is one of them. |
SPI_ITEM_KEYWORDS Keyword | 278 | idmDocKeywords |
SPI_ITEM_VERSIONS Versions | 279 | n/a |
SPI_ITEM_VERSIONS, of course, is tool type 4, meaning it's really a join to another table.
So it has no meaningful value and, unlike keywords, you can't specify a meaningful value to be
used in a search. So it is omitted from the Panagon API. The same applies to the next two "attributes." |
SPI_ITEM_CHECKOUTS Versions Checked Out | 280 | n/a |
SPI_ITEM_ACL Access List | 281 | n/a |
SPI_ITEM_CUSTOMxx Custom 1-20 and 21-40 | 282-301 307-326 | idmCustom1-idmCustom40 |
depends | idmDocType |
Whichever custom property is set up to be the document type (denoted by the
name DocType) also can be referred to using the name idmDocType. |
SPI_ITEM_CURVER_CSI_ID Current Content Search Repository | 302 | idmDocCurVerCsiId |
SPI_ITEM_CURVER_CSI_CID Current Version Index ID | 303 | idmDocCurVerCsiCid |
SPI_ITEM_CSI_DEFAULT Default Index Versions? | 304 | idmDocCsiDefault |
SPI_ITEM_CSI_COUNT Number of Indexed Versions | 305 | idmDocCsiCount |
SPI_ITEM_CSI_LIMIT Indexed Version Limit | 306 | idmDocCsiLimit |
SPI_ITEM_MV_CUSTOMxx Multivalued Custom Properties 1-10 | 327-336 | ??? |
Sorry, we haven't figured MVAs out yet. Watch this space for further details. |
---- Version object attributes ---- |
SPI_VERS_ID Version ID | 513 | idmVerId |
SPI_VERS_ITEM_ID Item ID | 514 | idmVerDocId |
SPI_VERS_CHECKIN_USER Checked In By User | 515 | idmVerCheckinUser |
SPI_VERS_CHECKIN_GROUP Checked In By Group | 516 | idmVerCheckinGroup |
SPI_VERS_CREATE_DATE Checkin Date | 517 | idmVerCreateDate |
SPI_VERS_COMMENT Comment | 518 | idmVerComment |
SPI_VERS_APPLICATION Application | 519 | idmVerApplication |
SPI_VERS_FILE_DATE Modification Date | 520 | idmVerFileDate |
SPI_VERS_FILE_SIZE File Size | 521 | idmVerFileSize |
SPI_VERS_SHELF_DATE Storage Date | 522 | idmDateModified? |
SPI_VERS_SHELF_ID Storage Repository | 523 | idmVerShelfId |
SPI_VERS_SHELF_FILE_ID Encrypted File Name | 524 | idmVerShelfFileId |
SPI_VERS_LAST_DATE Last Access Date | 525 | idmPrevCheckoutDate |
SPI_VERS_LAST_USER Last Access User | 526 | idmModifiedByUser |
SPI_VERS_LAST_GROUP Last Access Group | 527 | idmVerLastGroup |
SPI_VERS_AVAIL_STAT Availability Status | 528 | idmVerAvailStat |
SPI_VERS_DISP_ID Archive Repository | 529 | idmVerDispId |
SPI_VERS_DISP_DATE Archive Date | 530 | idmVerDispDate |
SPI_VERS_RECLAIM_PENDING Reclaim Pending? | 531 | idmVerReclaimPending |
SPI_VERS_PERMANENT Permanent Version? | 532 | idmVerPermanent |
SPI_VERS_CHECKOUT_PENDING Checked Out? | 533 | idmVerCheckoutPending |
SPI_VERS_MERGE_SRC Merge-Source Version ID | 534 | idmVerMergeSrc |
SPI_VERS_MERGE_DST Merge-Destination Version ID | 535 | idmVerMergeDst |
SPI_VERS_BRANCH_COUNT Secondary Version Line Count | 536 | idmVerBranchCount |
SPI_VERS_BRANCH_CURVER Latest Version? | 537 | idmVerBranchCurVer |
SPI_VERS_RECLAIM_DATE Reclaim Submitted Date | 538 | idmVerReclaimDate |
SPI_VERS_CHECKOUT_USERS Current Checkouts | 539 | n/a |
SPI_VERS_B_I_ID_MAJOR Full Backup ID | 540 | n/a |
SPI_VERS_B_I_ID_MINOR Incremental Backup ID | 541 | n/a |
SPI_VERS_CHECKOUT_DATE Source Version Checkout Date | 542 | idmVerPrevCheckoutDate |
SPI_VERS_OFFLINE_LOCATION Offline Location | 543 | idmVerOfflineLocation |
SPI_VERS_CSI_ID Content Search Repository | 544 | idmVerCsiId> |
SPI_VERS_CSI_CID Index ID | 545 | idmVerCsiCid |
SPI_VERS_CSI_STATUS Indexing Status | 546 | idmVerCsiStatus |
SPI_VERS_CSI_MAJOR Index Full Backup ID | 547 | n/a |
SPI_VERS_CSI_MINOR Index Incremental Backup ID | 548 | n/a |
SPI_VERS_CSI_PERMANENT Permanent Index? | 549 | idmVerCsiPermanent |
SPI_VERS_CUSTOM01-40 Custom Properties 1-40 | 550-589 | idm |
SPI_VERS_MV_CUSTOM01-10 Multivalued Custom Properties 1-10 | 590-599 | idm |
SPI_VERS_FILE_NAME File Name | 600 | idmVerFileName |