Hi all, I have CDT where one of the parameter in it's fiels name have &

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

Parents
  • 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.

Reply
  • 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.

Children
No Data