CRM and CX Blogs by SAP
Stay up-to-date on the latest developments and product news about intelligent customer experience and CRM technologies through blog posts from SAP experts.
Showing results for 
Search instead for 
Did you mean: 

My series of Cloud Application Studio Blogs

I am asked by colleague about how to develop two drop down list with dependency via Cloud application studio. Typical use case could be for example the first one gives user a list of countries in the world, and once a certain country code is selected, only the very states belonging to that country is listed in the second drop down list.

Here below is a kind of approach how to achieve it.

Suppose the first list is a set of programming language,

when I select ABAP, only ABAP tools are listed in the second list.

The same for Java List:

Before you start the development, make sure you have gone through the blog Create Dynamic Code List via Custom Business Object Association as this blog is written based on some enhancement on it.
1. The complete source code of JerryCodeList BO:

Create the following instance for this BO:

Language list:

Java tool list:

ABAP tool list:

2. In the MainBO on which the two dependent code lists are built, inserted the following highlighted source code:

Implement the association ToLanguageList in AfterModify determination:

if( !this.ToLanguageList.IsSet() ){
var codeListQuery = JerryCodeList.QueryByElements;
var para = codeListQuery.CreateSelectionParams();
para.Add( codeListQuery.CodeListBOID, "I", "EQ", "LANGUAGE");
var result = codeListQuery.Execute(para);
this.ToLanguageList = result.GetFirst();

For the other association ToLanguageToolList, we should NOT implement it in AfterModify since it is dependent on the selection of first drop down list.

3. Bind two drop down list accordingly:

The essential part here is: as long as there is selection change on the first drop down list, the notification must be sent to second drop down list to perform restriction on its entries. Here a new event handler is introduced for notification.

Create a new query bound to CodeList.QueryByElements with a query parameter which points to Code List entry's parent code:

then in the event handler, in the first operation I assign the selected language code chosen from first drop down list to the query parameter, then fire the query in the second operation, as a result the possible entries for the second drop down list are restricted by language code accordingly.