SQL to Domain Language - How?

I have been able to create numerous complex reports just by trial and error, but I'm now at an impasse. I only have domain access to create reports, so I cannot use basic SQL select statements.

I have a field called Load.TransportModeName and this field only contains 2 values ("LTL" and "TL"). I need an input parameter that asks the user to select one or both of these values.

Basically, what I need to accomplish is the equivalent of this (I think), but I need to do it at the query level:

SELECT * from Load where $X{IN,load.TransportModeName, param_TransitMode}


Would very much appreciate any assistance or guidance.

zgadson's picture
Joined: Sep 24 2018 - 11:24am
Last seen: 1 year 5 months ago


swood_1 - 4 years 2 months ago

1 Answer:

You can create a query based input control using the "Domain" query language.

See https://community.jaspersoft.com/documentation/tibco-jasperreports-serve...

for the domain query syntax, which is the same as what you have used in your reports.

swood_1's picture
Joined: Nov 15 2012 - 10:47am
Last seen: 2 years 10 months ago