Recreate missing helperheadperson

Steve A. 1 day ago

Hello,

I have mess up by deleting some helperheadperson which should not be and result of missing ability to see some persons on the portal from some manager. (it's not prod)

Is there a way to rebuild the missing lines of helperheadperson for direct manager like a store procedure or something like that ?

Top Replies

Markus Weiss-Ehlers 17 hours ago +1 verified
Yes, there is.

You can trigger the recalculation of the HelperHeadPerson table for all persons using the following SQL.
```
declare @GenProcID varchar(38) = newid()
exec QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate…
```

Parents

+1 Markus Weiss-Ehlers 17 hours ago
Yes, there is.

You can trigger the recalculation of the HelperHeadPerson table for all persons using the following SQL.

declare @GenProcID varchar(38) = newid() exec QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate', 'QER-K-HelperHeadPerson', null, @GenprocID
Cancel
Up +1 Down

Reply

Reject Answer

Cancel
0 Steve A. 13 hours ago in reply to Markus Weiss-Ehlers

Thank you Markus !

I was expecting an answer from you and it does exactly what we expected. Thanks !
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Reply

0 Steve A. 13 hours ago in reply to Markus Weiss-Ehlers

Thank you Markus !

I was expecting an answer from you and it does exactly what we expected. Thanks !
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Children

No Data