Search in portal

[deepakgupta]

HI,

Can we perform search in portal.if yes then plz suggest me can i do this.

Thanks,

Deepak

[Ocean West]

Yes you can do this however depending on the data (un-stored) it could take longer to find - and in some cases being on a network you may get the progress bar when doing such searches. Especially when searching on multiple fields and or fields in the current table.

Sometimes I create a scripted approach where you use global fields of the fields you wish to search on, then go to the underlying table perform a search there if it finds something us the GTRR showing all, then constrain the search further, with the local fields.

[Tony Martin]

Mr. West - can you expand on this? I am also trying to search for data using criteria from my existing table (a date) and also searching in a portal for "empty" records within that portal.

In other words, I'm trying to find records that don't have data in the portal (so I can resubmit the data request to the appropriate vendor).

Tony

[Ocean West]

if you are searching for empty values in a field on a record in the related table or are you trying to find records that don't contain children records?

If you are searching for empty data on records in the related table. Then create a calculation in that table: Field = isEmpty( yourField ) then search your local date and a 1 in that new calc field.

if you are searching for records on a data that have no children records then you can create a field in the local table that counts the primary key in the children table.

if you are trying to find records across several tables here is an excellent technique

http://seedcode.com/cp-app/ste_cat/fmsearchresults

[Zimbo]

Hi Stephen,

I was wondering, do you happen to have an example of the searching in a portal method you mentioned. I have a portal that i would like to seach in and would appreciate any assistance.

If you require any further info, please give me a shout.

Cheers

George