I am implementing a setup where we return expiry date value as per a user's settings. For this I have added a column in radcheck table called ExpiryDate. 

I have added following in authorize section in sites-available/defaults

update control{
                My-Local-Int-1 := "%{sql: select id from radcheck where username='%{User-Name}' order by id desc limit 1}"
        }

        update reply{
                WISPr-Session-Terminate-Time = "%{sql: select ExpiryDate from radcheck where id = '%{My-Local-Int-1}'}"
        }



The username I am testing with has ExpiryDate value in radcheck table, however mysql query log shows me blank value for  '%{My-Local-Int-1}' for query in update reply {.. } section. 

Please suggest what I am doing wrong. My-Local-Int-1 has been defined in dictionary as integer.