Not able to see attribute column while update user request

[Sekhar]

Hi Team,

Iam getting below error while update user request & attribute column is not visible.

I created 2 attributes prior i.e, location (Parent) & locationcode (Child) but locationcode is working properly. I used the same method for this one also.

I created child attribute that is departmentcode, parent attribute is department.

The column able to see & value is getting while creating user request, but issue is happening while update user request.

Attribute Name	Dyndepartmentcode
Request Type	User
Attribute Level	Department Code
Attribute Type	Single select from SQL Query
Value	select dv.ATTRIBUTE2 as ID from dataset_values dv join dataset d on dv.DATASETKEY=d.DATASETKEY where dv.ATTRIBUTE3 = ${dyndepartment}
Default	select dv.ATTRIBUTE2 as ID from dataset_values dv join dataset d on dv.DATASETKEY=d.DATASETKEY where dv.ATTRIBUTE3 = ${dyndepartment}
Required	Yes
Editable on Create	No
Editable on Update	Yes
User Column	departmentnumber
Parent Attribute	dyndepartment
What action to perform when Parent attribute changes?	Mapping

Could you please help me in this issue.

Thanks,

Sekhar

[Dhruv_Sharma]

Hi @Sekhar , Thanks for contacting the Saviynt forums. Our team is reviewing the issue and we will keep you informed.

[Dhruv_Sharma]

Hi @Sekhar , could you please also share the screenshot of the dynamic attribute details for the attribute locationcode for which it is working fine. Also please share the parent attribute details for the dyndepartment.

[Sekhar]

Hi @Dhruv_Sharma ,

Location name (Parent Attribute):

      

Value: select distinct attribute1 as id from dataset_values where dataset_values.datasetname ='Name'

Location Code (Child Attribute):

      

Values & default values: select dv.ATTRIBUTE2 as ID from dataset_values dv join dataset d on dv.DATASETKEY=d.DATASETKEY where dv.ATTRIBUTE1 = ${dynlocation}

Department (Parent Attribute):

    

Values: select distinct attribute3 as id from dataset_values where dataset_values.datasetname ='Name' 

Department code (Child Attribute):

  

Values & Default Values: select dv.ATTRIBUTE2 as ID from dataset_values dv join dataset d on dv.DATASETKEY=d.DATASETKEY where dv.ATTRIBUTE3 = ${dyndepartment}

I used same method & query as but department getting issue.

Thanks & Regards,

Sekhar.

[Dhruv_Sharma]

Hi @Sekhar , Could you please set the both flag to true (editable on create and editable on update) of the department code attribute and test the scenario again on create user/update user requests.

Regards,

Dhruv Sharma

[Sekhar · Accepted solution]

Hi, @Dhruv_Sharma 

Requirement is different, so we can't be editable on create.

The issue is resolved now. I think this is bug issue. After 3 days without any changes issue is sorted.

Thanks,

Sekhar.

[Dhruv_Sharma]

@Sekhar 

Thanks for the update. Good to know that issue is resolved. If you face similar problem in future, you can raise a support ticket and our team will check if it is a possible bug.

Regards,
Dhruv Sharma
If this reply answered your question, please accept it as Solution to help others who may have a similar problem.