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
5 replies
Subscribers
7 subscribers
Views
1963 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Hi all, I have CDT where one of the parameter in it's fiels name have &
natasav
over 11 years ago
Hi all,
I have CDT where one of the parameter in it's fiels name have "-". Now when I use expression ( query ) rule to read data from it ( previously I save data using it in SQL without Problem.So is there any recommended way to redefine it and replace "-" with"_" let's say. I have this issue on Production Server so I must keep all data that are saved in SQL.
BR,Natasa ...
OriginalPostID-49396
OriginalPostID-49396
Discussion posts and replies are publicly visible
0
Bishnu Panigrahi
Appian Employee
over 11 years ago
Here's one method: You can create an expression rule using the substitute function: substitute(ri!string,"-","_")
Then after querying the database and saving the result into a pv!, you can use the apply function to change the hashes to underscores: apply(rule!ruleName,pv!cdtName.strings)
forum.appian.com/.../Text_Functions
forum.appian.com/.../Looping_Functions
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
natasav
over 11 years ago
Sorry I can not find apply expression. Let me say what I did maybe I did not understand you correctly or maybe I did not explain my problem correctly.
I have following rule create (or when I try to created it);
= rule!ContractTypeDetails2 ( ri!Company ) [ lookup ( rule!ContractTypeDetails2 ( ri!Company ) .TypeName , ri!typename , 1 ) ] .Signatory-Level1
where ContractTypeDetails2 is the query rule.
But when I even try to test it before even save it following error appear:
The rule contains an expression that cannot be tested:
!isignatory, !level1
I create new rule as you suggested :
SubsistuteUnsupportedsymbols and redefine the rule but same problem.
= rule!ContractTypeDetails2 ( ri!Company ) [ lookup ( rule!ContractTypeDetails2 ( ri!Company ) .TypeName , ri!typename , 1 ) ] .SubsistuteUnsupportedsymbols(ISignatory-Level1)
Any new ideas or suggestions.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
natasav
over 11 years ago
I just sow. Apply() is new expression function implemented in Appian 6.7 and I still have Appian 6.6.0. Am I right? Any other suggestion?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
stacey.wright
over 11 years ago
Have you tried putting your field within single quotes?:
rule!ContractTypeDetails2 ( ri!Company ) [ 1 ] .'Signatory-Level1'
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
stacey.wright
over 11 years ago
Also, can you give me the output of one object if you do not get this sub-attribute? So, just the following?:
rule!ContractTypeDetails2 ( ri!Company ) [ 1 ]
I'd like to see if it gets returned as Signatory-Level1; I'm assuming it does.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel