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
  • 8220 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

      Venu_Reddy
      Venu_ReddyAuthor
      Level 6
      April 2, 2019

      Hi Jon,

      Thank you for the response.

      yes, i'm getting failed when i tried to extract any particular filed from the xml(event/ctx) attribute.

      Regards,

      Venu

      Terms & ConditionsAccessibility statement

      Loading footer...