Expand my Community achievements bar.

Preloading from Custom Schema

Avatar

Community Advisor

5/18/20

In the current setup, preloading activity available in Web Application preloads the data on the basis of encrypted identifier passed in the URL parameter.

It will be great to have an option to the preload the data from any selected schema and column while configuring the activity.

5 Comments

Avatar

Community Advisor

5/20/20

Hello @_Manoj_Kumar_ ,

You can create your own preloading activity from Java Script (Script activity) where you can use jsapi database calls such as queryDef, sqlSelect, sqlExec ...  and then store the data under ctx.recipient.@id, .... All OOTB activities will read it as you would use the Preloading activity, also you can display the information on page.

 

Marcel

Avatar

Community Advisor

5/20/20

Hello @Marcel_Szimonisz,

Yes, you are correct this is what we are using right now to preload users from custom schema. But it will be great if we can get that option to configure this in the preloading activity itself.

Avatar

Community Advisor

5/20/20

@_Manoj_Kumar_ 

I thought this was a question   I think they left behind the web app development so you need to workaround many things here. But yes it would be nice to choose the dimension in preload activity

Avatar

Level 6

5/28/21

carefull with SQLExec, SQLSelect, SQLGetDouble, etc
the scaling is better with queryDef as it goes through the normal query engine that will handle in a better way any locks on the tables

 

"SQL injection is evil" ^^

Avatar

Administrator

2/5/24

Hi @_Manoj_Kumar_,

Are you referring to web download workflow activity or transfer file workflow activity?  If you can then kindly provide a screenshot of the same.

Thanks!