Extract Subscription id from Event xml field | Community
Skip to main content
Venu_Reddy
Venu_Reddy
Level 6
March 20, 2019

Extract Subscription id from Event xml field

  • March 20, 2019
  • 1 reply
  • 8210 views

I tried to extract subscription id from the field event xml(ctx) in the schema trackingLogEventHisto which is of type mdata by using the source expression 'Node value' and getting below error:

QUE-370015 The node of path '/ctx' is not stored as an independent SQL field (document of type 'Archived events (****)'). Unable to use it as a filtering criteria in a query.

Is there any other way to fetch the subscription id by using java script or other.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    Venu_Reddy
    Venu_ReddyAuthor
    Level 6
    March 28, 2019

    Hello Team,

    Just following up on this. Can we use Nodevalue() function to extract the data from xml attribute ?

    Can you please provide a sample code if we can able to extract using JavaScript (or) is there any other way to get the subscription id from the schema nmstrackingLogEventHisto

    wodnicki​

    florentlb​

    Ananya Kuthiala​

    Adhiyan​

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity Advisor
    Community Advisor
    April 1, 2019

    Hi,

    Requests are stored in nms:eventHisto.

    Can you paste the code you're using and the field you're trying to parse out?

    Thanks,

    -Jon

      Jonathon_wodnicki
      Community Advisor
      Jonathon_wodnickiCommunity Advisor
      Community Advisor
      April 30, 2019

      Hi All,

      Can anyone please provide a sample javascript which will extract the data (eg. say Subscriptionid) from the attribue (event/ctx) of type mdata in the schema nms:eventHisto.

      Any other ways to extract data from an xml attribute would be appreciated.

      Regards,

      Venu


      Hi,

      Use e4x to parse the xml returned out of query results, for field 'data':

      var data = new XML(res.data + '');

      From there it's ordinary xml object:

      data.@subscriptionId, etc.

      Thanks,

      -Jon

        Terms & ConditionsAccessibility statement

        Loading footer...