SQL query is getting populated in service account name

[manishka]

We are working on managing service account module .here we are validating service account name value based on the value of service account name rule provided at endpoint value.

when we placed a sql query in our dynamic attribute, that query is getting populated there instead of value output of query. This is stopping us from getting the desired result.

Is it expected or something we are missing? 

[Saathvik]

@manishka : Can you provide more details with screenshot or something. I know there is a known bug in Service account name field where it shows the rule you configured on endpoint instead of value until you click on generate button which is introduced in some 24.x version and fixed in v24.3. Not sure if you referring to same thing or different.

[rushikeshvartak]

Can you share CONFIG screenshot

[manishka]

Hi Rushi,

We are working on generation of service account name via endpoint's service account name rule. There we are calling dynamic attribute. Also we are not able to call below query:

select username from users where userkey='${requestee}'

[rushikeshvartak]

SQL Query is not supported there it should be groovy

Sample - Azure-SVC-${appname.replace(" ", "")}-${environment}${additional_naming_criteria=='' ? '':'-'}${additional_naming_criteria}###INCREMENTINDEX###${environment=='DEV' ? '@rushi.az':(environment=='TEST' ? '@rushi.az':(environment=='PROD' ? '@rushi.cl':''))}