BCS Limitations in SharePoint 2010

-
1. External Lists = No workflows
2. No information management policies
3. No version history
4. No Datasheet View
5. No Export to excel
6. No Rest calls using ListData.svc
7. No RSS feeds
8. No Item level permissions
9. No Lookup column
10. No Attachments

Comments

Post a Comment

Popular posts from this blog

Email Validation for SharePoint list column

-
Image
Please use the below formula in [Column validation] of the list column edit section. Please replace the [Email] with your column name. Formula: --------------------------------------------------------------------- =AND(     ISERROR(FIND(" ", [Email],1)),     IF(ISERROR(FIND("@", [Email],2)),         FALSE,         AND(             ISERROR(FIND("@",[Email], FIND("@", [Email],2)+1)),             IF(ISERROR(FIND(".", [Email], FIND("@", [Email],2)+2)),                 FALSE,                 FIND(".", [Email], FIND("@", [Email],2)+2) < LEN([Email])             )         )     ) ) ------------------------------------------------------------------------  
Read more

SP, UDF and VIEW

-
SPs are Databse subroutine used to perform tasks within the database, whether it be to INSERT, UPDATE, DELETE, SELECT, send return values, send output parameters, send e-mail, call command line arguments, encapsulate business logic, enforce data integrity, or any combination thereof. They are compiled when first run, and the query plans are stored and cached by SQL Server's optimizer, and those cached plans are swapped out depending on frequency of usage. View: • To hide the complexity of the underlying database schema, or customize the data and schema for a set of users. • To control access to rows and columns of data. • To aggregate data for performance. UDFS: Set of statements which must return an object considered as function. In general, UDFs can be a serious source of performance issues. Also, UDFs cannot be used for DML operations (INSERT/UPDATE/DELETE), cannot use non-deterministic functions, cannot use dynamic SQL, and cannot have error-handling (e.g. RAISERROR).
Read more

SharePoint Hand Book

-
In which server SharePoint solutions needs to be deployed? Add-SPSolution will move your solution to SP Admin database Install SP-Solution will create a timer job to push all feature files to 14/15 hive DLL's to GAC Web.Config changes etc to the Front end servers where you have "SP Web Application service" running. So it doesnot matter which server you are using to deploy your WSP. Since the solution functionalities will be always executed on your front end server, your app server doesnot need the WSP artifacts.
Read more