Expand my Community achievements bar.

SOLVED

Drop Down for data from schema in WebApp in Adobe campaign classic

Avatar

Level 3

Hi All,

 

I have a schema where I keep product name, product code and product expiry. I am creating a webapp wherein I want to show these three values in the WebApp as dropdowns with data retrieved from the schema. There are about 5000 records in the schema. The values selected in the webapp will be used to update  cs:customerOrder schema.

 

Kindly suggest how can I use webapp to present dropdown of data from a particular schema.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

If by dropdown you mean, an actual dropdownlist like the example below, for performance reasons, i dont recommend this, nor will it be possible to scroll down 5000 items.

David__Garcia_0-1646062524765.png

Depending on your webapp activity version, if you are developing it using v5 activity, there is an object that allows you to generate a table of rows containing records from the output of a query, and the table data xpath allows you to configure this.

David__Garcia_2-1646062733295.png

 

David__Garcia_1-1646062692723.png

 

In the new version is all done through code here is an example.

 

David__Garcia_3-1646063066967.png

 

David__Garcia_4-1646063090871.png

 

View solution in original post

4 Replies

Avatar

Employee Advisor

I would just use vanilla JS for the drop down, and tie that back to a variable that will execute the query. 

Avatar

Level 3

HI,

 

Thank you for your reply. Can you please let me know any tutorial or code on how to include Vanilla JS for dropdown in webapp and tie it back to a query

Avatar

Correct answer by
Community Advisor

If by dropdown you mean, an actual dropdownlist like the example below, for performance reasons, i dont recommend this, nor will it be possible to scroll down 5000 items.

David__Garcia_0-1646062524765.png

Depending on your webapp activity version, if you are developing it using v5 activity, there is an object that allows you to generate a table of rows containing records from the output of a query, and the table data xpath allows you to configure this.

David__Garcia_2-1646062733295.png

 

David__Garcia_1-1646062692723.png

 

In the new version is all done through code here is an example.

 

David__Garcia_3-1646063066967.png

 

David__Garcia_4-1646063090871.png

 

Avatar

Administrator

Hi @bhaskarc1289447,

Was this solution helpful to resolve your query or do you still need more help here? Do let us know.

Thanks!



Sukrity Wadhwa