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$'
Aurimas Bruzas in reply to Carma De Villiers
Is this using Attribute Def Lookup feature with external DB provider ? If yes, I'd check the configuration for data source connection via Director -> Attributes config -> Lookup. The UI's provide ways to test the connection and run the query. In the end this would just connect to the database, and run the SQL provided. (the select is targeting some other schema - there's no env_LU_DC_State_Reason table in eB Core).
Hi Rakhi, is this for eB?
No I thought I removed from here and meant to post it under ProjectWise. trying to remove it again
Carma : its not letting me delete the post. Can you please remove it from here
Answer Verified By: Carma De Villiers
Just completed it and serves as closed