Topic: Panagon -- Property names

Panagon index ]
Remember the Mezzanine bible, the SDK book that listed anything and everything about the API? Don't you wish you had that for Panagon? So do we, and we're sort of writing one inhouse. One of the most annoying omissions from the online documentation that FileNET provides with the Panagon developer's kit is, well, what are we supposed to call those document properties anyway?

The information is there, sort of, but it's only listed in the search references, and we can never find it. So bookmark this page, because here goes:

MEZZANINE PROPERTY TO PANAGON PROPERTY CONVERSION CHART
Property Define /
Name
Prop
No
Panagon name
---- Item object attributes ----
SPI_ITEM_ID
Item ID
257idmId
SPI_ITEM_OWNER
Added by User
258idmAddedByUser
SPI_ITEM_GROUP
Added by Group
259idmAddedByGroup
SPI_ITEM_CREATE_DATE
Date Added
260idmDateAdded
SPI_ITEM_COMMENT
Comment
261idmComment
SPI_ITEM_PROTECTED
Protected?
262idmDocProtected
SPI_ITEM_ORIGINAL_FILE
Original File Name
263idmDocOriginalFile
SPI_ITEM_FILE_CATEGORY
Storage Category
264idmDocFileCategory
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
265idmDocCurVerTruncFile
SPI_ITEM_VARIANTS
Allow Secondary Version Lines?
266idmDocVariants
SPI_ITEM_ONLINE_LIMIT
Online Limit
267idmDocOnlineLimit
SPI_ITEM_DISP_CATEGORY
Archive Category
268idmDocDispCategory
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
269idmDocCurVerNum
SPI_ITEM_DATE
Current Version Date
270idmDocCurVerDate
SPI_ITEM_AUTHOR
Current Version Author
271idmDocOwner
SPI_ITEM_ONLINE_COUNT
Online Version Count
272idmDocOnlineCount
SPI_ITEM_ONLINE_SIZE
Online Disk Space
273idmDocOnlineSize
SPI_ITEM_LAST_DATE
Last Access Date
274idmDateAccessed
SPI_ITEM_LAST_VERSION_ID
Last Access Version
275idmDocLastVerId
SPI_ITEM_CURVER_CHECKED_OUT
Current Version Checked Out?
276idmDocCurVerCheckedOut
SPI_ITEM_ICON_TITLE
Title
277idmName
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
278idmDocKeywords
SPI_ITEM_VERSIONS
Versions
279n/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
280n/a
SPI_ITEM_ACL
Access List
281n/a
SPI_ITEM_CUSTOMxx
Custom 1-20 and 21-40
282-301
307-326
idmCustom1-idmCustom40
dependsidmDocType
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
302idmDocCurVerCsiId
SPI_ITEM_CURVER_CSI_CID
Current Version Index ID
303idmDocCurVerCsiCid
SPI_ITEM_CSI_DEFAULT
Default Index Versions?
304idmDocCsiDefault
SPI_ITEM_CSI_COUNT
Number of Indexed Versions
305idmDocCsiCount
SPI_ITEM_CSI_LIMIT
Indexed Version Limit
306idmDocCsiLimit
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
513idmVerId
SPI_VERS_ITEM_ID
Item ID
514idmVerDocId
SPI_VERS_CHECKIN_USER
Checked In By User
515idmVerCheckinUser
SPI_VERS_CHECKIN_GROUP
Checked In By Group
516idmVerCheckinGroup
SPI_VERS_CREATE_DATE
Checkin Date
517idmVerCreateDate
SPI_VERS_COMMENT
Comment
518idmVerComment
SPI_VERS_APPLICATION
Application
519idmVerApplication
SPI_VERS_FILE_DATE
Modification Date
520idmVerFileDate
SPI_VERS_FILE_SIZE
File Size
521idmVerFileSize
SPI_VERS_SHELF_DATE
Storage Date
522idmDateModified?
SPI_VERS_SHELF_ID
Storage Repository
523idmVerShelfId
SPI_VERS_SHELF_FILE_ID
Encrypted File Name
524idmVerShelfFileId
SPI_VERS_LAST_DATE
Last Access Date
525idmPrevCheckoutDate
SPI_VERS_LAST_USER
Last Access User
526idmModifiedByUser
SPI_VERS_LAST_GROUP
Last Access Group
527idmVerLastGroup
SPI_VERS_AVAIL_STAT
Availability Status
528idmVerAvailStat
SPI_VERS_DISP_ID
Archive Repository
529idmVerDispId
SPI_VERS_DISP_DATE
Archive Date
530idmVerDispDate
SPI_VERS_RECLAIM_PENDING
Reclaim Pending?
531idmVerReclaimPending
SPI_VERS_PERMANENT
Permanent Version?
532idmVerPermanent
SPI_VERS_CHECKOUT_PENDING
Checked Out?
533idmVerCheckoutPending
SPI_VERS_MERGE_SRC
Merge-Source Version ID
534idmVerMergeSrc
SPI_VERS_MERGE_DST
Merge-Destination Version ID
535idmVerMergeDst
SPI_VERS_BRANCH_COUNT
Secondary Version Line Count
536idmVerBranchCount
SPI_VERS_BRANCH_CURVER
Latest Version?
537idmVerBranchCurVer
SPI_VERS_RECLAIM_DATE
Reclaim Submitted Date
538idmVerReclaimDate
SPI_VERS_CHECKOUT_USERS
Current Checkouts
539n/a
SPI_VERS_B_I_ID_MAJOR
Full Backup ID
540n/a
SPI_VERS_B_I_ID_MINOR
Incremental Backup ID
541n/a
SPI_VERS_CHECKOUT_DATE
Source Version Checkout Date
542idmVerPrevCheckoutDate
SPI_VERS_OFFLINE_LOCATION
Offline Location
543idmVerOfflineLocation
SPI_VERS_CSI_ID
Content Search Repository
544idmVerCsiId>
SPI_VERS_CSI_CID
Index ID
545idmVerCsiCid
SPI_VERS_CSI_STATUS
Indexing Status
546idmVerCsiStatus
SPI_VERS_CSI_MAJOR
Index Full Backup ID
547n/a
SPI_VERS_CSI_MINOR
Index Incremental Backup ID
548n/a
SPI_VERS_CSI_PERMANENT
Permanent Index?
549idmVerCsiPermanent
SPI_VERS_CUSTOM01-40
Custom Properties 1-40
550-589idm
SPI_VERS_MV_CUSTOM01-10
Multivalued Custom Properties 1-10
590-599idm
SPI_VERS_FILE_NAME
File Name
600idmVerFileName





Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.