KB213168: How to create a procedure to get expiration date of a subscription in MicroStrategy Analytics Command Manager 9.4.1

This document instructs how to create a procedure via Command Manager to get expiration date of a subscription. Follow steps are performed with Tutorial project:
 

• In Command Manager menu bar, choose File -> New Procedure.

• In the newly launched procedure window, under Test Connection tab, fill in the project source information and click Connect.

• Define the procedure with scripts below:
   
  

  
  ResultSet list=executeCapture("LIST ALL PROPERTIES FOR SUBSCRIPTION GUID A3F7968A40E0357E302001B940118B99 FOR PROJECT 'Strategy Tutorial';");
  
      list.moveFirst();
  
      ResultSet oResultSetSubProps = (ResultSet)list.getResultCell(SUBSCRIPTION_RESULT_SET).getValue();
  
      oResultSetSubProps.moveFirst();
  
      String subscriptionType=oResultSetSubProps.getFieldValueString(DisplayPropertyEnum.EXPIRATIONDATE);
  
      printOut(subscriptionType);
  

  
   
  
• Run procedure. Notice the expiration date is returned.