I need to create a lobby data source where 2 views are involved.
from view1 has project title,
view 2 has project id and manager name
these two view has no relation between them, but I use regexp_substr to sort out view2.project_id from view1.title
and using that project id I fetch the manager.
Since lobby data source can only use one view, I have implemented this using IAL.
select a.*, b.manager from DOC_ISSUE_REFERENCE a, PROJECT_BASE b
b.project_id = REGEXP_SUBSTR (a.title,'(\S*)')
I need the result per manager in lobby condition, using lobby datasource. But it is showing an error while clicking lobby element and no data is getting populated, Is there anyway to do this.
Or do I have to create a custom column for manager to solve this issue?
Thanks in advance
Best answer by NickPorterView original