Creating Default View and Adding Default columns to Default View

Peterson Yap

Hi, as mentioned, i am already able to create a default view using the below code: but i would like to add default columns like <Name (linked to document with edit menu)> and to this view. How can i do it? i can only add columns i have added programmatically in my codes, what about system maintained codes like ID? and Name (File Name)??? Please Help!

Thanks!

SPSite siteCol = new SPSite(@"http://vm-moss2007/test/"); SPWeb site = siteCol.OpenWeb(); site.Lists.Add("New Calendar", "This calendar was created programmatically", site.ListTemplates["Calendar"]);
site.Lists.Add("My Custom List", "This list was created programmatically", site.ListTemplates["Custom List"]); SPList newList = site.Lists["My Custom List"]; newList.OnQuickLaunch = true; newList.Update();newList.Fields.Add("NewText", SPFieldType.Text, true);SPList targetList = site.Lists["My Lookup Target"]; SPField targetField = targetList.Fields["My Target Lookup Column"]; newList.Fields.AddLookup("NewLookup", targetList.ID, false); SPFieldLookup lkp = (SPFieldLookup)newList.Fields["NewLookup"]; lkp.LookupField = targetField.InternalName; lkp.Update();//*** Doesn't work for some obscure reason *** newList.DefaultView.ViewFields.Add("NewText"); newList.DefaultView.ViewFields.Add("NewLookup"); newList.DefaultView.Update();PView view = newList.DefaultView; view.ViewFields.Add("NewText"); view.ViewFields.Add("NewLookup"); view.Update();

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair16y ago
hi peter,

Can you submit an article regarding your query here. This will helpful for others to learn.

No one had replied your post, so might a knowledge sharing will helpfull.
Peterson Yap16y ago
This is my solution! to see a list of internal names used for built in fields, see this site.http://blog.thekid.me.uk/archive/2007/03/21/wss-field-display-amp-internal-names-for-lists-amp-document-libraries.aspx

#region Add Columns

                SPList list = web.Lists[cb_targetList.Text];

                SPField fileNameField = list.Fields.GetField("LinkFilename");

                SPField versionField = list.Fields.GetField("_UIVersionString");

                SPField createdByField = list.Fields.GetField("Created By");

                SPField modifiedByField = list.Fields.GetField("Modified By");

                SPField createdField = list.Fields.GetField("Created");

                SPField modifiedField = list.Fields.GetField("Modified");

                SPField approvedStatusField = list.Fields.GetField("_ModerationStatus");

                SPView view = list.DefaultView;
                view.ViewFields.DeleteAll();
                view.ViewFields.Add("Document Name");
                view.ViewFields.Add(fileNameField);
                view.ViewFields.Add("Functional Type");
                view.ViewFields.Add("Sub Functional Type");
                view.ViewFields.Add("Product Type");
                view.ViewFields.Add("Is Document Active?");
                view.ViewFields.Add("Category");
                view.ViewFields.Add("Reason for Creation/Revision");
                view.ViewFields.Add("Document Type");
                view.ViewFields.Add("Display in page");
                view.ViewFields.Add(versionField);
                view.ViewFields.Add(createdByField);
                view.ViewFields.Add(modifiedByField);
                view.ViewFields.Add("Document Implementation/Effective Date");
                view.ViewFields.Add("Document Owner");
                view.ViewFields.Add("Document Owner Department");
                view.ViewFields.Add("Document Author");
                view.ViewFields.Add(createdField);
                view.ViewFields.Add(modifiedField);
                view.ViewFields.Add(approvedStatusField);
                view.ViewFields.Add("Approval Date");
                view.ViewFields.Add("Approved By");
                view.ViewFields.Add("Process SLA");
                view.ViewFields.Add("Link to other related internal document");
                view.ViewFields.Add("Link to other related external document");
                view.ViewFields.Add("DocAccessLink");
                view.Update();

                #endregion