| passing parameters to apex url [message #571119] |
Wed, 21 November 2012 04:52  |
annu-agi
Messages: 238
Registered: July 2005
Location: Karachi
|
Senior Member |
 
|
|
dear experts
I made one APex page with interactive report and its working fine. But now i want to run apex page with giving parameters in URL. Existing Url doesnot contain any parameters so its look like
http://10.10.15.16:8080/apex/f?p=108:3:1548274790301025:::::
while p=108 is my application and 3 is my page.
here is my query which i use in this report, Right now my query is working without applying any parameters, so the result would be run on nvl() condition, and it gives all the data.
select ptm.bank_branch_code, to_char(ptm.acc_number) account_code, sum(nvl(ptdv.earning,0)-nvl(ptdv.deduction,0)) bank_amount,'C' CR_DR
from PR.pr_trans_mst ptm, cms.vhrms_empl ve, PR.pr_trans_dtl_v ptdv
where ptm.employee_no = ve.EM_CODE
and ptm.employee_no = ptdv.employee_no
and nvl(ptdv.omit,'x')<>'Y'
and ptm.bank_branch_code>6000 and ptm.bank_branch_code<7000
and nvl(ptdv.del_yn,'x')<>'D'
and nvl(ptm.stop_payment,'x')<>'Y'
and ptdv.fiscal_year=NVL(:P3_FISCAL_YEAR, ptdv.fiscal_year)
and ptdv.trans_month=nvl(:P3_TRANS_MONTH, ptdv.trans_month)
and ptdv.location_code=NVL(:P3_LOC_CODE, ptdv.location_code)
and ve.em_relg=nvl(:P3_RELG, ve.em_relg)
and ptdv.trans_type_row in ('R','A')
group by ptm.bank_branch_code, ptm.acc_number,ve.EM_RELG order by acc_number;
:p3_fiscal_year, :p3_trans_month, :p3_loc_code, :p3_relg are my parameters and it is already working fine in query. but i cant able to filter data by utilizing these parameters right now.
Now can anybody tell me how can i these parameters in above given URL?
also tell me i dont want to make any button over this report to proceed or submit, so is it works without giving button.
i just want to give URL with these parameters or nulls to this page and get my desired result.
Please give any idea or suggestion.
regards,
Anwer
|
|
|
|
|
|
| Re: passing parameters to apex url [message #571692 is a reply to message #571124] |
Thu, 29 November 2012 03:48  |
annu-agi
Messages: 238
Registered: July 2005
Location: Karachi
|
Senior Member |
|
|
hello experts,
still not solved, check my URL
http://10.10.15.16:8080/apex/f?p=103:1:4488099600766829::NO::P_LOC_CODE,P_FISCAL_YEAR,P_TRANS_MONTH:001,2012-2013,5
and i am getting error
Unexpected error, unable to find item name at application or page level.
Error ERR-1002 Unable to find item ID for item "P_TRANS_MONTH" in application "103".
OK
well, as i already mension in query that its a passing parameter to run my report, at that level should i make items by these names and place as hidden items on my page?.
But to submit i have to press submit button to process this report and to avoid this submittion i just want to make report and place my parameteres specified in query.
So i assume when i call report URL it just show report without asking parameters. Am I right?
so what is now i have to do ?
regards
Anwer
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
