Hello! I have a process model which gets the user name and current date to create a log of users and the last time they logged in (Writes to Data Store); this works however I am ending up with multiple records for each user and I wanted to set this so it only creates unique users and captures the most recent login date for existing users.Currently the user Id is simply an integer and each time user details are captured a new record is created with a new integer - I have an expression rule which I can use to query the username (known unique field) and return other details ("userId", "Date" etc etc) I was hoping to check this and if a user "exists" in the Record Type only update the date.Any ideas at how I can update the process model to do this?? I was initially thinking/hoping I could run the expression rule from the process model(not sure how?!) then have an XOR gate to check if userId not blank then create a new user record in data store else pass details and only update the date field in the data store??Thank you!
Discussion posts and replies are publicly visible
Before writing the data in the DB, query it first based on the logged-in user and then update it to have a new time.
Ok assuming this would be via a "Query Database" item?
Please use a script task and a queryEntity or queryRecordType.