Hi All,

I have created a assistant with a input fields (lets say PartNo1 and PartNo2).

I am trying to navigate to a page on clicking the okay button to a page which will populate the view “XYZ” on the basis of these PartNo1 and PartNo2. 

Now I don’t have columns PartNo1 and PartNo2 in my view “XYZ” but i need to use them in where clause . So i am trying something like below example.

For example :(this is just for examplory purpose)

.projection file:

query InventoryPartQry for InventoryPart {

from = “XYZ”;

where = “ EXISTS( SELECT 1 from ABC WHERE abc.part_no = xyz.part_no AND  abc.part_no_alt1= :PartNo1    and abc.part_no_alt2 = :PartNo2)”;

field Contract;

field PartNo;

field PartNo1

{  fetch = “:PartNo1”;

}

field PartNo2 {  

fetch = “:PartNo2”; }

}

Is there any issue with my where clause here.As i get undefined error in Aurena. As its not passing :PartNo1 and :PartNo2 as bind variables .

Here is real example :

 .projection  file:

.client file:

Please let me know if you have any suggestion or alternate solution to the problem.

Thanking in anticipation,

Suraj Mohan