Skip to Content
avatar image
Former Member

Filter Standard BO List on AdvancedListPane in EC

Feb 07, 2018 at 10:55 AM | 110 Views | Last edit Feb 12, 2018 at 11:09 PM 3 rev.

Hi Experts,

The requirement is to filter List of Involved Parties of ServiceRequest( Ticket ) based on RoleCode, for instance, we should not display Party with RoleCode = "1001" (Account).

So,firstly, we added EC to Involved Parties tab of Service->Ticket.The next,it was added AdvancedListPane with DataList binded to Party node of ServiceRequest BO.

Then the Query was created with ResultList DataStructure binded to ServiceRequest BO and as Selected Query Parameter was chosen the PartyRoleCode of ServiceRequest->QueryByElements.

Finally, DefaultSet select options for Query Parameter PartyRoleCode defined as contains patttern *1001*.

However, the List of Involved Parties is not displayed, and query does not work.

Can you suggest any way to filter displayed Involved Parties List?

query.png (54.8 kB)
datamodelbinding.png (76.1 kB)
defaultset.png (28.8 kB)
advanceslistpane.png (11.0 kB)
defaultset.png (25.5 kB)
SAP Cloud for Customer
SAP Cloud Applications Studio | query | ec | servicerequest | involved party | sa
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Marlos Augustus Maciel Damasceno
    Feb 07, 2018 at 12:54 PM

    Hi Olena,

    Where you used include in your query, try to use exclude instead. As you said in your question, you "should not display Party with RoleCode = "1001"". Moreover, you only need to use the Low Value of the query, that maybe is influencing your results.

    Best regards

    Marlos Damasceno

    Add comment
    10|10000 characters needed characters exceeded

    • Marlos Augustus Maciel Damasceno
      Feb 08, 2018 at 12:31 PM

      Hi Olena,

      You may first check if the bind of your Root in the Data Model is correct direct to the Root of the Service Request. After that, check if your Default DataSet is getting triggered when you initialize the EC. For that you may use the events in your Inport in the Controller, RequestAutoRefire and RequestFireOnInitialization equals to true. That can call a Event Handler to execute your DataSet.

      Best regards

      Marlos Damasceno