Attribute SQL statement help

We are trying to populate State_activity in attribute field based on what is the state of the document. In this example state is Edit.

we used below statement which does not work.

select distinct state_activity from env_LU_DC_State_Reason where state_state =  '$EDIT#state_state$'

Parents Reply Children