Hi,
is there any way to add the same Quick Link to multiple users? Thanks
*This post is locked for comments
Thank You!!
Linda,
You can run the following SQL query to copy all Quick Links from one user to another:
USE DYNAMICS GO DELETE FROM dbo.SY08140 WHERE USERID = '<Destination_USERID>'; INSERT INTO dbo.SY08140 (USERID ,SEQNUMBR ,TYPEID ,CmdID ,CmdFormID ,CmdDictID ,DSPLNAME ,ScbTargetStringOne ,ScbTargetStringTwo ,ScbTargetStringThree ,ScbTargetLongOne ,ScbTargetLongTwo ,ScbTargetLongThree ,ScbTargetLongFour ,ScbTargetLongFive) SELECT '<Destination_USERID' ,SEQNUMBR ,TYPEID ,CmdID ,CmdFormID ,CmdDictID ,DSPLNAME ,ScbTargetStringOne ,ScbTargetStringTwo ,ScbTargetStringThree ,ScbTargetLongOne ,ScbTargetLongTwo ,ScbTargetLongThree ,ScbTargetLongFour ,ScbTargetLongFive FROM dbo.SY08140 WHERE USERID = '<Source_USERID>'; GO
If you are needing to transfer just one Quick Link out of many from one user to another, that becomes a bit trickier because you will need to take into account the sequence number at the destination. It would be something like this:
INSERT INTO dbo.SY08140 (USERID ,SEQNUMBR ,TYPEID ,CmdID ,CmdFormID ,CmdDictID ,DSPLNAME ,ScbTargetStringOne ,ScbTargetStringTwo ,ScbTargetStringThree ,ScbTargetLongOne ,ScbTargetLongTwo ,ScbTargetLongThree ,ScbTargetLongFour ,ScbTargetLongFive) SELECT '<Destination_USERID>' ,(SELECT MAX(SEQNUMBR) + 1 FROM SY08140 WHERE USERID = '<Destination_USERID>') ,TYPEID ,CmdID ,CmdFormID ,CmdDictID ,DSPLNAME ,ScbTargetStringOne ,ScbTargetStringTwo ,ScbTargetStringThree ,ScbTargetLongOne ,ScbTargetLongTwo ,ScbTargetLongThree ,ScbTargetLongFour ,ScbTargetLongFive FROM dbo.SY08140 WHERE USERID = '<Source_USERID>' and SEQNUMBR = 8; GO
In the above example, I am copying just the entry corresponding to Sequence Number 8 from the source user ID to the destination user ID. You also don't want to run a delete for all the destination user entries as this would, well, remove all Quick Links.
Yes, it is. you can copy from one User to another User using PSTL
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,188 Super User 2024 Season 2
Martin Dráb 230,030 Most Valuable Professional
nmaenpaa 101,156