Friday, November 1, 2013

Create multiple external lists with associations in SharePoint 2013, Create Custom Action in ECB (Edit Control Block) in External List in SharePoint 2013

http://code.msdn.microsoft.com/office/SharePoint-2013-Create-2d2ec458
http://msdn.microsoft.com/en-us/library/dn135194.aspx

More about filter Property: FilterField1, FilterType1, FilterValue1, FilterOperator1, Filter1ChainingOperator
http://msdn.microsoft.com/en-us/library/aa981241(v=office.14).aspx 

vs2012->file->new->project c# ->office/SharePoint->apps->apps for SharePoint 2013-> "BCSODataWAssociatedLists"
 
Click on 'Validate' button 
BCSODataWAssociatedLists -> right click -> add -> select 'Content Types for External Data Source..'
-> http://services.odata.org/Northwind/Northwind.svc
-> CannedDataService
Click on 'Next'
Make sure select below check box
Now click on 'Finish'

BCSODataWAssociatedLists -> External Content Types -> CannedDataService -> Exployees.ect -> right click -> open with -> 
 -> Source Code (Text Editor) -> Click on 'Ok'

Go to line number 509 and press enter and copy the below code (or) paste below code after </Methods> tag and before </Entity>
Note: This field 'City' should be exits in two lists Customers & Employees
-----------------------------------------------------------------------------------------------------------
          <Actions>
            <Action Position="1" IsOpenedInNewWindow="false" Url="~site/Lists/Customers/ReadAllCustomer.aspx?FilterField1=City&amp;FilterValue1={0}" Name="Customers for Employee">
              <ActionParameters>
                <ActionParameter Index="0" Name="City"></ActionParameter>
              </ActionParameters>
            </Action>
          </Actions>
-----------------------------------------------------------------------------------------------------------
BCSODataWAssociatedLists -> doubel click 'AppManifest.xml'
Change the value of start page: BCSODataWAssociatedLists/Lists/Employees
BCSODataWAssociatedLists -> Deploy
Click on 'Customers for Employee' tab

Thank You

No comments:

Post a Comment

Featured Post

Protect an API by using OAuth 2.0 with Azure Active Directory and API Management

Protect an API by using OAuth 2.0 with Azure Active Directory and API Management https://docs.microsoft.com/en-us/azure/api-management/api-...

Popular posts