You’re offline. This is a read only version of the page.
2,990
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:
Share
Report
All responses (
Answers (
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,188
Super User 2024 Season 2
#2
Martin Dráb
230,030
Most Valuable Professional
#3
nmaenpaa
101,156