title: How to assign a transient value as a default value to another attribute in View Object - ADF
body: <p>I am new to adf and I am trying to provide a default value based on an sql statement to another attribute. For instance I have a table called Employee(emp_id,emp_version,emp_name...), which has a column emp_version and i want to provide a default value to emp_version with the following sql statement:</p>
  
  <pre><code>  select count(emp_id)+1
      from employees
  </code></pre>
  
  <p>In order to do this  I tried to create a transient field(testEmpversionTransient) and provide an sql statement as shown below:
  <a href="https://i.stack.imgur.com/haOUK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/haOUK.png" alt="enter image description here"></a></p>
  
  <p>However I am not able to assign the value from the testEmpversionTransient attribute to emp_version attribute, any idea how it can be acheived please?</p>
  
  <p>Thanks in advance</p>