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

SQL field vs Non-SQL field

Avatar

Avatar
Validate 1
Level 3
jasonw30638826
Level 3

Likes

21 likes

Total Posts

47 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 3
jasonw30638826
Level 3

Likes

21 likes

Total Posts

47 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
jasonw30638826
Level 3

02-08-2019

Hi,

I understand that Non-SQL field can not be used for filtering or sorting. Can it be used as a condition in the workflow?  And adding Non-SQL doesn't need to modify the physical structure of the database. It seems this is a better way to add a field without breaking the recipient table.  Please advise what is the best practice to add fields.

Thanks,

Jason

Replies

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

958 likes

Total Posts

1,079 posts

Correct Reply

506 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

958 likes

Total Posts

1,079 posts

Correct Reply

506 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

05-08-2019

Hi,

Assuming 'Non-SQL' fields are xml calculated fields, those are just xml elements in the 'data' clob.

They can't really be used for much outside of payload, and so in nearly all cases you'll want to use ordinary sql columns, even the ones where the fields are payload.

Thanks,

-Jon

Avatar

Avatar
Validate 1
Level 3
jasonw30638826
Level 3

Likes

21 likes

Total Posts

47 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 3
jasonw30638826
Level 3

Likes

21 likes

Total Posts

47 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
jasonw30638826
Level 3

05-08-2019

Thank you Jon!