Get the account information for composite amendment, via ZOQL

[Goutham]

Problem

Using the ZOQL Export API to get a list of recent amendments, and also the account they are associated with. 
However, for cancellation and composite amendments, I cannot get the account Id/name, or subscription id/name.

Is there any way to get the account information from a cancellation/composite amendment, via ZOQL?

[Goutham · Accepted solution]

Solution

As part of the Order Metrics migration, a new Amendment Type of "Composite" will appear in the Subscription to represent the Subscription creation.

The below ZOQL query will fetch the Account and Amendment type detail

"select SubscriptionVersionAmendment.type, SubscriptionVersionAmendment.ID, SubscriptionVersionAmendment.code,
Account.AccountNumber from Subscription"

Where the SubscriptionVersionAmendment.type provides the cancellation/composite type for an amendment.