Grid Style Record List

saileshd over 8 years ago

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

Grid Record List Forum Question.pptx

Discussion posts and replies are publicly visible

0 shamec over 8 years ago

Can you paste an example output of your rule rule!ICAMS_getSupplierById(id: rf!supplierId)?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tyler Criste
Appian Employee
over 8 years ago

Hey Sailesh!

I think you approach can work, but it would result in a query (to get supplier) once every row in the list, which would likely hurt performance.

I would recommend creating a view that joins to the supplier table and then using that in your record. The view would include a supplier name field.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tyler Criste
Appian Employee
over 8 years ago

Oh and for your issue, make sure that _getSupplierById returns a supplier and not a datasubset. If it's a datasubset you would need to do index(rule!ICAMS_getSupplierById(id: rf!supplierId).data, "name", {}))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 saileshd over 8 years ago

Thanks Shamec and Tyler, got my mistake! the field is supplierName as opposed to name... Yes the rule returns a supplier and not dataset :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 shamec over 8 years ago

OK good
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel