Getting 'Non SUpported SQL92 token' error messages

0

I has a SQL query that has 4 Jasper praemeters. Everything was working fine until i chnaged one of the paramters $P to $X(IN). I need the user to be able to select from a list of values rather than just entering a single value. The problem seems to be arount the 'WHERE $X{IN' statement.  Anyone have any ideas?

select UPPER(st.aud$user) Technician,
       substr(n.name_last,1,15)||' '||substr(n.name_first,1,15) DonorName, 
       st.donor_id donorId,
       dn.donor_number Donor,
       v.visit_date  VisitDate,
       v.visit_number VisitNumber ,
        st.scrntype_id,
      (select stt.code from stdnr.screening_test_types stt where st.scrntype_id = stt.id) ScreeningCode,
       d.birth_date DonorBirthDate
from stdnr.aud$screening_tests ST,
     stdnr.visits V,
     stdnr.donors D,
     stdnr.donor_numbers DN,
     stdnr.names N
WHERE $X{IN, ST.AUD$USER, TECHNICIAN}
    and st.visit_id = v.id
    and v.donor_id=d.id
    and d.id = dn.donor_id
    and d.id = n.donor_id
    and v.visit_date between  $P{VISITFROM} and $P{VISITTO}
   and  (select stt.code from stdnr.screening_test_types stt where st.scrntype_id = stt.id) = UPPER($P{SCREEN}) 
  
  order by technician,donorname  , visitdate
jkeri's picture
34
Joined: Mar 15 2013 - 12:17pm
Last seen: 3 weeks 4 days ago

1 Answer:

0

Is ST.AUD$USER an actual field name or a variable?

FIY, specification is next:

http://jasperreports.sourceforge.net/sample.reference/query/index.html#q...

dnaboka's picture
70
Joined: Jun 8 2012 - 1:18am
Last seen: 2 days 2 hours ago
Feedback
randomness