Good morning,
I would likie to know if there is a possibility to use two views/tables in Data Soursce Constructor?
If yes, how to do this?
I need to combine data from two different views and present it on one lobby object.
I have alredy tried with adding two views in “View” box (separetad with “ , ” or “ ; ”) but it didn’t work.
Second idea was to use SQL construction JOIN in “Where” box
eg. &AO.company_person_all.emp_no = &AO.company_person.emp_no
Thanks!
Sadly this is not possible.
The workaround is to create an IAL and query that
Hi,
Looks as if you can do it using Query Builder.
Alternatively, you can create an IAL and use that
(Or create a view in the database - Although this will not be IFS’s recommended method there is technically nothing stopping you (Unless you are IFS cloud hosted))
Callum
I know this is old but I was working on this too. In the view line you can put 2 views on that line and preview. You can create columns and everything. But as soon as you try to save it IFS tells you to select one view. It’s crazy how it will let you do this but not save it.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.