11-23-2022 09:15 PM
I hope to get the current accountname that a end user selected in ARS.
I will use this accountname to get account customproperty in Dynamic attribute.
is it possible to get current accountname in Dynamic attribute?
SELECT a.customproperty12 as ID FROM accounts a ,user_accounts ua ,users u ,endpoints e WHERE ua.accountkey = a.accountkey AND u.userkey = ua.userkey AND a.endpointkey = e.endpointkey AND e.displayname IN ('IACCOUNTING_DB_RELAY') AND a.STATUS IN ( '1' ) AND a.name = ${accountName}
11-23-2022 09:48 PM - edited 11-23-2022 09:49 PM
Account Name is not accessible in ars request form. If you know that account name rule you can add same rule in dynamic attributes query
11-23-2022 11:16 PM
thanks rushikeshvartak.
i am using a simple account name rule with systemusername.
but I am using the complex accountname rule in createacccountjson due to requirements.
so I would like to use variable to get accountname in ARS web page. is there no way?
{
"createAccountQry": [
"insert into \"DB\".\"Z\"(MANDT,IF_DATE,IF_TIME,LOGIN_ID,TYPE,AREA_CODE,ORIGIN_ID,BUKRS,ORGEH,ORGTX,KOSTL,KOSTL_NAME,IF_ID,SAP_STAT) VALUES('210','${Calendar.getInstance(TimeZone.getTimeZone('Asia/Seoul')).getTime().format('yyyyMMdd')}','${Calendar.getInstance(TimeZone.getTimeZone('Asia/Seoul')).getTime().format('HHmmss')}','${if(Companys=='1000'&&user.companyname!='A'){user.systemUserName+'.cp'} else if(Companys=='1100'&&user.companyname!='B'){user.systemUserName+'.cfs'} else if(Companys=='1200'&&user.companyname!='C'){user.systemUserName+'.cls'} else if(Companys=='1300'&&user.companyname!='D'){user.systemUserName+'.cd'} else if(Companys=='1400'&&!(user.companyname.contains('E'))){user.systemUserName+'.pay'} else if(Companys=='1500'&&user.companyname!='F'){user.systemUserName+'.plb'} else if(Companys=='1900'&&user.companyname!='G'){user.systemUserName+'.ces'} else if(Companys=='2000'&&user.companyname!='H'){user.systemUserName+'.sh'} else if(Companys=='2100'&&user.companyname!='I'){user.systemUserName+'.bj'} else if(Companys=='2200'&&user.companyname!='J'){user.systemUserName+'.sz'} else if(Companys=='2300'&&user.companyname!='K'){user.systemUserName+'.jk'} else if(Companys=='2400'&&user.companyname!='L'){user.systemUserName+'.yj'} else if(Companys=='2500'&&user.companyname!='M'){user.systemUserName+'.hk'} else if(Companys=='3100'&&user.companyname!='N'){user.systemUserName+'.ta'} else if(Companys=='3200'&&user.companyname!='O'){user.systemUserName+'.jp'} else if(Companys=='9000'&&user.companyname!='P'){user.systemUserName+'.llc'} else {user.systemUserName}}','5','','${user.systemUserName}','${Companys}','${Organization}','${OrgCode}','${CostCenter}','${CostCenterName}','SAVIYNT','R')"
]
}
11-24-2022 09:17 PM
No way to get account name on. Ars request form.
you should generate account name from endpoint instead of json as best practices
11-24-2022 09:47 PM
okay, let me try. thanks!!