get readonlyGrid Fv! data outside gridcolumn()

Certified Senior Developer

Hi,

I have the following scenario:

Take a shopping cart. I have three tables: cartdetails which has foreign key productsId from product table, product table  which has categoryId from category table.

the grid data is -> cartdetails and columns are ->   srno| category name| category type| category data| productname| product price| product data| quantity| totalprice

Now in the grid i can call a rule to fetch the required data as:

1. call getcategorydata()-> for  category name| category type| category data

2. call getproductdata()-> for productname| product price| product data

Instead of calling the rule again and again for the three columns each, i want to call it once per row. So im trying to use localvariables. 

But the data that i can use is only fv!currentpage outside the gridcolumn() . so i tried doing fv!currentpage.data.productid. This is giving me the whole array of products. I want to index this to only get the individual row's productid.

Idk if i explained it properly, 

Thank youin advance

 

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data