Jor简报表sql传参数

url中传参数：

http://localhost:8080/jor/reportviewer?file=E:/study/report_new/%E8%AF%95%E…tml&projectId=8a8bb3f057ebd2f10157fee0a5550042&credentials=gedge&ename=ger 

sql中接收：

  ${has(projectId)?
        (
            " AND te.project_id = '"+projectId+"' "
        ):" "}

   ${has(ename)?
        (
            " AND te.ename LIKE '%"+ename+"%' "
        ):" "}

    ${has(credentials)?
        (
            " AND te.credentials_company_project LIKE '%"+credentials+"%' "
        ):" "}

如上所示，在where条件中添加即可