Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2742

Dataroles editor not updated when row filter added

    XMLWordPrintable

    Details

    • Steps to Reproduce:
      Hide
      1. Import the attached project
      2. open the VDB, switch to Data Roles tab
      3. click the Add data role button to open the Data Roles editor
      4. allow update on the whole model
      5. disallow read on the whole model
      6. allow read on t1.c1
      7. allow read on t2.c1
      8. switch to Row Filter tab
      9. click Add, select t1 as target
      10. set c2='x' as Condition
      11. click OK
      12. click Add, select t2 as target
      13. set c2='x' as Condition
      14. click OK, notice the new row filter does not appear in the list

      Note that the row filter that disappears is determined by the order in which you allow read on the columns, i. e. if you first allow read on t2.c1, the filter for t1 will disappear.

      Show
      Import the attached project open the VDB, switch to Data Roles tab click the Add data role button to open the Data Roles editor allow update on the whole model disallow read on the whole model allow read on t1.c1 allow read on t2.c1 switch to Row Filter tab click Add, select t1 as target set c2='x' as Condition click OK click Add, select t2 as target set c2='x' as Condition click OK, notice the new row filter does not appear in the list Note that the row filter that disappears is determined by the order in which you allow read on the columns, i. e. if you first allow read on t2.c1, the filter for t1 will disappear.
    • Workaround:
      Workaround Exists
    • Workaround Description:
      Hide

      Close the Data Roles editor and reopen

      Show
      Close the Data Roles editor and reopen

      Description

      When adding Row Filter to a table, the list of filters is sometimes not updated. See Steps to reproduce for once such scenario. Closing the Data Role editor and reopening shows the correct row filters.

      Also, in the Security column on the Model tab, the circle indicating a row filter is 'on' for the filter that does not appear in the row filter list and is 'off' for the one that does.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  blafond Barry LaFond
                  Reporter:
                  asmigala Andrej Smigala
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: