Multiple condition in Where Clause.

[Neetu2000]

There is a one string field function (present on User (sys_user) table) .
This string field is present on a database view too.
Whenever I change the value of string field on User table , record is create with new value in database view.
I don't want to change the value of function field in existing records of database view.
There is one Where Clause beside the User table in database view.
So is there any way to give condition in where clause so that existing records of function field value of particular user will not change??

[newhand]

@Neetu2000 

Generally database view is just a sql, it doesn't store data.

So  your requirement can't  be easily achived.

1.  create a new table with the same fields as the database view.

2.  create a flow or job to reflash the table records (new problmen here , when to run!)

3.  use the new table instead of database view。