Jump to content
  • $X{IN, TASK_ISSUER_CD, TASK_ISSUER}


    mwolven
    CategoryGeneral
    PriorityImmediate
    ReproducibilityAlways
    ResolutionNo Change Required
    SeverityBlock
    StatusResolved

    Is it possible to use that syntax in a WHERE clause, when the field: TASK_ISSUER_CD is not in the SELECT?

     

    Having TASK_ISSUER_CD in the SELECT creates too many non-unique rows.



    User Feedback

    Recommended Comments

    Changed Resolution from Open to No Change Required

    Changed Status from New to Resolved


    WHERE $X{IN, TASK_ISSUER_CD, TASK_ISSUER} is translated into WHERE TASK_ISSUER_CD IN (..values from TASK_ISSUER..)JasperReports and Jaspersoft Studio do not have any requirements on TASK_ISSUER_CD. If the DB engine allows WHERE TASK_ISSUER_CD IN (..) without having TASK_ISSUER_CD in SELECT, then it should work in JR and JSS as well. If the DB engine does not allow it, then there's nothing JR and JSS can do to make the query work.Regards,LucianPS: Please use the Answers section for questions. Trackers are for bugs and feature requests.
    Link to comment
    Share on other sites


×
×
  • Create New...