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: Projection .client file:
Hi all, I would like to have some guidance over the development approach for the following layout in Aurena. I need to populate the details table on the basis of manually entering part no(s) . User may fill any of four part no. and check-uncheck checkboxes in header and then click on search. After clicking on search , these values should go only in where clause of detail table (as the part no. in header is not directly linked with detail table below) Do we have any such screen already available in Aurena? Thanks in anticipation
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.