Agentry : complex table data

[Former Member]

I've read many posts about complex data tables.  Has there been any advancements in the searching of the  complex table data?  I've tried using the complex table drop down, but the search is not a contains(for performance reasons i'm sure).  I've also tried using two fields , one as a string field and then tried to use that in the include rule, but the performance was bad there and essentially hung the application.

Has anyone seen any other options that might be suitable to try?  I have about 61K+ records in the complex data table.  I'm filtering down using the parent indexes but its just not filtering down enough.

Thanks in advance

[Marçal_Oliveras · Accepted solution]

Hi Heather,

Can you describe a bit more "not filtering down enough"?

In the past I implemented a kind of advanced search where the user can enter few parameters and with this I generate a reduced "collection" and I display it in a list where the user can filter using the native "contains" for tile list views.

If you need a "contains" when doing the first filtering, it's also possible using RFIND or Javascript (this second allows even multiple placeholders but it's difficult to implement) rule when looping over the complex table.

[Former Member · Accepted solution]

We have 61k+ material records .... the users want to be able to search the description of those using a contains. All the ways that I have tried have cause huge performance detriment to the application.  They are willing to filter down by type which we do today, but even they they want to be able to search using contains on the description string.

[sravanthi_polu · Accepted solution]

Hi,

Give a try using parent indexes.

Thanks&Regards,

Sravanthi Polu

[Former Member · Accepted solution]

I am using parent indexes to get to the list that is shown.  but when the list is shown they want to be able to search the list using a contains.

[bill_froelich · Accepted solution]

I think that you will want to use something similar to the Equipment or Funcational Location search that Work Manager has implemented.  This will be similar to what Marcal has outlined.

--Bill

[Former Member · Accepted solution]

Thanks BIll... this solution worked for us.