How to refresh the list attached to the List Record widget in a web app?

I am getting the below error when I tried ajax refreshing the list record widget after assigning the new values to the list record variable that is attached to the List Record widget.

"OSADMIN_DEV1"."OSUSR_HM0_DEVICEGR" with key 0 was not found
   at ssCA_SurveyTool.ExtendedActions.GetDeviceGroup(HeContext heContext, Int64 inParamId, RCDeviceGroupRecord& outParamRecord)
   at ssCA_SurveyTool.Functions.ssGetDeviceGroup(HeContext heContext, Int64 inParamId)
   at ssCA_SurveyTool.Flows.FlowMainFlow.ScrnCampaignsList.expression32()
   at ASP.campaignslist_aspx.__DataBind__control144(Object sender, EventArgs e)
   at System.Web.UI.Control.OnDataBinding(EventArgs e)
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at OutSystems.HubEdition.WebWidgets.PlaceHolder.DataBindChildren()
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at OutSystems.HubEdition.WebWidgets.PlaceHolder.DataBind()
   at OutSystems.HubEdition.WebWidgets.Container.DataBindChildren()
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at OutSystems.HubEdition.WebWidgets.Container.DataBind()
   at OutSystems.HubEdition.WebWidgets.Container.DataBindChildren()
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at OutSystems.HubEdition.WebWidgets.Container.DataBind()
   at OutSystems.HubEdition.WebWidgets.Container.DataBindChildren()
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at OutSystems.HubEdition.WebWidgets.Container.DataBind()
   at OutSystems.HubEdition.WebWidgets.Container.DataBindChildren()
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at OutSystems.HubEdition.WebWidgets.Container.DataBind()
   at OutSystems.HubEdition.WebWidgets.OSUserControl.DataBindChildren()
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at OutSystems.HubEdition.WebWidgets.OSUserControl.DataBind()
   at OutSystems.HubEdition.WebWidgets.RepeaterItem.DataBind()
   at OutSystems.HubEdition.WebWidgets.Iterator.CreateItem(Object current, Int32 i, Boolean doDatabind)
   at OutSystems.HubEdition.WebWidgets.Iterator.OnDataBinding(EventArgs e)
   at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   at OutSystems.HubEdition.WebWidgets.Iterator.DataBind()
   at OutSystems.HubEdition.WebWidgets.OSPageViewState.AjaxRefresh(Control c, Int32 rowIndex, String animationName, String listOperation, Boolean isTableRecord, Object dataItem, StoreViewStateDelegate storeViewStateDelegate, String clientIdOverride)
   at OutSystems.HubEdition.WebWidgets.OSPageViewState.AjaxRefresh(Control c, Int32 rowIndex, String animationName, String listOperation, Boolean isTableRecord, Object dataItem, StoreViewStateDelegate storeViewStateDelegate)
   at OutSystems.HubEdition.WebWidgets.OSPageViewState.AjaxRefresh(Control c, String animationName, StoreViewStateDelegate storeViewStateDelegate)
   at ssCA_SurveyTool.Flows.FlowMainFlow.ScrnCampaignsList.CommandViewCampaign(HeContext heContext, Int64 inParamCampaignId2)


Please help me resolve this issue. Thanks in advance.

Hi,


Its really helpful when asking for help to provide more than just the error message. Ideally, provide a sample application showing your issue. At the very least, screenshots of your flow.


in your case, the error message indicates that you have a data issue. It is either trying to query the data using an invalid identifier or more likely, not assigning the ID field

Hi Paramasivam K,

I'm able to reproduce your issue, this error comes when you have queried from database and trying to access details in it even the query result is empty.

In your case you have query to retrieve data from OSUSR_HM0_DEVICEGR, your trying to access from the result which is actually empty.

Hope this helps..


Sravan