Currently, the Sublocation Of is not an available field to be exposed on a Location Saved Search. Note that the Sublocation Of is a standard field in a Location form with Internal ID = {parent}. However, using Formula (Text) = {parent} will return an error "field not found".
As an alternate solution, users can create the following Saved Search:
1. Navigate to Transactions>Management>Saved Searches>New
2. Select Location
3. On the Results tab add the following fields:
· Name where Summary Type = Group
· Formula (Text) = DECODE({systemnotes.field}, 'Child Of', {systemnotes.newvalue}) where Summary Type = Maximum and When Ordered By Field = System Notes: Date
4. Hit Preview or Save and Run
No comments:
Post a Comment