Sharepoint - Query Based Lookup Field Control

New Post: Does cascade work with Title column? Why have Title and Country & Title and City?

dmoss — Fri, 13 Nov 2009 20:25:38 GMT

I have not been able to get the cascade dropdowns to work. The sample list on http://datacogs.com/datablogs/archive/2007/08/26/641.aspx is duplicating the title field. For example

Countries
Title	Country
Austrialia	Australia
Germany	Germany

Is it required to do this?

If so, is it best to make country a formula and have it point to the title?

Created Issue: Parent / Child Fields Suddenly Not Working

mkrongard — Tue, 01 Sep 2009 19:45:55 GMT

I have been using the Parent / Child Drop Down field type for almost a year. Suddenly they don't work. I can create the column, but when I try to open a new list item, I get either an "Unknown Error Occurred" or "Field was not defined properly" errors. No errors in the event logs on any of the servers, and nothing has changed on any of the servers that I know. Anyone have any ideas? Microsoft's suggested fix was to remove the solution and try to reinstall it.

New Post: How do I edit the code in Visual Studio

maiden123 — Sat, 29 Aug 2009 07:45:53 GMT

MSDN has great stuff getting updated on weekly basis. SDk itself can cover almost 80% of sharepoint development plus the blogs and community content gives more information then you can gulp at a time.

New Post: How do I edit the code in Visual Studio

Nareshveeragoni — Fri, 28 Aug 2009 15:00:13 GMT

Hi maiden,

thanks for the suggestion. definitly the MSDN is a most reliable source for developing the applications, i was hoping there are some common steps in going forword with this specific code as many developers seems to be implementing it successfully and were able to make changes. i am sure there is no proper documentation for sharepoint development all we lke new to sharepoint have to depend up on the articles and blogs that are written by guys like you.. i just wish MSDN could explain the sharepoint development with good examples.. thanks anyways.

On Fri, Aug 28, 2009 at 12:19 AM, maiden123 <notifications@codeplex.com> wrote:

From: maiden123

Hi Naresh,
The spectrum of the statement "I am new to coding" seems to be relatively huge from the problems that you are facing. I guess, I, or for that matter any one, here is not taking any online taught courses for .NET/SharePoint Development.
Back then when i passed from college and was at your position, I only believed this one thing called MSDN for any MS based development.
I can tell you for sure that you'll atleast start off with your development refering MSDN.

2009/8/28 nareshveeragoni <notifications@codeplex.com>

From: nareshveeragoni

Hi,

I am new to coding. please give instructions as how can i edit the code. I have opened the project in visual studio 2008 and when i try to build the project intailly i got the error that reference to "CoolStuffs.Sharepoint.Constants" assembly is missing with a yellow icon on the reference. and all the errors related to the reference came up, i looked at this article http://davidhayden.com/blog/dave/archive/2008/01/29/VisualStudio2008ResolvingNamespacesRemovingUnusedUsingStatementsTip.aspx where i needed to use Ctl+Alt+O to remove that error and finally was able to successfully build the code.

now the issue is to deploy this solution. as i have visual studio 208 running on the development server i should be able to directly depoly this solution on to the development server, but i am completely helpless to get the proper instructions as to how do i proceed further and deploy the latest code file on to my develeopment server. please guide me in right directions. much appriciate your help. thanks.

Read the full discussion online.

To add a post to this discussion, reply to this email (CustomFieldControls@discussions.codeplex.com)

To start a new discussion for this project, email CustomFieldControls@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe or change your settings on codePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at codeplex.com

Read the full discussion online.

To add a post to this discussion, reply to this email (CustomFieldControls@discussions.codeplex.com)

To start a new discussion for this project, email CustomFieldControls@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on codePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at codeplex.com

New Post: How to create a site column from this field as a Feature

davidslot — Fri, 28 Aug 2009 13:00:24 GMT

Hi Maiden123,

Thanks for your quick response.

Too bad it can't be done in XML, but as you mentioned, there is a way to do it in the featurereceiver and create the field in code.
Even though XML would be a cleaner way, this will do the trick :)

Thanks again for your support!

Kind regards,

David

New Post: How do I edit the code in Visual Studio

maiden123 — Fri, 28 Aug 2009 07:19:03 GMT

Hi Naresh,
The spectrum of the statement "I am new to coding" seems to be relatively huge from the problems that you are facing. I guess, I, or for that matter any one, here is not taking any online taught courses for .NET/SharePoint Development.
Back then when i passed from college and was at your position, I only believed this one thing called MSDN for any MS based development.
I can tell you for sure that you'll atleast start off with your development refering MSDN.

2009/8/28 nareshveeragoni <notifications@codeplex.com>

From: nareshveeragoni

Hi,

I am new to coding. please give instructions as how can i edit the code. I have opened the project in visual studio 2008 and when i try to build the project intailly i got the error that reference to "CoolStuffs.Sharepoint.Constants" assembly is missing with a yellow icon on the reference. and all the errors related to the reference came up, i looked at this article http://davidhayden.com/blog/dave/archive/2008/01/29/VisualStudio2008ResolvingNamespacesRemovingUnusedUsingStatementsTip.aspx where i needed to use Ctl+Alt+O to remove that error and finally was able to successfully build the code.

now the issue is to deploy this solution. as i have visual studio 208 running on the development server i should be able to directly depoly this solution on to the development server, but i am completely helpless to get the proper instructions as to how do i proceed further and deploy the latest code file on to my develeopment server. please guide me in right directions. much appriciate your help. thanks.

Read the full discussion online.

To add a post to this discussion, reply to this email (CustomFieldControls@discussions.codeplex.com)

To start a new discussion for this project, email CustomFieldControls@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe or change your settings on codePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at codeplex.com

New Post: How do I edit the code in Visual Studio

nareshveeragoni — Fri, 28 Aug 2009 05:38:28 GMT

Hi,

I am new to coding. please give instructions as how can i edit the code. I have opened the project in visual studio 2008 and when i try to build the project intailly i got the error that reference to "CoolStuffs.Sharepoint.Constants" assembly is missing with a yellow icon on the reference. and all the errors related to the reference came up, i looked at this article http://davidhayden.com/blog/dave/archive/2008/01/29/VisualStudio2008ResolvingNamespacesRemovingUnusedUsingStatementsTip.aspx where i needed to use Ctl+Alt+O to remove that error and finally was able to successfully build the code.

now the issue is to deploy this solution. as i have visual studio 208 running on the development server i should be able to directly depoly this solution on to the development server, but i am completely helpless to get the proper instructions as to how do i proceed further and deploy the latest code file on to my develeopment server. please guide me in right directions. much appriciate your help. thanks.

New Post: How to create a site column from this field as a Feature

maiden123 — Wed, 26 Aug 2009 06:22:17 GMT

I fear it seems there is no default CAml way of provisiong fields with data in its reference fields. the querybased lookup field for e.g. needs 6 metadata fields to work right, like siteurl, listurl, displaycolumntext, displaycolumnvalue, camlquery,sqlquery. There is no way in MOSS (not that i or many other MVPs that i've questioned this know of apparantly) to set these metatfields in features <Fields> element.
Believe me, i was the first one to worry about this when i made the field. you can get to MS technet team to see if there is some workaround or not.
though you can use object model in featurereciever. but XML... i am not sure of

2009/8/25 davidslot <notifications@codeplex.com>

From: davidslot

Hi maiden123 / pankajdarure,

Any news on this one?

These fields seem really handy, but as long as they can't be created using caml (the way described above), they won't be really useful in site provisioning or feature scenarios.

Don't get me wrong.. your work is really appreciated. The functionality of these fields is great, exactly what is missing from the standard MOSS fields.

Looking forward to your response.

Greetings,

David

Read the full discussion online.

To add a post to this discussion, reply to this email (CustomFieldControls@discussions.codeplex.com)

To start a new discussion for this project, email CustomFieldControls@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe or change your settings on codePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at codeplex.com

New Post: How to create a site column from this field as a Feature

davidslot — Tue, 25 Aug 2009 20:47:31 GMT

Hi maiden123 / pankajdarure,

Any news on this one?

These fields seem really handy, but as long as they can't be created using caml (the way described above), they won't be really useful in site provisioning or feature scenarios.

Don't get me wrong.. your work is really appreciated. The functionality of these fields is great, exactly what is missing from the standard MOSS fields.

Looking forward to your response.

Greetings,

David

Commented Issue: Cascading Dropdown Not loading when i have more than one dependent dropdown in a list

PoonamThawani — Mon, 17 Aug 2009 20:13:00 GMT

Hi,
I am having Employee Contact Information List.In that i have to capture Permanent address and temporary address. For Permanent address i have used one Parent Dropdown list to load State and one Child Dropdown list to load city based on state. Same i have to do for temporary address. If i use the another Parent and child dropdown list its not loading.
Can anyone provide me a solution?
Thanks in advance,
Shyamala
Comments: ** Comment from web user: PoonamThawani **

I have seen similar issue none of the custom controls- Datacogs dropdownlist or Sharepoint Query based lookup fields controls work when muliple instances of the control are added to same list.
Any solution on this will be appreciated???

Thanks,
Poonam

New Post: cascading dropdowns

maiden123 — Thu, 13 Aug 2009 03:40:51 GMT

Couple of hours on custom fields section of WSS SDK would be enough to start off. You'd basically know what a custom field control in Sharepoint is all about and what are the major classes controls required for a simple/basic custom field

2009/8/12 elwise <notifications@codeplex.com>

From: elwise

thanks for you reply.

like I said, I'm new to sharepoint and I'm not familiar at all with customization, although I'm a C# developer myself....

for what you are saying it seems to be an easy change then? could you be a bit more specific in to what needs to be changed?

thanks

Read the full discussion online.

To add a post to this discussion, reply to this email (CustomFieldControls@discussions.codeplex.com)

To start a new discussion for this project, email CustomFieldControls@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe or change your settings on codePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at codeplex.com

New Post: cascading dropdowns

elwise — Wed, 12 Aug 2009 11:14:24 GMT

thanks for you reply.

like I said, I'm new to sharepoint and I'm not familiar at all with customization, although I'm a C# developer myself....

for what you are saying it seems to be an easy change then? could you be a bit more specific in to what needs to be changed?

thanks

New Post: cascading dropdowns

maiden123 — Wed, 12 Aug 2009 08:43:11 GMT

its the same fundamental code with change in logic and control getting rendered in FieldController. whats the catch?? i am getting you

2009/8/11 elwise <notifications@codeplex.com>

From: elwise

Hi,

I'm new to sharepoint and have a question about your cascading dropdowns you describe in this article:

http://www.codeplex.com/CustomFieldControls

I installed it from http://blog.12thwave.com/?p=7 and it works perfectly.

Now my question is, how easy would be to alter your code so the last dropdown is not a dropdown but a textfield. Basically what I want to achieve is that once all the previous dropdowns have been selected, we get a textbox at the end with a summary text. This summary text would be definied in the list of the last dropdown.

Thanks in advance

Read the full discussion online.

To add a post to this discussion, reply to this email (CustomFieldControls@discussions.codeplex.com)

To start a new discussion for this project, email CustomFieldControls@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe or change your settings on codePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at codeplex.com

New Post: cascading dropdowns

elwise — Tue, 11 Aug 2009 13:20:52 GMT

Hi,

I'm new to sharepoint and have a question about your cascading dropdowns you describe in this article:

http://www.codeplex.com/CustomFieldControls

I installed it from http://blog.12thwave.com/?p=7 and it works perfectly.

Now my question is, how easy would be to alter your code so the last dropdown is not a dropdown but a textfield. Basically what I want to achieve is that once all the previous dropdowns have been selected, we get a textbox at the end with a summary text. This summary text would be definied in the list of the last dropdown.

Thanks in advance

New Post: Alphabitical Sorting for the Cascaded Dropdown

maiden123 — Sat, 08 Aug 2009 04:14:44 GMT

you can do these changes in parent dropdown's CreateChildControls() you'll find thedrop-downs databinding lines in the end in if(!listNotFound) block

New Post: Alphabitical Sorting for the Cascaded Dropdown

nareshveeragoni — Thu, 06 Aug 2009 22:49:53 GMT

Hi, its a great job, saved lot of time. really appricate the effort.

If we add the list items randomly to the child dropdown lookup list and wanted the child drop down to display the values in a alphabitical sorted order even though the items in the look up list are added not in a alphabitical order, what modifications does it need. please advice me the changes that needs in the source code. if we get an other relsease with this Fix that would be wonderfull. Thanks much.

New Post: Error after export

maiden123 — Thu, 09 Jul 2009 05:37:36 GMT

you'll have to edit the fields settings again and populate the SiteName reference with current Site. In Edit you'll find that the Site Name is still hardcoded with older Url

so if you made the field earlier in a site:
http://localhost:2341/

after migrating yo a new site, say http://localhost:4351, you still get older Url in SiteUrl custom property

you need to change this.
you can edit the code to take relative Urls if you know the reference would always be from the curernt site only.

2009/7/7 noche <notifications@codeplex.com>

From: noche

Hello,

I have an error after exporting the site with a cmp. The site has a different name.

The list elements that contains this query columns stay filled but the cascading columns (parent and children) are empty.

Moreover it is impossible to open column parent settings. i get this error :

La référence d'objet n'est pas définie à une instance d'un objet.   à CoolStuffs.Sharepoint.CustomFields.CascadingDropDowns.FieldControllers.ParentDropDownListFieldEditControl.InitializeWithField(SPField field)
   à Microsoft.SharePoint.ApplicationPages.FieldCustomizationPage.OnLoad(EventArgs e)
   à Microsoft.SharePoint.ApplicationPages.FieldEditPage.OnLoad(EventArgs e)
   à System.Web.UI.Control.LoadRecursive()
   à System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

How can i do to avoid this error during a site export?

Thanks by advance for any idea.

Noche

Read the full discussion online.

To add a post to this discussion, reply to this email (CustomFieldControls@discussions.codeplex.com)

To start a new discussion for this project, email CustomFieldControls@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe or change your settings on codePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at codeplex.com

New Post: Error after export

noche — Tue, 07 Jul 2009 17:06:41 GMT

Hello,

I have an error after exporting the site with a cmp. The site has a different name.

The list elements that contains this query columns stay filled but the cascading columns (parent and children) are empty.

Moreover it is impossible to open column parent settings. i get this error :

La référence d'objet n'est pas définie à une instance d'un objet.   à CoolStuffs.Sharepoint.CustomFields.CascadingDropDowns.FieldControllers.ParentDropDownListFieldEditControl.InitializeWithField(SPField field)
   à Microsoft.SharePoint.ApplicationPages.FieldCustomizationPage.OnLoad(EventArgs e)
   à Microsoft.SharePoint.ApplicationPages.FieldEditPage.OnLoad(EventArgs e)
   à System.Web.UI.Control.LoadRecursive()
   à System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

How can i do to avoid this error during a site export?

Thanks by advance for any idea.

Noche

New Post: Can we respect the required attribute?

JMah — Tue, 30 Jun 2009 06:40:37 GMT

I'm using the parent-child fields.

One of the thing I would like to see is if the field is not required have the list display a (none) or a blank value.

New Post: Cannot have multiple items selected in a DropDownList

joeldhall — Fri, 26 Jun 2009 14:54:51 GMT

I was getting this error after I created a Parent column, then click back to edit the column properties. To fix it I had to modify the source code and before every call to FindByValue or FindByText I had to call ClearSelection. That fixed the issue for me. See a blog post about this here: http://geekswithblogs.net/ranganh/archive/2006/05/03/77072.aspx