you guys know anyway to get generic inquiry formula value? used mapping table to map fields to a gi, works for single data like AccountCD, however for formulas like =Concat([OrganizationBAccount.AcctCD],'-',[Account.AccountCD]), it returns null. is there a way to get gi values for such formulas and assign them to variables?
Solved
how to get generic inquiry formula value in BLC?
Best answer by mohammadabujaffar21
using ‘((Dictionary<string, object>)row.Values["GenericResult"])[formulaKey].ToString()’ with formula key being genericinquiry.objectname_formula(genericinquiry.rowid), seems to work.
I’ve had a similar experience when I needed to get a complex formula value from a Generic Inquiry.
The value was calculated using another GI and several tables.
I tried running that GI in the code and then retrieving the value of the required field from the GI result.
I reference the field using the formula itself, as it is stored in the corresponding database field.(GIResult table).
Regards,
Vard
using ‘((Dictionary<string, object>)row.Values["GenericResult"])[formulaKey].ToString()’ with formula key being genericinquiry.objectname_formula(genericinquiry.rowid), seems to work.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.