i have requirement that i need to separate the logged in user and othernames?
Discussion posts and replies are publicly visible
Hi,
Please find below code to bifurcate the data:
load( local!timesheetdata, /*Existing Data*/ local!timesheetdataForLoggedInUser: index( local!timesheetdata, wherecontains( tostring(loggedInUser()), touniformstring( index( local!timesheetdata, "user", /*Field Name in which you are capturing Employee Name*/ {} ) ) ), {} ), local!timesheetdataForOtherUsers: remove( local!timesheetdata, wherecontains( tostring(loggedInUser()), touniformstring( index( local!timesheetdata, "user", /*Field Name in which you are capturing Employee Name*/ {} ) ) ) ), { local!timesheetdataForLoggedInUser, /*Data Based on logged in user*/ local!timesheetdataForOtherUsers /*Data Based on other Users*/ })
thank you so much paresh