I was reading this link: https://docs.appian.com/suite/help/17.3/User_Management.html#-add-user-filters and didn't find the answer to my question. I would like to be able to search by user ID. Is there any way to do so?
Discussion posts and replies are publicly visible
Are you willing to share the objects that you created to maintain that Users table? Would save me the trouble of creating them from scratch.
Hello,
I also have the same question as erickp
We want to expand Appian's default User Record Type and we want to search the record list typing a user's username. Currently only the user's name (first name & last name) are supported. This is what we are trying to figure out for Appian 19.4 as well. Appian's documentation isn't helping on this issue.
Sorry for the late reply - for whatever reason I don't think I originally got a notification of this so I only just noticed after the newer reply was added below.
In general the user DB table can and should be fairly simple - with just enough to give you the control you need. The fields typically involved that I've seen:
That's about all you would need - to support such a table, you would either need a process where admins can add/edit users via a front-end process, or at least a process that runs periodically and finds all current active user accounts in the system and syncs their data with the matching DB table entry, and creates one if none is found.
For a number of reasons, I don't think I want to require all user adding/editing operations to be performed through a separate front end. If you have already created a process that syncs user data with a table, are you willing to share that?
I don't have such a process at hand, but it shouldn't be terribly hard to create from scratch. A few checklist items I can think of:
Let me know if any of that is unclear or if there are any other questions. This was all off the top of my head so I may have glossed over something.
Makes sense, but this is one of those things that is unlikely to make it to the top of my to-do list if I have to make it from scratch. Also, don't you wish that there were a better way to handle scheduling processes to run on a timer?
John Stretton said:Also, don't you wish that there were a better way to handle scheduling processes to run on a timer?
I'm quick to call out Appian in areas that I feel they need to improve, but as far as pure use cases like running a maintenance process once per day overnight, I feel it's fairly easy to do once you get used to the necessary controls.
The one thing I wish we could do, though, would be to set up process triggers based on internal events (like, "run this process every time a user is created, updated or deactivated via any internal mechanism", which would negate the need for a timer in most cases). But alas, I don't anticipate that happening any time soon.
Sure, but I have a LOT of processes that just send some kind of email once per day, or every other Tuesday, or once per month, etc. Having to create two separate process models for that (and a Boolean flag to avoid firing an instance of the timer process when it's published) is a bit cumbersome, don't you think?
IF you really wanted to, you could potentially configure all (or most) of those use cases into one "daily launch" process model, which then calls various subprocesses (themselves not having any sort of timer), which could each do a double-check whether they should A) not fire "today" (and just exit), B) fire at a later time (wait at a timer node, then execute), or C) execute right away (stuff that should happen at 1 AM).
I mean, I suppose they could simplify it some, but then we'd likely lose some of the more complex capabilities we currently have.
Thanks for all of your suggestions. I'll file the user table one away for a rainy day.