.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

Custom filter - Looking in 2 fields

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :ASP.Net

I'm using DD and VS 2010 in my application.

I have two dates (Start Time and PLN Start Time). In my filter, when the user choose a date, if the Start Time is null, I need to verify the PLN Start Time. Something like the code bellow:


        public DateTime StartTimeFilter
                if (this.StartTime.HasValue)
                    return Convert.ToDateTime(this.StartTime);
                    return Convert.ToDateTime(this.PLNStartTime);

How I can insert that column in my page filter ?

View Complete Post

More Related Resource Links

custom field type works in view properties, but not in list view: 3 parent fields filter child list,


My situation:

A) odd thing is that no matter where I put a stop point in my custom field type, it is NEVER hit when the items are displayed in list view.  Event with <Field Name="CAMLRendering">TRUE</Field> which causes the list to error out, but again no stop point to help me know why.

B) the value of the column in question will be different for every user who views the list, I'm querying a secondary list based on the user's loginName, and two of the fields from the list we're in. 

C) the display is customized based on whether any records were returned and the current DateTime, so possible displays would be "", "! 12/1/2010", and "7/7/2011"

D) and the text displayed links over to a form for them to do their assignment. the link url would be a config setting url + "?[one of the fields form the list we're in]"

My questions:

1) Is it possible for fieldtype code to execute while a list view is being rendered?

2) If not, then should I chase down the path of a content query webpart?  Will it be able to filter on the current users login name?

3) If not on 1 or 2, can you think of any other way to do this beyond creating a custom application page? (need to having filtering and sorting on this page)

Cutting Edge: Custom Data Control Fields


In ASP. NET 2. 0, the GridView and DetailsView controls are designed to work together. They don't merely provide complementary services, they also share a number of helper classes and components. The output of the GridView control consists of a sequence of rows, each with a fixed number of columns.

Dino Esposito

MSDN Magazine January 2006

Need to pass parameters from URL to fields in Custom List


I have a complex customized list and I need to pass parameters of two fields so that when the 'Questionnaire' is completed and subsequentially opened after initial submission, it will retrieve the Number and GUID automatically in respective fields. I send an email out with a link to the 'Form' that carries the parameters. I am trying to use the following javaScript but am unsure as to where to place this on the SharePoint page for it to work.



<script type="text/javascript">

function loadFormVars()
getQuerystring('CustodianGUID', 'ctl00_m_g_d08916d8_7224_4665_be72_2de381f45985_ff46_1'); ///replace
customerGUID and form field name
'ctl00_m_g_d08916d8_7224_4665_be72_2de381f45985_FormField11_ctl00_ctl00_TextField'); ///replace customerGUID
and form field name

alert("it works");

function getQuerystring(key, field)
key = key.replace(/[\[]/,"\\\[").replace(/[\]]/,"\\\]");
var regex = new RegExp("[\\?&]"+key+"=([^&#]*)");
var qs = regex.exec(window.location.href);
document.getElementById(field).value = qs[1];


Importing SharePoint List Data into Project Server 2007 Custom Fields

Learn how to use the programmability features of Project Server 2007 and Windows SharePoint Services 3.0 to import SharePoint list data into an enterprise custom field.

Open a link in new window from a custom fields description MOSS 2007



I have kept a help link (ex: http://www.msdn.com) under a document library field's description. i want this link to be opened in a new window with out navigating from that page.

any ideas greatly appreciated.




SharePoint makes Office Document custom fields unreadable


We're using WSS 3.0SP2 with a Document Library that has document-level columns (fields) added. The columns (fields) are defined as single-line text; nothing fancy. In SharePoint we can set the field values no problem. When we pull the documents back out of SharePoint to the file systsem, and look at the Custom Fields, the values are unreadable gibberish. They look like graphics lines and boxes and the Type is set to Unknown.

Any ideas why this is happening and how to fix it?

Adding additional fields to my custom membership provider

Hi, i have been playing around with the membership provider model for the last week and have it got it working with a basic table schema.  The trouble i have is that i wish to add an additional field (eg First Name) but am not sure how i can do this.  Here's what i have so far: public override MembershipUser CreateUser(string username, string password, string email, string passwordQuestion, string passwordAnswer, bool isApproved, object providerUserKey, out MembershipCreateStatus status)    {        MembershipUser user = new MembershipUser(Name, username, providerUserKey, email, passwordQuestion, null, isApproved, false, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now);        string sql = "INSERT INTO USERS(USERNAME,PASSWORD,EMAIL,ISACTIVE) VALUES(@UID,@PWD,@EMAIL,@ISACTIVE)";        db.AddParameter("@UID", username);        db.AddParameter("@PWD", password);        db.AddParameter("@EMAIL", email);        db.AddParameter("@ISACTIVE", (isApproved == true ? "Y" : "N"));        int i = db.ExecuteNonQuery(sql); 

How do you add duplicate fields to a SSRS custom report and receive differtent output values.

I have built a custom report in SSRS 2008 using fields for supplier and customer.   I have added a Parent Row Group using the Supplier field for the group expression and used the Customer Details as my child details group. This returns a list of all customers for each supplier.   (Supplier | = Customer details ( Name, Dob etc.)   How would I add an additional Supplier field to the customer details returning only values for other Suppliers used by a customer, not the value of the Supplier listed in the Parent Group?

Custom Alert Filter Definition

I was trying to create custom filter definition. Requirement : Send alert when the body of discussion contains certain words. These words are to be configurable. I just followed the steps in this blog. http://blogs.msdn.com/b/sharepointdeveloperdocs/archive/2007/12/07/customizing-alert-notifications-and-alert-templates-in-windows-sharepoint-services-3-0.aspx Created seperate template xml and added the definition like below <Filters> <FilterDefinition> <FriendlyName>Post contains </FriendlyName> <ShortName>words or phrase </ShortName> <Query> <Where> <Contains> <FieldRef Name="Body" /> <Value Type="Note">hi</Value> </Contains> </Where> </Query> </FilterDefinition> </Filters> I'm getting some blank radio buttons in the alert configure page, not sure whether to add the custom entries to resource file, where to make changes in core resource file? The value I'm trying to search is hardcoded now in the CAML, I want some text box for entering the value. Please advise.

Move custom list (with lookup fields) to another Web Application

Is it possible to move a custom list with lookup fields to other custom lists from one web application to another? Creating list templates does not work and breaks the relationship. Thanks.   Neil

Custom listbox filter

Hi, I'm trying to create a multiselect listbox filter control.  I was using Josh Heyes filters but I'm upgrading to 4.0 and this is no longer compatible.  I have created a new UserControl which inherits from QueryableFilterUserControl, but I can't work out what I need to put into the GetQueryable method.  It's very similar to the ForeignKey filter, it's just that I want the user to be able to select multiple items in the list. Can anyone help? Thanks, Emma

Adding custom fields into the sharepoint

Hi, As i am not aware of adding custom fields into sharepoint i have followed as per the link http://www.sharepointkings.com/2010/06/creating-custom-field-in-sharepoint.html but i couldn't integrate the custom field so if you have any step by step process of creating and adding custom fields in sharepoint link please let me know Thanks & Regards, Sudheer

Missing fields when filter applied

Hello all, I hope someone can help as I can't figure it out!I shall try my best to explain. I have a report to show all sales quotes by status code (first group), then by Category code (2nd Group) and then by sales quote (3rd group) for the first 2 groups there is a coulmn to show no. of quotes using a CountDistinct expression. My issue is as follows, when running the report by month (Jan, Feb then Mar etc) and taking the total number of quotes for each month and adding them up manually gives a different total when running the report for alll months together (Jan-Mar). For example: Month      No. of Quotes (this is calculated using CountDistinct so not sure if this is the problem?) Jan:          10 Feb:          11 Mar:          8 Total:        29 When run for Jan-Mar I get a total of 25. Looking at the lines there are quotes missing (when running the report for all (Jan-Mar)) but when run by month the quotes appear?

Custom OR Filter on XsltListViewWebPart

Hi, I am having some issues getting a custom document library that is being viewed in an xsltListViewWebPart to filter the way I want it to.   I have found 2 ways to filter down the list using user input. 1.) Add values to the FilterOperations collection based on user input. This works great when you are only trying to filter on one column, or narrowing down searches based on columns. My issue with this method is that I can't search for values in multiple columns (Can do Column1 and Column2 but NOT column1 or column2) 2.) Modify the xmlDefinition of the xsltlistviewwebpart and inject my own query into the xml. This works greats on actually filtering, I can filter down on whatever I want, however, when I do this, I lose ribbon functionality on all but the items that originally appeared on the first page. If you searched for something that returned the 1st and 1530th files in the list, you could use the ribbon on the 1st item, but all document specific ribbon controls are disabled for the 1530th file. There are thousands of documents in this library and the only reason you would search for it is because you want to edit the properties or something, so this is kind of a big deal.   What I am looking for is the best way to filter down the document library dynamically using OR statements and user input.   Any help would be greatly appreciated.

Details View Biding Custom Object with Enum properties fields

Hello, I'm trying to bind custom object to details view. The problem is that enum property fields are not show.Is there any way to show enum property fields in details view ?I put some example code below (I do not specify any rows mappings, they are generated dynamically because different kind of objects are bound to details view):// My object public class OrderItem { public ItemKindEnum unitemizedItemKind { get { return (ItemKindEnum)this.unitemizedItemKindID; } } ... } // Details view configuration <asp:DetailsView ID="dvOperationDetails" runat="server" DefaultMode="ReadOnly" ... />

Custom Fields not showing up in NewForm

Hello everybody,   I have got a very strange problem. I got two SP-Websites with several lists on them. Both have the same ContentTypes added (Standard CT is a Document-derived CT) however the 'Folder'-derived CT (including some additional fields like internal SAP numbers) is behaving differently in the lists. On the one List when I click on 'New Document'-'TestFolder' it is displaying all the added fields and in the other list it is only displaying the 'Name'-Field.   I have compared all the attributes of the Lists and also of the added Columen via Sharepoint Manager 2010 and found no differences whatsoever between them. It seems to be another problem caused by via Site-Template generated SP-Websites (including the libaries). When I create a new List on the Website and add the CT to the List all fields get displayed correctly? What could be the problem here with the Template-based lists?   Has anyone encountered the same problem once? Thank you for your help! Best regards, Martin

Problem with Update of Sharepoint Taxonomy Fields in custom developed Content Types

Dear all, we developed an solution on sharepoint 2010 for one of our customers with custom lists and content types with fields from the managed meta data store. As recommended we developed everything in features & solutions so that easy deployment is possible. Adding metadata to the termstore seems to work without problems, but today we stepped over an confusing issue: Our customer changed the default label of an term in the metadata term store, but the label did not change in listviews and detailviews of items in the specific sitecollection. In editview we see the correct label. After searching a while we discovered the connection between the sitecollection and the term store, the hidden Taxonomylist (/Lists/TaxonomyHiddenList/AllItems.aspx) in the sitecollection, which seems to map the terms. After testing we discovered that the term/label did also not change in the hidden taxonomy list. The Timerjob “Taxonomy Update Scheduler“ is running hourly with success and we also tried to start the job manually, but the label did not change in the hidden list. Also there are no errors in the logfiles in verbose mode. We also tested to create a managed metadata field manually, put it in a list and after that, changed the label. For whatever reason the update of labels on manually created fields works without a problem. Our lists, content types etc get created pr
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