i've used similar code below run "public" peoplesoft queries excel using vba. when @ hyperlink produced code below, similar public queries run method. difference "private" query. can manually run query in peoplesoft these same prompts , runs , produces results supposed (32 rows). however, when run code excel, peoplesoft opens, sign in , looks query runs. however, doesn't return results (0 rows). there twist running "private" queries. not possible run "private" queries method? suggestions appreciated has stumped. help......
we using excel 2010, peoplesoft 9.1 , peopletools 8.52 if helps
dim vfromacct date dim vtoacct date vfromacct = "07/01/2016" vtoacct = "07/21/2016" vfromacct = format(vfromacct, "mm/dd/yyyy") vtoacct = format(vtoacct, "mm/dd/yyyy") vhyproot = "http://pswebfsprd.myco.com/fsprd_1/employee/erp/q/?icaction=icqrynameexcelurl=private.car_sales_1" vhyplnk = vhyproot vhyplnk = vhyplnk & "&bind1=" & vfromacct vhyplnk = vhyplnk & "&bind2=" & vtoacct worksheets("sheet1") .hyperlinks.add .cells(10, 1), vhyplnk .hyperlinks(1).follow newwindow:=false, addhistory:=true end
if getting 0 results query running. believe problem date parameters. able run private query date parameter had use date in yyyy-mm-dd format.
&bind1=2016-07-21 this on db2 may different db. if need use format slashes in it, ensure encode url before submitting it. here stack overflow question on urlencoding in vba
my full url was:
https://dev.removed.com/psp/mydev/employee/erp/q/?icaction=icqrynameurl=private.test_ds&bind1=2016-07-21 note: on peopletools 8.54.13 should work on 8.52
Comments
Post a Comment