# IIQDisabled not working for JDBC Connector **URL:** \ **Category:** SHF Discussion and Questions\ **Tags:** jdbc-connector, connectors, sailpoint-identity-security\ **Created:** [December 18, 2024, 6:51am UTC](https://developer.sailpoint.com/discuss/t/iiqdisabled-not-working-for-jdbc-connector/93904 "2024-12-18T06:51:02Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![gmilunich](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/gmilunich/32/8431_2.png) [@gmilunich](https://developer.sailpoint.com/discuss/u/gmilunich)\ **Post date:** [December 18, 2024, 6:51am UTC](https://developer.sailpoint.com/discuss/t/iiqdisabled-not-working-for-jdbc-connector/93904/1 "2024-12-18T06:51:02Z")
I have a JDBC Connector, and am setting the value of “IIQDisabled” to true/false depending on another attribute as referenced in the documentation here: [Loading a Single Account or Group](https://documentation.sailpoint.com/connectors/jdbc/help/integrating_jdbc/loading_single_account_group.html) I also reviewed these two related articles: > [@Problem Disabling Accounts in JDBC Source](https://developer.sailpoint.com/discuss/t/problem-disabling-accounts-in-jdbc-source/89008): > > We have created a string field called IIQDisabled in the schema and added it in the SELECT statement as follows: SELECT \* ,case when laboralState=‘ACTIVE’ then ‘false’ else ‘true’ end as IIQDisabled FROM database.table This is based on the documentation we found here: [Loading Single Account Group in JDBC](https://documentation.sailpoint.com/connectors/jdbc/help/integrating_jdbc/loading_single_account_group.html). The query works correctly when executed directly in the database. However, when performing the aggregation, the IIQDisabled field remains empty, and I fear this is why the relevant accounts a… > [@How to reflect enabled/disabled status of jdbc accounts?](https://developer.sailpoint.com/discuss/t/how-to-reflect-enabled-disabled-status-of-jdbc-accounts/24449): > > Hi! I have a JDBC connector, on which there is a table for users, with some status column. Value 1 means active, and value 2 inactive. How can I map these values to be reflected on IDN accounts screen? At aggregation data is brought right (disabled users appears with 2 status), but at the accounts screen level it remains as active. But neither helped. When I look at the account, I can see the value is set correctly: ![Screenshot 2024-12-18 at 1.49.13 AM](https://global.discourse-cdn.com/sailpoint/original/3X/c/a/cae34cefc8b353ec0ee56604e8bcc0bf7d5cb9ab.png) However, when I run the aggregation (unoptimized or through the UI) and the account status never changes, they are always Enabled. What am I missing here? Is it Case-Sensitive? There are no rules attached to the source except JDBC Provisioning. ---
**Author:** ![sameertawargeri](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/sameertawargeri/32/20540_2.png) [@sameertawargeri](https://developer.sailpoint.com/discuss/u/sameertawargeri)\ **Post date:** [December 18, 2024, 10:03am UTC](https://developer.sailpoint.com/discuss/t/iiqdisabled-not-working-for-jdbc-connector/93904/2 "2024-12-18T10:03:20Z")
Can you try creating and attaching a JDBCBuildmap rule to the source, and add below line in the rule depending on your another attribute. **map.put(“IIQDisabled”, “true”);** Refer [JDBC BuildMap Rule | SailPoint Developer Community](https://developer.sailpoint.com/docs/extensibility/rules/connector-rules/jdbc-buildmap-rule) ---
**Author:** ![gmilunich](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/gmilunich/32/8431_2.png) [@gmilunich](https://developer.sailpoint.com/discuss/u/gmilunich)\ **Post date:** [December 18, 2024, 2:10pm UTC](https://developer.sailpoint.com/discuss/t/iiqdisabled-not-working-for-jdbc-connector/93904/3 "2024-12-18T14:10:52Z")
I should have mentioned I am trying to avoid that if possible, as it is one more thing to maintain when it should be possibly to pull it from the SQL, as described in the first link I mentioned. The value is showing correctly in the Account Attrbutes. Side note: I believe I had this working before, but when I came back to this source to check something for certifications, it is no longer showing the enabled/disables status. ---
**Author:** ![mcheek](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/mcheek/32/23705_2.png) [@mcheek](https://developer.sailpoint.com/discuss/u/mcheek)\ **Post date:** [December 18, 2024, 2:13pm UTC](https://developer.sailpoint.com/discuss/t/iiqdisabled-not-working-for-jdbc-connector/93904/4 "2024-12-18T14:13:13Z")
Are the conditions which IIQDisabled is set present in both the single and multiple account queries? Unsure if it’s specifically required to be present in both, but was just curious ---
**Author:** ![patrickboston](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/patrickboston/32/5876_2.png) [@patrickboston](https://developer.sailpoint.com/discuss/u/patrickboston)\ **Post date:** [December 18, 2024, 2:17pm UTC](https://developer.sailpoint.com/discuss/t/iiqdisabled-not-working-for-jdbc-connector/93904/5 "2024-12-18T14:17:12Z")
Try to wrap the IIQDisabled alias definition in the query in double quotes if it’s not already. This fixed it for me in one instance against an Oracle Database. ```sql case when COL_NAME <> 'A' then 'true' else 'false' end as "IIQDisabled" ``` ---
**Author:** ![mcheek](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/mcheek/32/23705_2.png) [@mcheek](https://developer.sailpoint.com/discuss/u/mcheek)\ **Post date:** [December 18, 2024, 2:31pm UTC](https://developer.sailpoint.com/discuss/t/iiqdisabled-not-working-for-jdbc-connector/93904/6 "2024-12-18T14:31:19Z")
Oddly enough at least for me it doesn’t seem to matter on SQL Server Databases ```SQL CASE WHEN u.IsActive = 0 THEN 'true' WHEN u.IsActive = 1 THEN 'false' END AS IIQDisabled ``` ---
**Author:** ![gmilunich](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/gmilunich/32/8431_2.png) [@gmilunich](https://developer.sailpoint.com/discuss/u/gmilunich)\ **Post date:** [December 18, 2024, 2:32pm UTC](https://developer.sailpoint.com/discuss/t/iiqdisabled-not-working-for-jdbc-connector/93904/7 "2024-12-18T14:32:49Z")
> [@mcheek](#): > > Are the conditions which IIQDisabled is set present in both the single and multiple account queries? Yes, this is what it looks like in the query: ![Screenshot 2024-12-18 at 9.28.22 AM](https://global.discourse-cdn.com/sailpoint/original/3X/1/9/19d6ab501428706ddec32846c9673751a7295d98.png) > [@patrickboston](#): > > Try to wrap the IIQDisabled alias definition in the query in double quotes if it’s not already. This fixed it for me in one instance against an Oracle Database. > > ```auto > case when COL_NAME <> 'A' then 'true' else 'false' end as "IIQDisabled" > > ``` I tried this as well, but noticed that it was not quoted on the one I am working with currently, so I an giving that a try now. I am working with an Oracle DB also in this instance. ---
**Author:** ![gmilunich](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/gmilunich/32/8431_2.png) [@gmilunich](https://developer.sailpoint.com/discuss/u/gmilunich)\ **Post date:** [December 18, 2024, 2:41pm UTC](https://developer.sailpoint.com/discuss/t/iiqdisabled-not-working-for-jdbc-connector/93904/8 "2024-12-18T14:41:41Z")
> [@patrickboston](#): > > Try to wrap the IIQDisabled alias definition in the query in double quotes if it’s not already. This fixed it for me in one instance against an Oracle Database. > > ```auto > case when COL_NAME <> 'A' then 'true' else 'false' end as "IIQDisabled" > > ``` It looks like this was it. I figured it had to be something simple. I did not have it quoted, which worked in the SQL Developer, but apparently not through ISC. Side Note: When setting up the IIQDisabled value in the Schema, it did not care whether it was set to String or Boolean. Both worked once I got the query set. ---
**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\ **Post date:** [February 16, 2025, 2:42pm UTC](https://developer.sailpoint.com/discuss/t/iiqdisabled-not-working-for-jdbc-connector/93904/9 "2025-02-16T14:42:33Z")
Closed on February 16, 2025, 2:42pm UTC This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.