Grid Style Record List

I am trying to pull field attributes (supplier name) from supplier tables based on the foreign key (supplierId) in the entity that is referred in the record list using query rules. I assume that will be as easy as following snippet for the grid column.

if(rule!APN_isBlank(rf!supplierId), {},
index(rule!ICAMS_getSupplierById(id: rf!supplierId), "name", {}))

But I am not able to get the required output. Which will be filled Supplier Column

OriginalPostID-251925


Grid Record List Forum Question.pptx

  Discussion posts and replies are publicly visible