Expand my Community achievements bar.

SOLVED

Update statement in Query service SQL

Avatar

Level 2

Hi All,

 

Is query service supports the Update statement??

Can we update a particular column value on some filter criteria by using an update statement?

 

Thanks

Gouri Raula

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

@gugun  It is not possible to update a column using query service.

not sure on the use case you are referring, but using AJO  --> update profile .It is possible to update profile attribute. check out https://experienceleague.adobe.com/docs/journey-optimizer/using/orchestrate-journeys/about-journey-b... 

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

@gugun  It is not possible to update a column using query service.

not sure on the use case you are referring, but using AJO  --> update profile .It is possible to update profile attribute. check out https://experienceleague.adobe.com/docs/journey-optimizer/using/orchestrate-journeys/about-journey-b...