Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Preloading from Custom Schema

Avatar

Avatar
Give back 300
Community Advisor
Manoj_Kumar_
Community Advisor

Likes

176 likes

Total Posts

371 posts

Correct reply

125 solutions
Top badges earned
Give back 300
Give Back 200
Give Back 100
Give Back 50
Give Back 25
View profile

Avatar
Give back 300
Community Advisor
Manoj_Kumar_
Community Advisor

Likes

176 likes

Total Posts

371 posts

Correct reply

125 solutions
Top badges earned
Give back 300
Give Back 200
Give Back 100
Give Back 50
Give Back 25
View profile
Manoj_Kumar_
Community Advisor

18-05-2020

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.

4 Comments

Avatar

Avatar
Contributor 2
Community Advisor
Marcel_Szimonisz
Community Advisor

Likes

120 likes

Total Posts

253 posts

Correct reply

63 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile

Avatar
Contributor 2
Community Advisor
Marcel_Szimonisz
Community Advisor

Likes

120 likes

Total Posts

253 posts

Correct reply

63 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
Marcel_Szimonisz
Community Advisor

20-05-2020

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

Avatar
Give back 300
Community Advisor
Manoj_Kumar_
Community Advisor

Likes

176 likes

Total Posts

371 posts

Correct reply

125 solutions
Top badges earned
Give back 300
Give Back 200
Give Back 100
Give Back 50
Give Back 25
View profile

Avatar
Give back 300
Community Advisor
Manoj_Kumar_
Community Advisor

Likes

176 likes

Total Posts

371 posts

Correct reply

125 solutions
Top badges earned
Give back 300
Give Back 200
Give Back 100
Give Back 50
Give Back 25
View profile
Manoj_Kumar_
Community Advisor

20-05-2020

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

Avatar
Contributor 2
Community Advisor
Marcel_Szimonisz
Community Advisor

Likes

120 likes

Total Posts

253 posts

Correct reply

63 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile

Avatar
Contributor 2
Community Advisor
Marcel_Szimonisz
Community Advisor

Likes

120 likes

Total Posts

253 posts

Correct reply

63 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
Marcel_Szimonisz
Community Advisor

20-05-2020

@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

Avatar
Affirm 25
Level 6
LaurentLam
Level 6

Likes

78 likes

Total Posts

103 posts

Correct reply

24 solutions
Top badges earned
Affirm 25
Boost 50
Boost 25
Give Back 50
Affirm 10
View profile

Avatar
Affirm 25
Level 6
LaurentLam
Level 6

Likes

78 likes

Total Posts

103 posts

Correct reply

24 solutions
Top badges earned
Affirm 25
Boost 50
Boost 25
Give Back 50
Affirm 10
View profile
LaurentLam
Level 6

28-05-2021

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" ^^