Monday, 9 June 2025

User 1 has not site compare to user 2

 SELECT Site_Location 

FROM tbl_Users 

WHERE User_ID = 'sboissinot' 

AND Site_Location NOT IN (

    SELECT Site_Location 

    FROM tbl_Users 

    WHERE User_ID = 'swoodhouse'

)


Tuesday, 20 May 2025

angular material

   setTimeout(() => {

          this.dsSupportingDoc.paginator = this.paginatorSDoc;
        }); for paginator issue.

Saturday, 17 May 2025

Dropdown in excell

 today i made dropdown list in excel sheet using data visualastion u can create dropdown
unser Data > datavisualtion > select List  after list dropdown selection below click on textbox
then select data which exixst in other sheet click enter then it will convert to dropdown



Friday, 16 May 2025

Must c

 https://jscrambler.com/blog/how-to-protect-angular-code-against-theft-and-reverse-engineering?

Best ui design