Hello Everyone !
I have created a list page and showing some data related to invent journals on it.
Data is being displayed properly. but i want to filter that data on the list page based on assigned user.
If a journal is assigned to current user then it should be displayed otherwise not.
How can I accomplish that ?
I guess using a range in the query that i am using for data population on the list page. but I dont know which table contains the information of assigned user and journal connection.
thanks
*This post is locked for comments
Hi Muhamed
You can manage the Inventory Journal access on the private groups in the declaration of the Inventory journal master data . You can specify the user group will access and see theis Journal , and it will automaticaly filter it in your list .
I am assuming that you have already developed the workflow for inventory journal.
Below is the relation between two tables. If journal is assigned to mutiple users then there
will be multiple records in this table. (One record per user)
WorkflowWorkItemTable.refrecid == InventJournalTable.RecId
WorkflowWorkItemTable.refTableID == InventJournalTable.TableId
WorkflowWorkItemTable.CompanyId == InventJournalTable.DataAreaId
Thank you Mahesh.
Can you please tell me how the table WorkflowWorkItem is connected with InventJournalTable ?
Hi Muhammad
I dont think there is a standard assignment or workflow avilable on the inventory journals.
If you need to assign it to the users then you need to first develop and create workflow on inevntory journal.
If you have already developed workflow for inventory journals, then user assignments are stored in WorkflowWorkItem table.
Dear Crispin John Augustine,
Thank you very much for you reply.
Yes You are right. i need to know how to find the table and the connection.
My root table in the query is InventJournalTable, that is getting data. Now i don't know which table contains information about user assignment and its connection with InventJournalTable.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,900 Super User 2024 Season 2
Martin Dráb 229,297 Most Valuable Professional
nmaenpaa 101,156