Niccolò
20 days agoNew Contributor
Table view service - get customSubstVars inside SaveTableView function
Hi, I need to use inside my Table View service some parameters that are bound to combo boxes in order to write a query, and execute it when the "SaveTableView" function is called. Unlike the "GetT...
- 20 days ago
Hi Niccolo,
i haven't found the solution but i use a workaround which might help you.
in my Get function i pick up the parameter and store it in my tableview on each row:
If args.CustSubstVarsAlreadyResolved.ContainsKey("prm_xxx") sEntity = args.CustSubstVarsAlreadyResolved("prm_xxx")
and i insert this in my datatable in the column ReportingEntity (in my case)
in my Save function i retrieve this value from the tableview again:
'get Entity from first tblView row sEntity = tblView.Rows(1).Item("ReportingEntity").value
and store it in the database in my SQL statement.
Hope this helps