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
BedrockMission!

Learn More

View all

Sign in to view all badges

Preloading from Custom Schema

Avatar

Avatar
Affirm 100
MVP
_Manoj_Kumar
MVP

Likes

115 likes

Total Posts

327 posts

Correct Reply

100 solutions
Top badges earned
Affirm 100
Validate 1
Contributor
Ignite 1
Shape 1
View profile

Avatar
Affirm 100
MVP
_Manoj_Kumar
MVP

Likes

115 likes

Total Posts

327 posts

Correct Reply

100 solutions
Top badges earned
Affirm 100
Validate 1
Contributor
Ignite 1
Shape 1
View profile
_Manoj_Kumar
MVP

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
Springboard
MVP
MarcelSzimonisz
MVP

Likes

102 likes

Total Posts

225 posts

Correct Reply

56 solutions
Top badges earned
Springboard
Establish
Contributor
Give Back 25
Give Back 10
View profile

Avatar
Springboard
MVP
MarcelSzimonisz
MVP

Likes

102 likes

Total Posts

225 posts

Correct Reply

56 solutions
Top badges earned
Springboard
Establish
Contributor
Give Back 25
Give Back 10
View profile
MarcelSzimonisz
MVP

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
Affirm 100
MVP
_Manoj_Kumar
MVP

Likes

115 likes

Total Posts

327 posts

Correct Reply

100 solutions
Top badges earned
Affirm 100
Validate 1
Contributor
Ignite 1
Shape 1
View profile

Avatar
Affirm 100
MVP
_Manoj_Kumar
MVP

Likes

115 likes

Total Posts

327 posts

Correct Reply

100 solutions
Top badges earned
Affirm 100
Validate 1
Contributor
Ignite 1
Shape 1
View profile
_Manoj_Kumar
MVP

20-05-2020

Hello @MarcelSzimonisz,

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
Springboard
MVP
MarcelSzimonisz
MVP

Likes

102 likes

Total Posts

225 posts

Correct Reply

56 solutions
Top badges earned
Springboard
Establish
Contributor
Give Back 25
Give Back 10
View profile

Avatar
Springboard
MVP
MarcelSzimonisz
MVP

Likes

102 likes

Total Posts

225 posts

Correct Reply

56 solutions
Top badges earned
Springboard
Establish
Contributor
Give Back 25
Give Back 10
View profile
MarcelSzimonisz
MVP

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 5
Level 3
LaurentLam
Level 3

Likes

18 likes

Total Posts

57 posts

Correct Reply

6 solutions
Top badges earned
Affirm 5
Boost 10
Contributor
Applaud 5
Affirm 3
View profile

Avatar
Affirm 5
Level 3
LaurentLam
Level 3

Likes

18 likes

Total Posts

57 posts

Correct Reply

6 solutions
Top badges earned
Affirm 5
Boost 10
Contributor
Applaud 5
Affirm 3
View profile
LaurentLam
Level 3

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