Skip to main content

Make selection in a table and transfer selected data without using Boolean checkbox component of VBCS.

 

Introduction:

Generally, to transfer the selected data from one variable to another over selection we will be using Boolean check box. Can we achieve it without that? Let’s see.

Main Article:

Lets drop a table component to the designer section and assign an SDP to the table.

In this case the SDP I’ve used is from the Business object.


Make the selection mode as multiple as below:


Now let’s create another table in the same page of type ADP which holds the data that is selected from the previous table and let’s have a button action which refresh the ADP table on click action performed over it.

Now the web page will look something like this.


Logic:

Click on the SDP table and select On ‘select Multiple rows event’ and follow the below steps:

·       Call the REST connection using which the data had been populated in the SDP table

·       On success, reset the ADP variable of below table

·       Drop a for each action and iterate over the keys.

 


·       Inside the loop use firedataprovider action with add action.

·       Now set the mapping as below

{

 "data": "{{ $chain.results.callRestGetallTest.body.items[$current.data] }}",

 "keys": [

  "{{ $current.data }}"

 ]

}


·       Map the ADP variable in the target section




The final flow should look like below:


·       Now refresh the ADP using the fire data provider on Button click event.

That’s it the logic is now complete.

Lets test the web app:


As you could see the selected ones from the SDP got successfully inserted to ADP table.


-Preetham Konjeti














Comments

Popular posts from this blog

Backup Integrations of an Instance with a single click using OIC

  Introduction One common mistake that most of OICS developers make is not taking the backup of their integrations religiously and if they want to take backups clicking on the export of the integrations individually could be quite tedious. Main Article In this blog I will be explaining about automating the backup process in OICS. Below is the order of the steps that are to be followed: STEP:1 1) Configure a Rest trigger connection as shown below. Provide the below payload in the request section:     {   "IntegrationName”: "" } STEP:2   Configure the new rest connection as mentioned below. (This basically list downs all the integration details as per the provided name).   Provide the Query parameters as below:   Provide the response payload as below: {   "hasMore" : "false",   "items" : [ {     "id" : "",     "name" : "",     "lockedFlag" : &quo

Deploy all integrations to new environment with a single click using OIC

 

Implement While loop in XSLT of OICS

Introduction: In the XSLT mapper of OICS by default we don't have the while loop to implement, but there can be a situation where we need to implement while , when such situation shows up how to implement it? Main Article: In the above XML, the filename is static....say we need to populate the same field with 5 file names in a single shot in other words to bring dynamism to the Code we have to use loop. Lets do it using While loop. But in XSLT we don't have while loop by default, then how can we achieve this? Just like functions in any other languages we have a thing called 'Template' in XML. Using this we can achieve the while loop. 1) In the above code, match='/'  indicates the default template to be called , In this case the default templated calls the ' customWhile ' template which we had created with parameter 1 as the input. 2) Once the template is called in the very first step as check would be performed to check the input param falls in our desir