• If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Announcement

Collapse
No announcement yet.

Grid widget Filter only shows F3 table fields

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Grid widget Filter only shows F3 table fields

    I have a data source that is built from 3 tables (Left outer joins). On the Filters tab in the Grid Widget I only see columns from the F3 table and not F1 nor F2. I would like to filter on columns from all 3 tables.

  • #2
    Hi,

    What version of Valence 6.0 are you currently on? Could you supply the SQL statement for your data source? You can easily capture the full statement by clicking on the SQL button in the preview section.

    NAB Data Source Preview SQL.png

    Thanks

    Comment


    • #3
      Valence Version: 6.0.20210818.1

      This SQL is over a remote system.

      SELECT F1.IOCOMPLETE AS F1_IOCOMPLETE, F1.IOCREATETMST AS F1_IOCREATETMST, F1.IOHOSTWAVE AS F1_IOHOSTWAVE, F1.IOIRMSORDER AS F1_IOIRMSORDER, F1.IOOMSORDER AS F1_IOOMSORDER, F1.IORUNDATE AS F1_IORUNDATE, F1.IOSHIPDATE AS F1_IOSHIPDATE, F1.IOSTATUS AS F1_IOSTATUS, F1.IOUPDATETMST AS F1_IOUPDATETMST, F1.IOWAREHOUSE AS F1_IOWAREHOUSE, F2.PPCOMPANY AS F2_PPCOMPANY, F2.PPSCANSTATIONID AS F2_PPSCANSTATIONID, F2.PPSTATUS AS F2_PPSTATUS, F2.PPSTATUSTMST AS F2_PPSTATUSTMST, F2.PPTRADENAME AS F2_PPTRADENAME, F3.IAAUDTYPE AS F3_IAAUDTYPE, F3.IAECHO AS F3_IAECHO, F3.IAPROGRAM AS F3_IAPROGRAM, F3.IARECTYPE AS F3_IARECTYPE, F3.IASTSDESC AS F3_IASTSDESC, F3.IATMSTMPCR AS F3_IATMSTMPCR FROM OMSMODF."IRPKGIFL" AS F1 Left Outer Join OMSMODF."IBPPSHFL" AS F2 ON F2.PPIRMSORDER = F1.IOIRMSORDER Left Outer Join OMSMODF/ "IRAUDTV01" AS F3 ON F3.IAIRMSORDER = F1.IOIRMSORDER WHERE ( F1.IOSTATUS = '' and F1.IOCOMPLETE = 'N' ) ORDER BY F1.IOHOSTWAVE ASC, F1.IOIRMSORDER ASC
      Close

      Comment


      • #4
        We've confirmed this issue with the missing filter fields is specific to remote database connections with >1 table. We're looking into it.

        Comment

        Working...
        X