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


Post New Web Links

How to join two sharepoint list in c# by CAML query?

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint
 
Hii All,
 
   I am using wss 3.0 and i have one site and site has 4 to 5 lists. lists are interconnected with lookup column and same column. I need to display some column fron one list and some from another.. i need to join that lists by where condition like project =project..

So how can i join??



Thank You
Dips
Patel


View Complete Post


More Related Resource Links

Cross list query for two sharepoint lists and a join between the fields

  
Hello All, I have a requirement where i need to query the data from two  sharepoint lists  on a same site by doing a join between those lists and get the result into datatable.I am doing this using sharepoint object model.Is there any possibility to do this. Any pointers in the right direction are greatly appreciated. Thank you Smith   smith

Caml Query to fetch the data from Sharepoint List for a specific date.

  

Hello,

I have a sharepoint list with one of hte columns being Created Date of Type DateTime and value allowed is OnlyDate.

The submitted date in my column is 05/18/2011. When I perform a search using the below CAML query, it does not give any results though I have two items with this date.

<Where><Eq><FieldRef Name='Date_x0020_Created' /><Value Type='DateTime'>5/18/2011</Value></Eq></Where>

I dont understand what is wrong with this query. Someone please help


Janaki Thakur

Video: SharePoint 2010 Lists, List Data, and CAML

  
This demonstration illustrates how to work with list data and the Collaborative Application Markup Language (CAML). (Length: 5:05)

Query Sharepoint list, rich text columns returning HTML tags

  
Hi! So I have an issue that maybe someone of you have encountered as well. I am querying a Sharepoint list and creating a report from the data collected from this list. This all works fine except that one of the columns in this list is of the type "Multiple lines of text" and also supports "rich text" with different fonts, sizes and so on. This has the effect that the text returned from this column is wrapped in HTML tags that specifies how the text should be formatted. Naturally I do not want this HTML code to appear in my report so for now I have used custom code to do a string.replace and replaced for example <div></div> and <br> with "". However, this column also has url references to documents and these links shows up like this "/servername/site/subsite/Gemensamma%20dokument/Mwh.docx">http://servername/site/subsite/Gemensamma%20dokument/Mwh.docx There is some sort of double reference to the document that I guess like the HTML tags are embedded in the answer from the rich text column and this is not so easy to do a string replace on because the url varies with the different document and document names. My question really is if anyone of you have done a similar report that I am doing, and have encountered this fenomen with this sharepoint column and how you did to solve this? I have tried to creat

get sharepoint list item column choices using caml

  
basicallly the title says it all, is there a way to get a sharepoint list's column's choices using CAML query? i'm trying to get the choices using the sharepoint web service

CAML query on external list is not working

  
Hi, I have an external list, display data from SQLServer 2008. Table on SQL have an UniqueIdentifire (GUID) type column as a Primary key. It also has one identifier column, Its value is increased by 1, as the item is created. In share point server side code, I want to fetch single record against the primary key GUID value. I write down the CAML query on GUID column and run without any error. But all the external list data is returned instead of Single list item. I also try to filter on Auto Incremented column, but same problem is occurred.

CAML query to access List data across multiple site collection.

  
Hi   Is there any way to get the Task List data across multiple site collection using CAML query. Currently, I have the code which will retrieve the data from a single site collection. Below is the code.                           /***************************************************I am using Moss2007.Thanks!Ravi             SPSiteDataQuery q = new SPSiteDataQuery();             q.ViewFields = "<FieldRef Name=\"Title\" />" "<FieldRef Name=\"Status\" Nullable=\"TRUE\"/>";             q.Lists = "<Lists ServerTemplate=\"107\"/>";             q.Webs = "<Webs Scope=\"SiteCollection\"/>";             q.Query = "<Where>" +                                "<Eq>" +                                     "<FieldRef Name=\"Status\" />" + "<Value Type=\"Choice\">Not  Started</Value>" +                                     "</Eq>" +                         "</Where>";             DataTable dt=null;             using (SPSite s = new SPSite("http://banglabguest1:31000/"))             {                 SPWeb w = s.OpenWeb();                 dt = w.GetSiteData(q);                 w = null;             }                              *************************

SharePoint List Query Filter

  

I am writting an SSRS report where I am querying a SharePoint list and trying to filter the data through the CAML query.  In BIDS, the query returns data, but the filter where clause doesn't seem to be getting recognized as I get all of the data back.  The where clause does seems to work in the U2U CAML Query Builder tool.

Can anyone please give advice as to why my where clause isn't working?

http://<<servername>>/BI/_vti_bin/Lists.asmx

<Query>
   <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
   <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
      <Parameters>
         <Parameter Name="listName">
                   <DefaultValue>Subscribe - Sales by Product Group - Wheel</DefaultValue>
         </Parameter>
      </Parameters>
   </Method>

SSIS SharePoint List Adapter - how to query Users & Groups?

  

I am using SSIS SharePoint List Adapter to load data in and out of my SharePoint Lists from within SSIS, and most of it is working fine.  However, I need to perform a lookup against the Users & Groups collection in SharePoint so I can retrieve the UserID and set the value when writing back to SharePoint.  Any help would be tremendously appreciated!

Thanks.


Fetching Task List for the logged in User with LINQ/CAML/SQL query

  

Hi All,

We have some workflows which are been created already. The tasks are been assigned to users for their approval. Now, when the approver logs in it should display the Tasks List which are belonging to that particular user only. OR if the normal user logs inn, it should display Tasks belonging to that User only. A web part should display this. Pls. note that I have to show the Tasks from both "Workflow Task" & "Task".

The Task list should come from across site collections of a Web Application.

Hence,The Scopen should be WebApplication.
How do I achieve the same? Need help ASAP.

Thnx,

Alex


alex

Task List for the logged in User with LINQ/CAML/SQL query

  

Hi All,

We have some workflows which are been created already. The tasks are been assigned to users for their approval. Now, when the approver logs in it should display the Tasks List which are belonging to that particular user only. OR if the normal user logs inn, it should display Tasks belonging to that User only. A web part should display this. Pls. note that I have to show the Tasks from both "Workflow Task" & "Task".

The Task list should come from across site collections of a Web Application.

Hence,The Scopen should be WebApplication.
How do I achieve the same? Need help ASAP.

Thnx,

Alex


alex

Fetching Task List for the logged in User with LINQ/CAML/SQL query

  

Hi All,

We have some workflows which are been created already. The tasks are been assigned to users for their approval. Now, when the approver logs in it should display the Tasks List which are belonging to that particular user only. OR if the normal user logs inn, it should display Tasks belonging to that User only. A web part should display this. Pls. note that I have to show the Tasks from both "Workflow Task" & "Task".

The Task list should come from across site collections of a Web Application.

Hence,The Scopen should be WebApplication.
How do I achieve the same? Need help ASAP.

Thnx,

Alex


alex

display sharepoint list Data into content Query Web Part

  

Hi i have content query web part. now i want to show the sharepoint list data into my content query part

using CQWP setting, i am able to get only one column data but not all.

pls let me know how can i get all list data in different style format 


sharepoint List data not showing in content query web part

  

hi friends,

i am displaying data from sharepoint list into content query web part.

i have also mentioned column name in commonfield properties after exporting web part and save it.

but it is showing only two column name.

i have also inserted images url in sharepoint list, but i am not able to see images in CQWP.

ItemStyle.xsl

<xsl:template name="News" match="Row[@Style='News']" mode="itemstyle">
  <xsl:param name="CurPos" />
  <xsl:param name="LastRow" />
  <xsl:variable name="SafeLinkUrl">
    <xsl:call-template name="OuterTemplate.GetSafeLink">
      <xsl:with-param name="images" select="'@images'"/>
    </xsl:call-template>
  </xsl:variable>
  <xsl:variable name="SafeImageUrl">
    <xsl:call-template name="OuterTemplate.GetSafeStaticUrl">
      <xsl:with-param name="images" select="'@images'"/>
    </xsl:call-template>

CAML Query for ListItemCollection within a Folder ListItem in a List (Not "SPList")

  

Hey all,

 

I'm in the process of creating a Silverlight Application that needs to pull data from a SharePoint list.  Unfortunately, some of the data is within sub-folders, and calling the List.GetItems(CamlQuery) function is only returning the root level (no sub-folder content).

 

I noticed from searching around for the solution to this that an attribute exists for doing a recursive check, so all the list items could be returned, but all the times this solution is mentioned is in regards to getting an SPList and using an SPQuery. The SPQuery variable has a ViewAttributes property to do this, apparently, but I don't seem to have that specific of a choice with the CamlQuery variable type here.

 

Any help?


CAML Query for display Top n records in sharepoint 2010

  

Hi friends,

I have added the Content Query web part in my publishing page for displaying data from list.

Now i want to use additional filter option from content query web part.

pls tell me wht query i should write for returning Top n Records from list.

also pls tell me whole caml query format dat i need to put in custom value or query option in additional filter option in Content Query Web Part


caml query groupby Sharepoint 2010

  

Hi

I am trying to programmatically access data from a Sharepoint 2010 document library specifically these are promoted fields created by Infopath 2010 form using a CAML query. There is a condition in the where statement, a groupby is required and only want the column specified in the groupby to be returned.
As the are promoted fields from an infopath form I am using the internal name as well. I have three rows of data:
Year  Round Accepted (plus several more columns not relevant for this query)
2012  1     No
2012  2     No
2013  1     No
My expected results would be only two rows returned:
2012
2013
However, what is returned is 3 rows of data. What am I doing wrong? Any feedback or suggestions much appreciated.
2012
2012
2013

BTW I have tried using U2U CAML builder but there is no groupby.


SPList claimsList = claimsSite.Lists["Claims"];//get the library list of claims
SPField fldAccepted = claimsList.Fields["Accepted"];
string strAccepted = fldAccepted.InternalName;
SPField fldYear = claimsList.Fields["Year"];
string strYear = fldYear.InternalName;
SPField fldRound = claimsList.Fields["Round"];
string strRound = fldRound.InternalName;

Categories: 
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