I don't think credit line is in the "Objects (Original)" list that ships
with TMS 9.35. At least it is not in our installation.
If you want to add columns to a list view you will have to create or modify
a SQL view on the server side before you can configure the list in
LVDesigner.
Here is an example of how you could modify the version of the canned SQL
view used by the Objects default list view to include the credit line field.
/* Change the view name to match the standards at your institution */
CREATE VIEW vHUAMListViewObjects
AS
SELECT O.ObjectID AS ID, O.ObjectNumber, O.SortNumber, D.Mnemonic,
CL.Classification, OC.Culture, OC.Period,
C.DisplayName, C.AlphaSort, O.ObjectName, OT.Title, O.Dated,
O.DateBegin,
SUBSTRING(O.Medium,1,255) AS Medium,
SUBSTRING(O.Dimensions,1,255) AS Dimensions,
SUBSTRING(O.Description,1,255) AS Description,
SUBSTRING(O.Creditline, 1, 255) AS Creditline
FROM Objects O
INNER JOIN Departments D ON O.DepartmentID = D.DepartmentID
INNER JOIN vListViewClassifications CL ON O.ClassificationID =
CL.ClassificationID
INNER JOIN ObjContext OC ON O.ObjectID = OC.ObjectID
LEFT JOIN ConXrefs CX ON O.ObjectID = CX.ID AND CX.TableID = 108 AND
CX.RoleTypeID = 1 AND CX.Displayed = 1 AND CX.DisplayOrder = 1
LEFT JOIN Constituents C ON CX.ConstituentID = C.ConstituentID
LEFT JOIN ObjTitles OT ON O.ObjectID = OT.ObjectID AND OT.Displayed = 1 AND
OT.DisplayOrder = 1
GO
/* Change the view name to match the name used in the CREATE VIEW
statement*/
GRANT SELECT ON [vHUAMListViewObjects] TO [TMSUsers]
GO
Once this is created in the TMS database then use LVDesigner to construct a
new list view. Select the name of the new SQL view as the Database View and
you are on your way.
-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On
Behalf Of Joseph Leduc
Sent: Wednesday, October 29, 2008 10:29 AM
To: [log in to unmask]
Subject: Re: modifying default list in List View Designer
Hi Annie,
I read your reply as well as Christine's with the screen shot with interest,
as I've been wondering how to get credit lines into list views as well. Did
I understand Christine's message correctly that in 9.35 the "Objects
(Original)" list view should have credit line already included as an option,
or should I understand you to be saying that there's an additional step
needed to make credit lines available? We are running 9.35 (although only
on service pack 1--gotta do that update) and don't seem to have credit lines
as an option in our list views--we top out at 16 available columns, without
the 17th that Christine's showing. Thanks for your help, and sorry if I'm
missing something blindingly obvious. Best wishes--
Joe Leduc, Associate Registrar
Worcester Art Museum
55 Salisbury Street
Worcester, MA 01609-3196
508-799-4406 x.3029
fax: 508-798-8498
[log in to unmask]
_____
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On
Behalf Of Annie VanAssche
Sent: Tuesday, October 28, 2008 6:10 PM
To: [log in to unmask]
Subject: Re: modifying default list in List View Designer
Hi Maja:
Actually, you can do this in the List View Designer program. There is no
DBConfig setting that allows you to do this.
Now for the caveat: To add a field (or column) to a List View, you need to
know SQL (you do it by writing a SQL script in the program). I don't know
SQL, so I can't help you beyond this point. ;(
Best regards,
Annie
Annie Van Assche
Gallery Systems
Associate Trainer and Project Specialist
28-05 33rd St., 12th Floor
New York, NY 10001
(646) 733-2239 x 224
[log in to unmask]
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On
Behalf Of Maja Clark
Sent: Tuesday, October 28, 2008 5:38 PM
To: [log in to unmask]
Subject: modifying default list in List View Designer
I want to add "Credit Line" to my default list in LV Designer for the
Objects module. I have a note in my very own chicken scratch that this is
done in Database Configuration..but where?
Thanks,
Maja
Maja Clark
Registrar, Shangri La
Doris Duke Foundation for Islamic Art
4055 Papu Circle
Honolulu, HI 96816
(808) 792-5506
www.shangrilahawaii.org <http://www.shangrilahawaii.org/>