GRID FILTER BUG

[himanshu]

WARNING

if you are reading this then this warning is for you

Hello Everyone,

Finding during some testing which is really disturbing. I like to request all members to test this case on their existing application too.

If it exists then this is really a big flaw in the current AwareIM version which needed a be fix ASAP.

Here is the use case:

There two business objects and they have a relationship between Parent and Child which is Owner and Owned by in AwareIM.

Example
-Customer
-Address

A customer has multiple relationships with Address, which means a customer could store more than one address.

Next, we have few customers in our databases and all have their respective addresses. When you view each customer object details it shows the customer and all addresses belonging to him. All good till now.

Customer Bob Details

bob_2018-08-13_17-42-54.png (17.14 KiB) Viewed 19878 times

Customer Himanshu Details

him_2018-08-13_17-43-25.png (16.54 KiB) Viewed 19878 times

Here comes the issue
Try to filter your address by any column sitting on any customer object using two condition filter. BOOM! It will show all the addresses in the system. looks like a filter is applied to all the addresses.

Showing Bug

bug_2018-08-13_17-45-32.png (47.67 KiB) Viewed 19878 times

I have tested on both relationship multiple (peer to peer) and (Owner to Owned), both have the same results.

I do not think this required any sample BSV but if still then I can attach over here.

Interesting to see responses!!

All test are performed on AwareIM 8.1 build 2467

[Jaymer]

CONFIRMED

[himanshu]

Thanks Jaymer for confirming.

Either people are still sleeping and need to be awaked that if they are running on version 8+ they are high value target

[Jaymer]

from further testing...

1) the grid search is def. broke when being on a Form, showing a Grid widget, AND filtering on the Grid using an OR condition ON THE SAME FIELD

2) i'm trying it on production data. I'm on a Tenant form, which has om_users
In that grid of users, there are 19.

there is only 1 Tom and 1 Ann
if I search for Tom or Ann, then I get 20 recs, including 1 from another Tenant (found a Tom in another tenant)

If I search for Ann or Mary, then I get 20 recs, and a Mary from a different Tenant.

I'm definitely NOT seeing ALL DATA from ALL TENANTS (which would be EXTREMELY BAD)... but def. some logic is messed up.

[himanshu]

It will bring all your tenant data also, I have tested this. You just need to change some filter values on both condition to satisfy all records.

Example
FIND Object WHERE Object.Name CONTAINS 'a' OR CONTAINS 'b'

[Rennur]

Are records visible even if READ PROTECTED by tenant firewall BO rules, as shown in the tenant tutorial video?

[himanshu]

Hi Rennur, I do not think READ PROTECTED does going to effect. It still going to show all the records.

[weblike]

OMG....this is a serious problem...
Does Support knows about this?

[aware_support]

This will be fixed in the next build

[himanshu]

Minor bug on grid header, column icon is not showing.

grid columns

icon_label_2018-08-17_08-56-22.png (3.03 KiB) Viewed 19737 times

[aware_support]

The problem should be fixed in build 2469

[himanshu]

Thanks Support, will have a look.