Need to dump Appian User and related Group info into DB

Any suggestion on designing the process of dumping all user id and associated Groups in Database.

 

We have some requirement to expose this data to end user via Database. 

 

  Discussion posts and replies are publicly visible

Parents
  • Hi Piyush Agarwal,

    My idea is to write all the user details to DB in single call(Delete/archive the process immediately). I feel the below code with modifications will work.

    load(

    local!Users:getgroupmemberuserspaging(cons!APN_ALL_USERS),

    local!Users,

    a!forEach(

     items:local!Users,

     expression:

     'type!{urn:com:nbnco:types:test}test_users'(

       id:ri!users.id,

       groupId:'type!{urn:com:nbnco:types:test}test_groups'(

         id:ri!groups.id,

         groupId:getgroupsformemberuser(fv!item)

     )

    )

    )

    )

    Thanks

    Siva Chimata

Reply
  • Hi Piyush Agarwal,

    My idea is to write all the user details to DB in single call(Delete/archive the process immediately). I feel the below code with modifications will work.

    load(

    local!Users:getgroupmemberuserspaging(cons!APN_ALL_USERS),

    local!Users,

    a!forEach(

     items:local!Users,

     expression:

     'type!{urn:com:nbnco:types:test}test_users'(

       id:ri!users.id,

       groupId:'type!{urn:com:nbnco:types:test}test_groups'(

         id:ri!groups.id,

         groupId:getgroupsformemberuser(fv!item)

     )

    )

    )

    )

    Thanks

    Siva Chimata

Children
No Data