Narendra Enamala I'm with Cvele_new_account here. Why do you ask me personally. This is a public space. Every user can help you solve the problem. Asking for help from one user is rude to the other users.
This said, I have to tell you, that I don't work on test cases which don't have a descrption on what the test case is supposed to do and what I have to do to see the problem (see Writing Reproducible Test Cases: Why and How). The test case you provided doesn't have this description. Even if you would have added this description, I would not be able to run the case as you have not used the standard HR DB schema.
Either you provide the info and use hte default HR DB schema or I'm not able to look into this sometime i nthe future.
When I am entering deptno value it should show deptname instead of, it is opening lov popup again with matched records lov's are filtering.
I used criteria for that as shown in below image. If user knows the exact value he can enter and proceed. I need to reduce the user no. of clicks.
User will not select lov because he knows the deptid, then the user enter the deptid and deptname should came through association. But lov is showing related match data (because of contains operator) and also I checked for equal operator and the result is same. My requirement is lov will not popup if the value exists in the lov. How can I achieve this?
Thanks in advance
Can you clarify the use case a bit, please?
Does the user enter a number into the field?
Or a string?
One problem I see is that your viewCriteria used in the search dialog uses an OR to combine the search. Meaning if I enter 10 into the number field and 'S' into the name field I'll get a couple of results. Normally you use AND to combine the search and set each part to ignore null values. This will either search for numbers or for names. If you enter both parts, the result must match both.
When the user enters a value into the input text, which finds more than one entry in the list (that's the case if you enter 10 as the search finds 10 and 100), the search dialog will open as it's not clear which result to use. Nothing can be done in this case using the normal inputlist of value.
To implement this case you would need to build your own logic. You can use a normal inputtext and button showing the magnifying icon and implement the logic yourself. I did this in a sample here https://tompeez.wordpress.com/2013/02/03/jdeveloper-11-1-1-6-0-afinputtext-with-self-made-look-up-not-using-lov/
when the inputtext loses the focus you can check the value against the list and decide what to do yourself.
The part to show the name behind the number is solved in the video Shay shared in the original post.