8.4p2
I have a form where user IDs are taken as input. I want to create a review page based on the input IDs, along with Email(auto-fetched) in table format shown up in review page. How to do in table. The table should contain two coumns: User ID, Email. The data from the form should populate itself in review page as table.
This might help in your case. add it in your workflow
<Step icon="Default" name="Generic Step" posX="320" posY="121">
<Approval name="User Details Form" owner="ref:launcher" return="identityModel" send="identityModel">
<Arg name="workItemFormBasePath" value="identityModel"/>
<Form name="User Details Form">
<Attributes>
<Map>
<entry key="pageTitle" value="User Details Form"/>
</Map>
</Attributes>
<Description>Second Form</Description>
<Section name="Section 12" type="text">
<Field displayName="User Info" filterString="htmlRender" name="tableData" type="text">
<Attributes>
<Map>
<entry key="contentIsEscaped" value="true"/>
</Map>
</Attributes>
<Script>
<Source> import sailpoint.object.Filter;
import sailpoint.object.IdentityEntitlement;
import sailpoint.object.Link;
import sailpoint.object.QueryOptions;
import sailpoint.tools.GeneralException;
import sailpoint.tools.Util;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
Log log = LogFactory.getLog("sailpoint.bsh.demo");
Iterator it = null;
boolean roleWithApp = false;
List users = new ArrayList();
String mainStr = "<table border=\"1\" cellpadding=\"3\" cellspacing=\"3\" width=\"100%\" style=\"border-collapse:collapse;\">\n" +
" <tr>\n" +
" <th>ID</th>\n" +
" <th>Display Name</th>\n" +
" <th>Email</th>\n" +
" </tr>\n";
try {
String applicationName = (String) identityModel.get("applicationName");
String roleName = (String) identityModel.get("roleName");
QueryOptions options = new QueryOptions();
options.setCloneResults(true);
if (Util.isNotNullOrEmpty(roleName)) {
options.addFilter(Filter.and(Filter.eq("value", roleName)));
options.add(new Filter[]{Filter.or(Filter.eq("name", "assignedRoles"))});
it = context.search(IdentityEntitlement.class, options);
roleWithApp = true;
} else {
// fetch users with app
options.addFilter(Filter.and(Filter.and(Filter.eq("application.name", applicationName))));
it = context.search(Link.class, options);
}
while (it != null && it.hasNext()) {
if (roleWithApp) {
IdentityEntitlement identityEntitlement = (IdentityEntitlement) it.next();
mainStr += "<tr>\n" +
"<td>" + identityEntitlement.getIdentity().getName() + "</td>\n" +
"<td>" + identityEntitlement.getIdentity().getDisplayName() + "</td>\n" +
"<td>" + identityEntitlement.getIdentity().getEmail() + "</td>\n" +
"</tr>\n";
} else {
Link link = (Link) it.next();
if (link.getIdentity() != null) {
mainStr += "<tr>\n" +
" <td>" + link.getIdentity().getName() + "</td>\n" +
" <td>" + link.getIdentity().getDisplayName() + "</td>\n" +
" <td>" + link.getIdentity().getEmail() + "</td>\n" +
"</tr>\n";
}
}
}
mainStr += "</table>";
} catch (GeneralException e) {
log.error("Exception thrown while fetching identities : " + e.getMessage());
}
return mainStr;
</Source>
</Script>
</Field>
</Section>
<Button action="next" label="Next" parameter="userAction" value="next"/>
<Button action="cancel" label="Cancel" parameter="userAction" skipValidation="true" value="cancel"/>
</Form>
</Approval>
<Transition to="Stop"/>
</Step>
We have an open source library that really simplifies this: src/com/identityworksllc/iiq/common/table · main · pub / IIQ Common Public · GitLab
I am facing this issue, how to resolve it
just add the Attributes to the text type field.
<Attributes>
<Map>
<entry key="contentIsEscaped" value="true"/>
</Map>
</Attributes>
Fully updated one:
<Field displayName="User Info" filterString="htmlRender" name="tableData" type="text">
<Attributes>
<Map>
<entry key="contentIsEscaped" value="true"/>
</Map>
</Attributes>
<Script>
<Source> import sailpoint.object.Filter;
import sailpoint.object.IdentityEntitlement;
import sailpoint.object.Link;
import sailpoint.object.QueryOptions;
import sailpoint.tools.GeneralException;
import sailpoint.tools.Util;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
Log log = LogFactory.getLog("sailpoint.bsh.demo");
Iterator it = null;
boolean roleWithApp = false;
List users = new ArrayList();
String mainStr = "<table border=\"1\" cellpadding=\"3\" cellspacing=\"3\" width=\"100%\" style=\"border-collapse:collapse;\">\n" +
" <tr>\n" +
" <th>ID</th>\n" +
" <th>Display Name</th>\n" +
" <th>Email</th>\n" +
" </tr>\n";
try {
String applicationName = (String) identityModel.get("applicationName");
String roleName = (String) identityModel.get("roleName");
QueryOptions options = new QueryOptions();
options.setCloneResults(true);
if (Util.isNotNullOrEmpty(roleName)) {
options.addFilter(Filter.and(Filter.eq("value", roleName)));
options.add(new Filter[]{Filter.or(Filter.eq("name", "assignedRoles"))});
it = context.search(IdentityEntitlement.class, options);
roleWithApp = true;
} else {
// fetch users with app
options.addFilter(Filter.and(Filter.and(Filter.eq("application.name", applicationName))));
it = context.search(Link.class, options);
}
while (it != null && it.hasNext()) {
if (roleWithApp) {
IdentityEntitlement identityEntitlement = (IdentityEntitlement) it.next();
mainStr += "<tr>\n" +
"<td>" + identityEntitlement.getIdentity().getName() + "</td>\n" +
"<td>" + identityEntitlement.getIdentity().getDisplayName() + "</td>\n" +
"<td>" + identityEntitlement.getIdentity().getEmail() + "</td>\n" +
"</tr>\n";
} else {
Link link = (Link) it.next();
if (link.getIdentity() != null) {
mainStr += "<tr>\n" +
" <td>" + link.getIdentity().getName() + "</td>\n" +
" <td>" + link.getIdentity().getDisplayName() + "</td>\n" +
" <td>" + link.getIdentity().getEmail() + "</td>\n" +
"</tr>\n";
}
}
}
mainStr += "</table>";
} catch (GeneralException e) {
log.error("Exception thrown while fetching identities : " + e.getMessage());
}
return mainStr;
</Source>
</Script>
</Field>
</Section>
It is same even with using contentIsEscaped. Does not solve the issue.
I am looking for native solution. Do let me know if there is a way
try this below.
<Section name="Section 15" type="text">
<Field displayName="User Info" filterString="htmlRender" name="tableData" type="text">
<Attributes>
<Map>
<entry key="contentIsEscaped" value="true"/>
</Map>
</Attributes>
<Script>
<Source>
String html = "<table border=\"1\" cellpadding=\"3\" cellspacing=\"3\" width=\"100%\" style=\"border-collapse:collapse;\">\n" +
" <tr>\n" +
" <th>ID</th>\n" +
" <th>Display Name</th>\n" +
" <th>Email</th>\n" +
" </tr>\n" +
" <tr>\n" +
" <td>user1</td>\n" +
" <td>John Doe</td>\n" +
" <td>[email protected]</td>\n" +
" </tr>\n" +
" <tr>\n" +
" <td>user2</td>\n" +
" <td>Jane Smith</td>\n" +
" <td>[email protected]</td>\n" +
" </tr>\n" +
" <tr>\n" +
" <td>user3</td>\n" +
" <td>Mike Johnson</td>\n" +
" <td>[email protected]</td>\n" +
" </tr>\n" +
"</table>";
return html;
</Source>
</Script>
</Field>
</Section>
yes this works. I am able to get the table now from what you suggested. It is hardcoded though
Also when I am trying to populate the data dynamically from form 1 user ID into this table, data comes as 1 string in 1 row, all the other table parts are empty.
My approach was I used delimiter to separate values and to get email for each ID in userID through context.getObjectByName(Identity.class, ID)
For reference our table class is open source along with many other useful utilities.
