.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Lists - wrong field is nameing variable

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :SharePoint
I have created a list of applications which are installable via SCCM and the list is also used to raise new application packaging requests. What I am finding is that the workflow picks up the application developer as the name that is used in workflows, for example, if I raise a request for Microsoft Office Project 2010, the workflow comes back with "Please review Microsoft". How can I persuade the list and the workflow that it is the application name field I want brought back and not the company name? Regards Mark

View Complete Post

More Related Resource Links

How to take value of bound field of grid in a variable or in a textbox.


How to take value of bound field of grid in a variable or in a textbox.

 I m using this code in .aspx page for grid.

<asp:GridView ID="Grd_Mprocess" runat="server" AutoGenerateColumns="False"

                      Width="100%" AllowPaging="True"


                      AllowSorting="True" PageSize="5"  >

                 <RowStyle CssClass="odd" />


<asp:BoundField HeaderText="DOC_TYPE_PK" DataField="DOC_TYPE_PK"  Visible="true" >


  <asp:TemplateField HeaderText="DOC TYPE ID" Visible="true">  &nbs

Combining data from 2 lists, then summing a field


I have 2 lists, one is a contact list (client, client title, address, etc.), the other is a list of meetings with these clients (client name, type of meeting, date, etc.).  The 2nd list has multiple entries for the same client.  I am trying to create a report that combines the data in these lists and displays them like this:

Client--Client Title--MeetingType1--MeetingType2




In addition to combining the list data, I also need to break up the Type of Meeting field and sum the number of different types of meetings for each client.  I added the 2 lists to a linked source, then inserted the data into a DVWP adding data from the 2nd list as a joined subview.


I tried this: xsl:value-of select="count(/dsQueryResponse/Rows/Row[@TypeOfMeeting = 'MeetingType1'])" but it just returns 0.  I'm not sure if that's the correct method though as I think it will return a count of ALL the rows, not the current row.  Any ideas would be appreciated!

Field CLR Types via Lists Web Service

I have an app that is retrieving list data via the Lists web service.  Currently, all data is returned as a string in a DataTable.  This works ok, but it doesn't work with the charting tool, which needs values of type int or float.  So I set the column types based on http://msdn.microsoft.com/en-us/library/ms131092.aspx and http://msdn.microsoft.com/en-us/library/ms437580(v=office.12).aspx.  For example, if the field type is Number, then I set the DataColumn type to Double.  But now, certain values cause exceptions because the returned value doesn't parse to the documented type.  For example, Lookup type fields are documented to be stored as int types, but the actual values returned are like "1;#". Does anyone have some advice about how to do this?  I have a big switch statement that checks the field type, and sets the DataColumn type according to the documentation, and I'm thinking of reducing it so that it only sets some of the types, for instance, Number and DateTime, but leaves the rest as string types.my blog - Tea Time with Meowkins

field from Lists web serice render pattern

When you pull list data from the Lists web service, is the value that it gives you based on one of the RenderPatterns in the field or field type definition?my blog - Tea Time with Meowkins

Update Managed Metadata Field with using Lists.asmx service

Hello! I am trying to update Managed Metadata Field with using Lists.asmx. I know that I must use this format WSSID;#VALUE|GUID. But I don't Know how I can get WSSID and VALUE Guid! Can I get them with using lists.asmx! Thanks!!

WSS Lists - Lookup field information missing in Excel 2010

Hi, I've got this xls workbook which contains a two-way synchronized SharePoint list. This WSS list contains columns which are related to other lists: for instance the list we're using is a list of assignments, where an assignment is related to an accounting period. Our server also has another list with all accounting periods. Both lists are related since the assignment list as an accounting period column of lookup type which uses the accounting period list as a source. In previous versions of Excel, the output is that the accounting period field is a combobox populated with all availalble accounting periods. Thanks to that, the user can easily link an assignment to an accounting period by selecting a value in this combobox and synchronizing. This works great with Excel 2003 and 2007, however in 2010 (same workbook, consuming the same lists) related information doesn't appear. The combobox is empty and as a consequence the user gets a data validation error since the value in the cell isn't among available values. Is there something special I should do to enable this feature in Excel 2010? Regards, Carl 

Field level permissions on WSS 3.0 lists

I am using the Help Desk template, and need to lock it down a bit.  I would like to keep users from changing the Priority field on both the NewForm.aspx and EditForm.aspx pages.  I need my technicians to be able to edit the field, but would like it to either be hidden from the user, or have it displayed like the "Assigned To" field where it says " The control is not available because you do not have the correct permissions."   Someone suggested adding JavaScript to the pages in SharePoint Designer, but I do not know how I could wrap those fields in JavaScript so that it checks group membership.   Is what I am looking for too complex for SharePoint, or is there hope?   -Derek Brown Sr. System Engineer Vision One IT Consulting dbrown@v1corp.com

sp v2 - possible to add a field to existing Lists by script?

thousands of meeting workspaces in V2.0 only one doc lib in each, docs to be migrated to moss, without folders, so need to identify where it came from, am thinking add a column prior to migration, but don't know if possible. Alternately I could first migrate into moss, then add column, then migrate again, but very time consuming for that first step, even if it runs by itself. i am not a programmer, my appologies if this belongs elsewhere, but i'm hoping a developer may have some idea. Thank you, ps: migration to be done with DocAve or Metalogix, because cross-domain, and V2.0 had custom defs, so database upgrade not possible.

MVC Validation Pattern Question, Especially for Variable Length Lists and Conditional Validation


I've spent a lot of time exploring the various patterns of MVC validation. In particular, I am interesting in learning best-practice for validating a view which posts an enumerable collection back to the controller. One approach that is appealing involves posting the form via Ajax to check validation (http://jvance.com/blog/2010/02/20/MakingAnAjaxFormWithJQueryInASPdotNETMVC.xhtml). Obviously, the negative is that this is not true client-side validation since there is a "hidden" server round-trip, but the effect is comparable, and obviously client-side validation alone will never stand--server-side always needs to be done as well.

The CodePlex repository for this demo: http://mvcajaxvalidation.codeplex.com/SourceControl/list/changesets

The main reason I started heading this route is because in the course of writing lots of custom data annotation model validators (think "RequiredIf" or "RequiredWhenContains") it became very evident that the wiring to the client-side gets complicated. I was mostly able to pull it off using the custom validators' GetClientValidationRules() plus jQuery validator extensions (.addMethod('requiredif'...), ho

InputFormSection in a custom field renders on wrong position in 2010


Hi all,

i developed a custom field which uses InputFormSection and InputFormControl with CAMLRendering to render if a user adds it to a list:

<%@ Register TagPrefix="wssuc" TagName="InputFormSection" Src="/_controltemplates/InputFormSection.ascx" %>
<%@ Register TagPrefix="wssuc" TagName="InputFormControl" Src="/_controltemplates/InputFormControl.ascx" %>


Selecting a field based on a variable


If I have a field name in @FieldName is there a way to do something like

SET @FieldName = 'MyField'

SELECT @FieldName FROM MyTable

where the above would yeild the same results as

SELECT MyField from MyTable

Thanks in advance.

QueryExtender Control - Variable field name to search against


FrownI have been alerted to the Query Extender control through previous posts, but I am still seeking the final part of my desired solution.

NB the following is written in conceptual English (programming specification) format, rather than actual asp code.

While I fully understand that I can use the QueryExtender control to pass a parameter from one web page to another, I do not see, and maybe this is not even possible, how I can pass a parameter of which field I want to select on.

Ideally I would like to be able to implement a query which is

SELECT tiles where 'Passed Variable Name' contains 'Passed Test Value'

such as would then generate, for example -

SELECT titles where 'Series Available' contains 'A'


SELECT titles where 'Authors' contains 'Wyndham'

but I just can't work out how I can implement the varying search field.

Is what I am seeking for possible? OR

Am I going to be forced to implement an approach such as the following?

SELECT Calling Web Page

CASE "Series" 

SELECT titles where 'Series Available' contains 'passed variable'

CASE "Authors"

BDC field returns wrong value in the Value Picker



I have a BDC entity in an application with multiple functioning entities but one of the entities is not behaving.

it returns a list of varchar(100) values and it works in application configuration tool when tested.

When I use the Picker, I see the values in the list but when I select a value and the picker closes, the value left in the control on the screen is not the value I selected "Technical" but a value I do not understand


no data in the table even resembles this value.  I have a hunch this is the word "Technical" in some encoded form.


Here is a snippet from the BDC definition

The GetAll method is the one that is causing the pain. 

any help would be greatly apreciated.


 I had to delete the top two methods to get this to post on this site.(they were the auto created methods from the BDC tool

The error w

Designing lists: Quick key combination for adding a new list column field?


I'm simply looking for a way to quickly design lists, and I find it rather slow to use the mouse to go to the Add New Column button in the ribbon every time when I want to add a new list field.

The only column that can't be changed type of later seems to be the Calculated column. But for all others, you can still change them afterwards.

Site content type's column with wrong field type that was created once will not work if re-created


I've created the column 'MyDescription' with type 'Multiline Enchanced Text' in my custom content type derived from 'Page'. But later I understood that 'Publishing HTML' is better for me. I've removed the 'MyDescription' column and recreated 'MyDescription' with type 'Publishing HTML'.

Page layout for my custom content type uses this code to display field

<PublishingWebControls:RichHtmlField FieldName="MyDescription" runat="server"/>

But page falls without any error information. I've deleted and recreated page: it fell always.

When I created column 'MyDescription1' with 'Publishing HTML' type in my custom content type and changed code to this


Retrieve a hidden flag/field/ textbox/ variable from SSRS in C# with reportExecutionService



I want to set a HIDDEN flag in my reports (SSRS 2008) and retrieve in my C# code. If it's possible please share your suggestions.


Thank you,


Reformatting variable character date field in custom table


I have a custom table with a variable character field storing a date. It is currently in the format YYYY/DD/MM plus a time stamp. I want it in the format MM/DD/YYYY without a time stamp.

I've tried a few CONVERT and UPDATE statements, with no change. The syntax is okay, and in some cases the statement has an effect (such as cutting off all but one character of the time stamp), but does not reformat the date. I've also tried resetting the fields as DATE fields or SMALLDATETIME fields in the custom table, and I receive errors after doing that.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend