uruj.pruthi Posted June 16, 2017 Share Posted June 16, 2017 How to use two strings in wildsearch in Jasper report. For example, I want to search all projects where "Project" string appears and "6" appears in Project name filter (say) Link to comment Share on other sites More sharing options...
reportdev Posted June 16, 2017 Share Posted June 16, 2017 $F{PROJECT}.contains( "Project" ) && $F{PROJECT_NAME}.contains("6") == trueThis would be your filter expression. <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.2.0.final using JasperReports Library version 6.2.0 --><!-- 2017-06-16T08:50:38 --><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="stringsearch" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="e5118725-35ac-481b-946a-e789d71ccba1"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <queryString> <![CDATA[select 'Project1' as project, 'tango6' as project_name from dual union allselect 'Project2' as project, 'tango1' as project_name from dual]]> </queryString> <field name="PROJECT" class="java.lang.String"/> <field name="PROJECT_NAME" class="java.lang.String"/> <filterExpression><![CDATA[$F{PROJECT}.contains( "Project" ) && $F{PROJECT_NAME}.contains("6") == true]]></filterExpression> <background> <band splitType="Stretch"/> </background> <columnHeader> <band height="20" splitType="Stretch"> <staticText> <reportElement x="0" y="0" width="80" height="20" uuid="75dad88e-bc31-4c3e-b683-93a946461cdd"/> <text><![CDATA[PROJECT]]></text> </staticText> <staticText> <reportElement x="80" y="0" width="100" height="20" uuid="99b3ffd4-8933-4cae-8a38-4783d2a987e4"/> <text><![CDATA[PROJECT_NAME]]></text> </staticText> </band> </columnHeader> <detail> <band height="20" splitType="Stretch"> <textField> <reportElement x="0" y="0" width="80" height="20" uuid="aa79fb4e-a0ca-4b9a-9571-c4c3f62c2c35"/> <textFieldExpression><![CDATA[$F{PROJECT}]]></textFieldExpression> </textField> <textField> <reportElement x="80" y="0" width="100" height="20" uuid="00ede68c-888c-4c4d-9e8a-904bda313d20"/> <textFieldExpression><![CDATA[$F{PROJECT_NAME}]]></textFieldExpression> </textField> </band> </detail></jasperReport> Link to comment Share on other sites More sharing options...
uruj.pruthi Posted July 28, 2017 Author Share Posted July 28, 2017 Thank you. But I wanted to wildsearch for end users on application side. For example, In CA PPM we can serach like Project Name by *PRJ*89But in Jasper filter, we need to write exact like PRJ-1089 to search. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now