Hi all, we are already defining a expression rule by using a doforeach ex

natasav over 9 years ago

Hi all,
we are already defining a expression rule by using a doforeach expresion. Now we need to redefine it because tis plug is deprecated.
By simple changing it with apply () it does not work.
Could somebody help me with redefinition on it.
Here is the rule:

=if(count(rule!Display_Harm_Details_CDT(pv!ContractDetails.Contract_Serial_Number))," Contract Harmonization History: "&ncolumntablestyled( "CCCCCC","FFFFFF", "FFFFFF", {"Version","Harmonization Members","Folder"},rule!ListofVersion_CR(pv!ContractDetails.Contract_Serial_Number),doforeach("AllHarmonizationMembesforVersion",pv!ContractDetails.Contract_Serial_Number,rule!ListofVersion_CR(pv!ContractDetails.Contract_Serial_Number)),doforeach("rule!LinktofolderfromfolderID",pv!ContractDetails.Contract_Serial_Number,rule!ListofVersion_CR(pv!ContractDetails.Contract_Serial_Number))),"")
The problem is when rule!ListofVersion_CR(pv!ContractDetails.Contract_Serial_Number) ret...

Discussion posts and replies are publicly visible

Parents

0 PhilB
A Score Level 1
over 9 years ago

I guess you're trying to create a table with a row per list of version_CR? If that's the case, try the below.

=if(
 count(rule!Display_Harm_Details_CDT(pv!ContractDetails.Contract_Serial_Number)),
 " Contract Harmonization History: "&ncolumntablestyled(
 "CCCCCC",
 "FFFFFF",
 "FFFFFF",
 {"Version","Harmonization Members","Folder"},
 rule!ListofVersion_CR(pv!ContractDetails.Contract_Serial_Number),
 apply(
 rule!AllHarmonizationMembesforVersion,
 with(
 local!harmListofVersion_CR: rule!ListofVersion_CR(
 pv!ContractDetails.Contract_Serial_Number
 ),
 merge(
 repeat(
 length(local!harmListofVersion_CR),
 pv!ContractDetails.Contract_Serial_Number
 ),
 local!harmListofVersion_CR
 )
 )
 ),
 apply(
 rule!LinktofolderfromfolderID,
 with(
 local!linkListofVersion_CR: rule!ListofVersion_CR(
 pv!ContractDetails.Contract_Serial_Number
 ),
 merge(
 repeat(
 length(local!linkListofVersion_CR),
 pv!ContractDetails.Contract_Serial_Number
 ),
 local!linkListofVersion_CR
 )
 )
 )
 ),
 ""
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 PhilB
A Score Level 1
over 9 years ago

I guess you're trying to create a table with a row per list of version_CR? If that's the case, try the below.

=if(
 count(rule!Display_Harm_Details_CDT(pv!ContractDetails.Contract_Serial_Number)),
 " Contract Harmonization History: "&ncolumntablestyled(
 "CCCCCC",
 "FFFFFF",
 "FFFFFF",
 {"Version","Harmonization Members","Folder"},
 rule!ListofVersion_CR(pv!ContractDetails.Contract_Serial_Number),
 apply(
 rule!AllHarmonizationMembesforVersion,
 with(
 local!harmListofVersion_CR: rule!ListofVersion_CR(
 pv!ContractDetails.Contract_Serial_Number
 ),
 merge(
 repeat(
 length(local!harmListofVersion_CR),
 pv!ContractDetails.Contract_Serial_Number
 ),
 local!harmListofVersion_CR
 )
 )
 ),
 apply(
 rule!LinktofolderfromfolderID,
 with(
 local!linkListofVersion_CR: rule!ListofVersion_CR(
 pv!ContractDetails.Contract_Serial_Number
 ),
 merge(
 repeat(
 length(local!linkListofVersion_CR),
 pv!ContractDetails.Contract_Serial_Number
 ),
 local!linkListofVersion_CR
 )
 )
 )
 ),
 ""
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data