20488 - Questions and Answers

Q - How do perform a "join" operation on data from multiple lists?

A - There are several ways to join results from 2 lists straight "out of the box"

https://sharepoint.stackexchange.com/questions/89597/creating-view-from-multiple-list-in-sharepoint-2013-out-of-box

https://support.office.com/en-gb/article/Display-data-from-multiple-lists-with-the-Content-Query-Web-Part-d560f477-8fc1-4258-aeb2-70aa932e07da


https://support.office.com/en-us/article/Display-data-from-multiple-sources-in-a-single-Data-View-f9898d20-a5ab-4973-9d16-9f4e4c088ae1


A quick search will generate lots of hits. Some better references are shown here

http://ignatiuz.com/blog/how-to-link-two-lists-and-create-a-combined-view-in-sharepoint-2013/

https://www.youtube.com/watch?v=bvzKtwn6v6M

http://www.macaalay.com/2013/12/17/join-two-sharepoint-lists-together-by-id/

You can also use your own application for the caching and business logic

For simple operations, with low volume you could use Powershell or VBA and Access/Excel

SSRS is another approach where you can offload this to the Reporting layer.  You can install SQL with Sharepoint integration

For large data sets it may be more efficient to port the data to SQL (securely) and perform the join there.


Q - How do I integrate different electronic forms on Sharepoint?
A - If you have digital signatures in Adobe and use Infopath forms for some of the data entry..

There are several approaches:
- Server Side Code
- File print to PDF
- Use the Adobe SDK
http://www.adobe.com/devnet/pdf/library.html

- Use and integration tool

https://www.mulesoft.com/exchange?gclid=CJDspKSEhNUCFQUMaQodHGsMYw#!/microsoft-sharepoint-2013-integration-connector

https://www.scribesoft.com/products/scribe-insight/


Ahmedur Rab (1:53 PM): when to use sync and async loading?

A - these 2 articles answer this.  Generally we use async when we are waiting for info e.g. data retrieval in javascript

https://www.codeproject.com/Articles/738008/Programming-Efficiently-with-the-SharePoint-Client

Call Load and ExecuteQuery Before Accessing Value Properties

Q - How do you perform a Query with REST?

A - See the PPT share here

Module 3 - Lists with REST API

See Lab 7 here



Robert Robnett (2:27 PM): Do you have any good use example sites for Angularjs and SharePoint ?
Derek So'Brien (2:28 PM): I have lots of references for Angularjs.  not with SP tho - lemme look
Derek So'Brien (2:29 PM): Yep - here you go
Derek So'Brien (2:30 PM): https://www.safaribooksonline.com/library/view/programming-microsoft-office/9781509300938/
Derek So'Brien (2:30 PM): https://www.safaribooksonline.com/library/view/visual-intelligence-microsoft/9781118417522/
Derek So'Brien (2:30 PM): https://www.safaribooksonline.com/library/view/javascript-for-net/9781785886461/
Derek So'Brien (2:30 PM): https://www.safaribooksonline.com/library/view/pro-html5-with/9781484224632/
Derek So'Brien (2:31 PM): just create a 10 day trial to access the whole thing..
Derek So'Brien (2:31 PM): .. you should get partial access just with the links
Robert Robnett (2:32 PM): thank you
Derek So'Brien (3:07 PM): Let's make this Lab time
Derek So'Brien (3:08 PM): You can contact me at derricksobrien@hotmail.com
Derek So'Brien (3:08 PM): or...   derrick.sobrien@gmail.com


Reference for WWF
https://www.safaribooksonline.com/library/view/microsoft-windows-workflow/9780735623354/ch01s05.html