• State Suggested Answer
  • Locked Locked
  • Replies 7 replies
  • Answers 2 answers
  • Subscribers 95 subscribers
  • Views 6243 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Create Report Subscription script

piotr.markiewicz
over 7 years ago

Hello, 

I need to create the report subscriptions from script/process. 

I have a number of reports that are bundled as a standard package. All of them should be assigned to users automatically.
User can opt out from those subscriptions at any time. 

Is there any way to do this from script/process?

I've tried inserting records using object browser manually, the insert action is prevented (permission missing). 

If there is no out-of-the-box method, what records (in which tables) I should insert to create subscription manually?

 

Thanks, 
Piotr Markiewicz

Parents
  • 0 over 7 years ago

    Hi Trevor,

    I'm using version 7.1.1.

    I have the reports configured in RPSReport, user is assigned to the report directly (record in PersonHasRPSReport).

    I've tried inserting new row using Object browser, and this is the error I got:

    Report subscriptions: Write permission denied for values: ExportFormat,Ident_RPSSubscription,UID_DialogSchedule,UID_Person,UID_RPSReport.

     

    I've checked the permission on the column, and this is what I can see (on all 3 ref columns):

    I'm guessing that IT Shop is either using SQL or there is a method somewhere that creates the subscription. 

     

    Piotr

Reply
  • 0 over 7 years ago

    Hi Trevor,

    I'm using version 7.1.1.

    I have the reports configured in RPSReport, user is assigned to the report directly (record in PersonHasRPSReport).

    I've tried inserting new row using Object browser, and this is the error I got:

    Report subscriptions: Write permission denied for values: ExportFormat,Ident_RPSSubscription,UID_DialogSchedule,UID_Person,UID_RPSReport.

     

    I've checked the permission on the column, and this is what I can see (on all 3 ref columns):

    I'm guessing that IT Shop is either using SQL or there is a method somewhere that creates the subscription. 

     

    Piotr

Children
No Data