MicroStrategy ONE

Alter Email Subscription statement

Modify the properties of a cache update subscription.

Copy 
ALTER EMAILSUBSCRIPTION (subscription_name[MANAGE ALL] | GUIDsubscription_GUID) [NAMEnew_subscription_name] [OWNERnew_login_name] [SCHEDULEnew_schedule_name]  [ADDRESSnew_address_name| USERnew_user 
 _name | CONTACTnew_contact_name [ADDRESSnew_contact_address_name] | CONTACTGROUPnew_contact_group_name] [CONTENT(new_report_or_document_name IN FOLDER new_location_name  | GUID 
 new_report_or_document_guid) [CONTENTTYPE (REPORT | DOCUMENT)]] IN PROJECTproject_name [DELIVERYFORMAT ((PLAINTEXT [TEXTDELIMITER (COMMA 
 | SPACE | TAB | SEMICOLON | COLON | OTHER custom_delimiter)] | EXCEL | CSV | FLASH | PDF) FILENAME new_file_name] | HTML)] [COMPRESSCONTENTS [PROTECTZIPFILE ZIPFILENAMEnew_zip_file_name ZIPFILEPASSWORDnew_zip_file_passwordEXPIRATIONDATEmm/dd/yyyy]] [SUBJECTnew_subject] [MESSAGEnew_message] [INCLUDELINK (TRUE | FALSE)] [HISTORYLINKWEBSERVERhistorylinkwebserver] [SENDPREVIEWNOW (TRUE | FALSE)] [SENDTOHISTORYLIST 
 (TRUE | FALSE)] [INCLUDEDATA (TRUE | FALSE)] [MODIFICATIONBYRECIPIENTS 
 (TRUE|FALSE)];

where:

  • subscription_name is the name of the subscription

  • subscription_GUID is the ID of the subscription

  • new_subscription_name is the new name of the subscription

  • new_login_name is the login name of the new owner of the subscription

  • new_schedule_name is the name of the new schedule

  • new_address_name is the name of the new address

  • new_user_name is the name of the new user

  • new_contact_name is the name of the new contact

  • new_contact_address_name is the name of the new contact address

  • new_contact_group_name is the name of the new contact group

  • new_report_or_document_name is the name of the new report or document

  • new_location_name is the name of the new folder where the report or document resides

  • new_report_or_document_guid is the GUID of the report or document

  • project_name is the name of the project where the report or document resides

  • custom_delimiter is the single character used as a custom text delimiter

  • new_file_name is the new name of the file

  • new_zip_file_name is the name of the new zip file (for compression purposes)

  • new_zip_file_password is the password for the new zip file

  • mm/dd/yyyy is the new expiration date of the zip file

  • new_subject is the new subject of the email

  • new_message is the new body message of the email

  • historylinkwebserver is the "base URL" to the new history list entry