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
7 replies
Subscribers
6 subscribers
Views
6414 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
Appned single quotes('') to the cdt value
nikitar890
Certified Associate Developer
over 8 years ago
I have a process where I get data from data base, I want all the values in the database to be between single quotes(''). Eg:- cdt:{name:xyz,phone:12345}, I want it to be {name:'xyz',phone:'12345'}. Instead of mapping it filed by field, Is there a way that I pass the cdt and all the values in the CDT get inserted between '' ?
Thanks in Advance,
Nikita.
OriginalPostID-268937
Discussion posts and replies are publicly visible
Parents
0
Durgesh
A Score Level 2
over 8 years ago
AFAIK, There is no in-built function to append single quotes for all the CDT parameters. You can create one expression rule & pass CDT value as a input. In the rule, you can apply logic of appending single quotes to all the parameters. then return the CDT (You have to explicitly cast it to CDT Type while returning) to the caller. This expression rule you can call in apply() function for CDT array (for all the rows of a database). You need to make sure that if there are different data type CDT parameters then cast them to string before appending the single quotes. You can try this and let us know if that works for you.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Durgesh
A Score Level 2
over 8 years ago
AFAIK, There is no in-built function to append single quotes for all the CDT parameters. You can create one expression rule & pass CDT value as a input. In the rule, you can apply logic of appending single quotes to all the parameters. then return the CDT (You have to explicitly cast it to CDT Type while returning) to the caller. This expression rule you can call in apply() function for CDT array (for all the rows of a database). You need to make sure that if there are different data type CDT parameters then cast them to string before appending the single quotes. You can try this and let us know if that works for you.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data