casted values in select for some internal api calls