In our existing Appian user accounts, we have duplicated users with the same emp

In our existing Appian user accounts, we have duplicated users with the same employeeID (set as customField1). I have to do housekeeping to deactivate the duplicated user accounts based on the duplicated employeeID. What is the best way to do it?

I have looked at intersection, union, wherecontains, contains, distinct... But I have no idea how to implement any of these function to achieve my objective. Any ideas?

Thanks!
...

OriginalPostID-79642

OriginalPostID-79642

  Discussion posts and replies are publicly visible

Parents
  • Hi Michael, your application package couldn't be imported.

    Problems (1):
    content _a-0000d827-0d26-8000-4594-010000010000_1307 "checkIfIndexEqualToValue": An error occurred while creating content [uuid=_a-0000d827-0d26-8000-4594-010000010000_1307]: Name is insufficiently unique (APNX-1-4071-007)

    Cascading Problems (3):
    content _a-0000d827-0d26-8000-4594-010000010000_1308 "isValueDuplicated": The content [id= uuid=_a-0000d827-0d26-8000-4594-010000010000_1308] was not imported because a required reference is missing: Reference to content [_a-0000d827-0d26-8000-4594-010000010000_1307] (Content > Free-form Rule) cannot be found. (APNX-1-4070-001) (APNX-1-4071-006)
    content _a-0000d827-0d26-8000-4594-010000010000_1311 "whichItemsAreDuplicated": The content [id= uuid=_a-0000d827-0d26-8000-4594-010000010000_1311] was not imported because a required reference is missing: Reference to content [_a-0000d827-0d26-8000-4594-010000010000_1308] (Content > Free-form Rule) cannot be found. (APNX-1-4070-001) (APNX-1-4071-006)
    processModel 0003d827-18d9-8000-4595-010000010000 "{en_US=Show Duplication Rules}": The processModel [id= uuid=0003d827-18d9-8000-4595-010000010000] was not imported because a required reference is missing: Reference to content [_a-0000d827-0d26-8000-4594-010000010000_1311] (Process Model Expressions (Rules)) cannot be found. (APNX-1-4070-001) (APNX-1-4071-006)

    Success (3):
    content _a-0000d827-0d26-8000-4594-010000010000_1306 359 "Testing"
    processModelFolder _g-0000d827-0d28-8000-4595-010000010000_4 19 "Testing"
    application _a-0000d827-0d26-8000-4594-010000010000_1314 360 "Duplication Test"

    Hmmm....
Reply
  • Hi Michael, your application package couldn't be imported.

    Problems (1):
    content _a-0000d827-0d26-8000-4594-010000010000_1307 "checkIfIndexEqualToValue": An error occurred while creating content [uuid=_a-0000d827-0d26-8000-4594-010000010000_1307]: Name is insufficiently unique (APNX-1-4071-007)

    Cascading Problems (3):
    content _a-0000d827-0d26-8000-4594-010000010000_1308 "isValueDuplicated": The content [id= uuid=_a-0000d827-0d26-8000-4594-010000010000_1308] was not imported because a required reference is missing: Reference to content [_a-0000d827-0d26-8000-4594-010000010000_1307] (Content > Free-form Rule) cannot be found. (APNX-1-4070-001) (APNX-1-4071-006)
    content _a-0000d827-0d26-8000-4594-010000010000_1311 "whichItemsAreDuplicated": The content [id= uuid=_a-0000d827-0d26-8000-4594-010000010000_1311] was not imported because a required reference is missing: Reference to content [_a-0000d827-0d26-8000-4594-010000010000_1308] (Content > Free-form Rule) cannot be found. (APNX-1-4070-001) (APNX-1-4071-006)
    processModel 0003d827-18d9-8000-4595-010000010000 "{en_US=Show Duplication Rules}": The processModel [id= uuid=0003d827-18d9-8000-4595-010000010000] was not imported because a required reference is missing: Reference to content [_a-0000d827-0d26-8000-4594-010000010000_1311] (Process Model Expressions (Rules)) cannot be found. (APNX-1-4070-001) (APNX-1-4071-006)

    Success (3):
    content _a-0000d827-0d26-8000-4594-010000010000_1306 359 "Testing"
    processModelFolder _g-0000d827-0d28-8000-4595-010000010000_4 19 "Testing"
    application _a-0000d827-0d26-8000-4594-010000010000_1314 360 "Duplication Test"

    Hmmm....
Children
No Data