HI All
I just want to know that where the value of Description field of an Application is stored?
I checked in identityiq.spt_application table but I didnt find description column.
Thanks
It is stored as a LocalizedAttribute object in the table spt_localized_attribute:
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE LocalizedAttribute PUBLIC "sailpoint.dtd" "sailpoint.dtd">
<LocalizedAttribute attribute="description" created="1457529493898" id="8ae14ad05356de5a01535b87198a0221" locale="en_US" modified="1457529519631" name="Active Directory:description:en_US" targetClass="Application" targetId="40289ffe4bd9b6c3014be65b071b017b" targetName="Active Directory" value="My Active Directory<br>"/>
mysql> select * from spt_localized_attribute;
+----------------------------------+---------------+---------------+-------+------------------------------------+--------+-------------+-------------------------+--------------+------------------+----------------------------------+
| id | created | modified | owner | name | locale | attribute | value | target_class | target_name | target_id |
+----------------------------------+---------------+---------------+-------+------------------------------------+--------+-------------+-------------------------+--------------+------------------+----------------------------------+
| 8ae14ad05356de5a01535b87198a0221 | 1457529493898 | 1457529519631 | NULL | Active Directory:description:en_US | en_US | description | My Active Directory<br> | Application | Active Directory | 40289ffe4bd9b6c3014be65b071b017b |
+----------------------------------+---------------+---------------+-------+------------------------------------+--------+-------------+-------------------------+--------------+------------------+----------------------------------+
1 row in set (0,00 sec)
- Menno
Hi
I have one doubt here.
We can see in value <br> is coming.
How we can remove that?
Thanks
Sunil
<br> is an HTML line ending. You can remove that by editing the field and not pressing enter.