Hello Friends;
Good day. I am stuck from 2 days to pass the parameter in where clause like
SELECT
maindata.`Id` AS maindata_Id,
maindata.`Maincat` AS maindata_Maincat,
maindata.`Subcat` AS maindata_Subcat,
maindata.`location` AS maindata_location,
maindata.`unit` AS maindata_unit,
maindata.`oem` AS maindata_oem,
maindata.`model` AS maindata_model,
maindata.`serial` AS maindata_serial,
maindata.`asset` AS maindata_asset,
maindata.`rating` AS maindata_rating,
maindata.`po` AS maindata_po,
maindata.`details` AS maindata_details,
maindata.`doi` AS maindata_doi,
maindata.`manufacture` AS maindata_manufacture
FROM
`maindata` maindata
where $P{Param1}=$P{VarLoc1}
If i pass the column name after where its works suppose WHERE UNIT=$P{VarLoc1}
NOW I WANT TO PASS THE COLUMN NAME ALSO WHUCH IS SELECT BY THE USER TO SEARCH THE SPECIFIC RECORD LIKE IF HE WANTS TO SEE THE DATA AGAINST COLUMN model .
but the above query is not working. I also use the $X {IN,Param1,VarLoc1} but all the column are varchar and both parameters are Java.Lang.String
Please guide me how i pass the column name in where clause?
Regards