Site & Object Model Architecture

SharePoint Object Model Architecture

Infopath Custom Date Validation

Custom Date Pattern:

Type1:
^((((19|20)(([02468][048])|([13579][26]))-02-29))|((20[0-9][0-9])|(19[0-9][0-9]))-((((0[1-9])|(1[0-2]))-((0[1-9])|(1\d)|(2[0-8])))|((((0[13578])|(1[02]))-31)|(((0[1,3-9])|(1[0-2]))-(29|30)))))

Type2:
\d{4}-\d{1,2}-\d{1,2}

A correlated subquery is an inner subquery which is referenced by the main outer query such that the inner query is considered as being executed repeatedly.

Example:
----Example of Correlated Subqueries
USE AdventureWorks;
GO
SELECT e.EmployeeID
FROM HumanResources.Employee e
WHERE e.ContactID IN
(
SELECT c.ContactID
FROM Person.Contact c
WHERE MONTH(c.ModifiedDate) = MONTH(e.ModifiedDate)
)
GO

Here e.ModifiedDate-->Outer Query field refers in Inner Query.

A noncorrelated subquery is subquery that is independent of the outer query and it can executed on its own without relying on main outer query.

Example:
----Example of Noncorrelated Subqueries
USE AdventureWorks;
GO
SELECT e.EmployeeID
FROM HumanResources.Employee e
WHERE e.ContactID IN
(
SELECT c.ContactID
FROM Person.Contact c
WHERE c.Title = 'Mr.'
)
GO

Here 'Mr.'--->Outer Query field doesn't refers in Inner Query.

How to assign String Values in CAML Query

string pname = TxtProjectName.Text;

query.Query = "<Where><Eq><FieldRef Name=\"ProjectName\"/><Value Type=\"Text\">" + pname + "</Value></Eq></Where>";

SPListItemCollection myListcollection = myList.GetItems(query);