Skip to Content
Introduction

Lately, I’ve had a few people ask about choosing multiple values for filtering within Visual Composer. This blog discusses the options for this.

The Scenario

There is no way to directly choose multiple values from a form box as the form element only stores a singular record per form field. Therefore, the focus of this blog discusses potential workarounds.

The Options
  • Use Value Help Wizard – By far, the easiest option is to use the value help wizard. This will generate a popup iView to choose your values as displayed below. To build this, just right click on a field in your form, and choose the value help wizard option.

    image

  • Use Table Element – In this case, you can use a multiselect table element instead of a form as input for your data service. In this example, I’m going to base it off a BI Query. To build this, you would follow these steps:
    1. Insert InfoObject Dataservice into your model.
    2. Connect output of infoobject dataservice to a table.
    3. Specify the selection mode of the table as “Multiple”.
    4. Connect the output of the table to the input of your BI Query Dataservice.
    5. Map the output of the table field to the input of your BI Dataservice.
    6. Create an output table from your BI Query to display your results.

    See the example below for selecting distribution channels. You can hold down the CTRL key to select multiple values. You have the option to put this table in a layer or a popup for preserving screen real-estate if need be.
    image

  • Use BI elements – Visual Composer doesn’t natively allow you to multiselect values in a dropdown within a form. To do this, you have to use another UI Elements. This how-to guide shows how to do it in VC: http://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/5a40f2f7-0c01-0010-d69f-c6317c5165cd. In this scenario, you can get an output such as displayed below:
    image
Summary

These are the options as of SPS9. Hopefully you find this useful.

To report this post you need to login first.

8 Comments

You must be Logged on to comment or reply to a post.

  1. Venkata Ramisetti
    Some time back I tried to achieve some what similar functionality. But I couldn’t find any solution for my requirement.
    My requirement was…The main iView contains a read only table with button(Something like GOTO POPUP IVIEW). When this button is clicked , the Popup iView appears with an editable table and  a button(ADD TO MAIN IVIEW TABLE). when user enters multiple records and clicks this button, then it should pull all entered records to the main iView table.
    I think this is workaround for my requirement. Thanks for sharing your experience.

    (0) 
    1. Mike Bell
      Does this example work ONLY with BI?
      I have an an alias pointing to R3 ECC5 data source.

      This example does not work .

      can you clarify?

      Thanks.

      (0) 
  2. Mike Bell
    Does this example work ONLY with BI?
    I have an an alias pointing to R3 ECC5 data source.

    This example does not work .

    can you clarify?

    Thanks.

    (0) 
  3. Naseer Mohammed
    Hi Prakash,

    I am having issue in selecting multiple rows. Whenever I do a multiselect, everything would be transferred to my previous iview except the first record.

    Could you tell me why ???

    (0) 
  4. Sonal Patel
    Hi,

    I m working on a Bi Query based iView. In your blog the steps mentioned in Option Use Table Element,
    i m not able to get any option to do this step
    1. Insert InfoObject Dataservice into your model, please reply…..

    (0) 

Leave a Reply