1 Reply Latest reply on Feb 2, 2017 5:47 AM by wernerbj

    count recurring svc subscr of employee

    wernerbj Apprentice

      Hi,

       

      I Need your help.

      I am trying to implement an Expression, which Counts a specific number of Service subscriptions.

      I Need to know, if the customer has an specific, active serviceSubscription or not.

      I tried the following:

       

      $(FindAncestor("Employee",   "Frs_ITFM_Recurring_Service_Subscription",         [Employee#.SRAsscocCUSTOMEREmployee][Frs_ITFM_Recurring_Service_Subscription#.RecurringServiceSubscription]RecId      ,   '$((Status == "Active") && ([FRS_PriceItem#.PriceItem]ItemName == "Test"))'))

       

      The Problem is, that there is an 1 to many relation between Employee and RecurringServiceSubscription. So, the findAncestor function doesn't work.

       

      Do you have an idea?

       

      best regards

      Björn