Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
1 reply
Subscribers
5 subscribers
Views
1290 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
Is it possible to get the 'Write to Data Store Entity' Smart Service to
agauzel
over 10 years ago
Is it possible to get the 'Write to Data Store Entity' Smart Service to save a null value instead of an empty string on an NVARCHAR field in the database?
When updating a row, I want to set all fields to null in the database table if there isn't a value in them. Date fields are correctly being set to null in the database. However, for text fields, they are being saved as empty strings in the table. Is there a way for force the Smart Service to save them as nulls? I've tried to explicitly specify "=null()" in the value, but that does not work either.
Thanks...
OriginalPostID-108559
OriginalPostID-108559
Discussion posts and replies are publicly visible
Parents
0
Brett Shomaker
Appian Employee
over 10 years ago
It's not currently possible. A null Text value is represented as empty text in Appian, and that is what is persisted.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Brett Shomaker
Appian Employee
over 10 years ago
It's not currently possible. A null Text value is represented as empty text in Appian, and that is what is persisted.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data