Corporate Programming

  Connect-PnPOnline -Url "https://yourtenant.sharepoint.com/sites/YourSite" -Credentials ( Get-Credential ) # Get the site pages library $sitePagesLibrary = Get-PnPList -Identity "Site Pages" # Query for pages where "isincludeinnews" is "yes" $pagesToUpdate = Get-PnPListItem -List $sitePagesLibrary -Query "<View><Query><Where><Eq><FieldRef Name='isincludeinnews' /><Value Type='Boolean'>1</Value></Eq></Where></Query></View>" # Update the specific column for each page foreach ( $page in $pagesToUpdate ) { # Set the value of the target column (e.g., "YourTargetColumn") $page [ "YourTargetColumn" ] = $false # Set to false to match your condition $page .Update() } # Execute the changes Invoke-PnPQuery

  User Requirement Specification (URS) : Objective : Create an SPFx extension for news notifications on the home page. Scope : Display two types of news: “My News” (from an SQL table) and “Corporate News” (from a different site collection’s Site Pages library). Implement read/unread functionality (gray for read, yellow for unread). Mention the SharePoint list library names where you’ll store data (e.g., “My News” and “Corporate News”). Technical Specifications : Use SPFx framework, React, and REST API for SharePoint data retrieval. Integrate with SQL data using a console application. Specify the SharePoint lists and SQL tables you’ll interact with. Commercial Terms : N/A (since it’s an internal project). Functional Specification (FS) : Design and Construction : SPFx web part layout: Top right corner of the home page. UI design: Display news items with read/unread indicators. Functional Requirements : Fetch data from SQL table and SharePoint list. Implement read/unread logic. Handle dis