issue with task report trying to display data

garym over 8 years ago

Hi,
I was wondering if anyone has encountered this before. I have a task report and I am getting the error below. I have included a snippet of the a!gridTextColumn statements. The first column that displays the "Org Id" works fine. In the next column, I am trying to apply a rule that will get the Org Name from the Org Id.
Not sure why it doesn't like it.

Could not display interface. Please check definition and inputs.
Interface Definition: Expression evaluation error in rule 'rct_getorgnamebyorgid': The load function cannot be used within rules called by looping functions. Instead, pass the necessary variables via rule inputs or use a!applyComponents.

a!gridTextColumn(
label: "Org Id",
field : "c13",
data: index(local!filteredTaskReport.data,"c13",{}),
links : apply(rule!RCT_createRecordLinkMPSelfCert,index(local!filteredTaskReport.data,"c13",{}))
),
a!gridTextColumn(
...

Discussion posts and replies are publicly visible

0 garym over 8 years ago

...label:"Org Name",
field: "c13",
data: apply(rule!RCT_getOrgNamebyOrgId,index(local!filteredTaskReport.data,"c13",{}))
),
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ram
Certified Lead Developer
over 8 years ago

Hi Gary,

I think there a load() function inside rule!RCT_getOrgNamebyOrgId() which you are using in a fn!apply() function.
Due to this you are getting the error. Do have any necessacity of load() function inside rule!RCT_getOrgNamebyOrgId() if not try to remove it or else make all local variable calculations outside the rule!RCT_getOrgNamebyOrgId() rule and pass them as inputs. I hope this will help you
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 madhanka
A Score Level 1
over 8 years ago

In addition to akkramanir's suggestion, you can also try using with() instead of load().
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ram
Certified Lead Developer
over 8 years ago

Adding to the above comment try replacing load() function with with() or you can replace fn!apply() with a!applyComponents()
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 garym over 8 years ago

Thanks @akkramanir @madhanka...There was no load() function used in the rule!RCT_getOrgNamebyOrgId(). However, I did replace fn!apply() with a!applyComponents() and it worked. Thanks so much for all your help!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 garym over 8 years ago

Sorry, there was a load() function used in the rule so you were right @akkramanir :)... I was looking at the wrong rule. So that explains everything. Thanks again
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 garym over 8 years ago

Now I noticed that in the grid, the Org Name column does not refresh when I click to go to the next set of entries. I have a paging size of 25. The Org Id column changes when going to the next 25 records but the Org Name remains the same as it was on the first page.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel