Hello all, InventoryAndWarehouseManagement\Common\On-hand inventory here i need to add item group in the grid to provide filter on it. to the ListPage query(InventOnhandDim) ds node i added InventItemGroupItem table and established relation with InventTable as shown in the screenshot. Finally i added Item group field to the ListPage it’s showing null value in the Item group field.
Please guide in this
use proper relation type 1:m and also try to delete cache and restore the query
try to select this query again on form or report where it is being used so that it will refresh the new fields.
I tried those initially nothing worked.
If possible can you check in your app.
I dont have system right now with me. but you can also check that ur using all fields in the query properly. select all fields for safe and then try. mostly it is the issue of cache. you can go and clear all auc file and it might help.