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