Is there any way to filter records on a layout through relationships without using the Go to Related Record script step? The reason I'm trying to do this is when using Quick Find on a layout it searches through all records regardless of the relationships made. Is the only way around this to use Omit Record?
I have a table for Orders and an order can have multiple statuses. I'd like to create a layout for two of the statuses and omit the remaining. I've created the relationships and Go to Related Record accomplishes what I need but Quick Find is performed on all records and unfortunately performance suffers as the number of records increases.
Here is the self-self relationship:
If I wanted to filter a portal to exclude zero balances and exclude transaction type 'Payment' I could do so like this:
instead of two layouts, one for status a and one for status b just use one layout with buttons or exposed scripts that perform a scripted find to show status a or status b
Script prototype...
enter find mode
set status field = a
set error capture = on
perform find
set error capture off
If ( get( FoundCount) = 0 then...
else
end if
exit script
ps it is good practice to turn quick find off for fields that you do not want to actually include when a user does quick find.
turning quick find on causes an index to be built for the field and can cause file size to grow when not necessary.
Only set quick find for what you know your users will need on any given layout.