I've 3 Prompts in one Query in Query Manager.
Now when i go for department why i can not get department according to the value selected in Business unit prompt?
I created a view having field business_unit but still department prompt can not filter it.It shows complete list of department. Then i also created view adding where clause like business_unit=':1' then it shows no value.
How do i filter department value based on prompt :1 i.e. Business_unit? Any idea?
SELECT DISTINCT a.deptid deptid
FROM ps_job a
Edited by: user10569054 on Dec 3, 2012 11:13 AM
Edited by: user10569054 on Dec 3, 2012 11:15 AM
If Business unit is a prompt before the department prompt and the department prompt has both business unit and deptid as keys, then PeopleSoft will automatically take the higher level keys in lower prompts.
So make sure your keys are setup properly.