DEVELOPERS FORUM - Filter or search records on main grid for property whose datatype is Item

AshokGopale - Monday, July 30, 2012 5:59 AM:

Dear ARAS users,

I want to search or filter by typing criteria in main grid.

I can search records on property whose datatype=String.

But when I try to search a column whose datatype=Item then I type ItemID value in search criteria. but search yields no records.

Hope you have understood my question.

Thanks,

Ashok

fli - Wednesday, August 1, 2012 10:45 AM:

Hi Ashok,

Try creating a second property with Data Type = Foreign, set this property's Data Source = " the item for which you want to filter/search"

Then set the Foreign Property attribute for the newly created property = " the property for which you want to filter/search "

BR / Christoffer 

AshokGopale - Friday, August 3, 2012 3:56 AM:

Hi  Christoffer,

It works perfectly as I mentioned in my question. It solves some of my scenarios.

Thank you very much.

However,

Two questions :

1)  It gives following error when I refer the foreign property data source = "property of another Item but with data type=foreign".

    that means I want to search filter on property which is referenced from Parent of Parent Item.

    First Level Parent Item --->A (Property-A1)

    Second Level Parent Item B --->( Property B1 foregin data source=A1)    ==> It works

    Third level Item C ---> (property C1 foregin data source=B1) ===> It fails

     I want to search on property A1 in Grid of Item C.

  Error :Ambiguous column name 'assemblyid'. A column has been specified more than once in the order by list. Columns in the order by list must be unique

2) Does this addition of one more property (whose data type=foreign) gives additional workload on database on Developer's view, OR Is it maintained by ARAS    

    itself.

Thanks again !

Best Regards,

Ashok