Newbies peeel Posted December 12, 2008 Newbies Share Posted December 12, 2008 Been reading the forums, learning a lot! But have not been able to figure out how to show a filtered view of records in a layout. I have a product table with a sale type field that can have either 'Software' or 'Hardware' for each product. I want to create two layouts, one showing only software and one showing hardware. A script to run a find to filter for only software when the user opens the layout works but when the user performs a find on the layout it undos the filter. Anyway to only show Software records in a layout? Sounds simple, can't wait to learn how to do this. Link to comment Share on other sites More sharing options...
bcooney Posted December 12, 2008 Share Posted December 12, 2008 Welcome! You have a few options: 1. Create a layout with a tab panel that has 2 tabs. In tab1, put a portal filtered by "Software" to your product table. In tab2, put a portal filtered by "Hardware" to your product table. 2. Create a list view, and put two buttons "hard-coded" with a Constrain. So, a user does a find and then clicks "HW Only", which constrains the found set to products of type Hardware. Likewise for Software. Link to comment Share on other sites More sharing options...
Søren Dyhr Posted December 12, 2008 Share Posted December 12, 2008 1. Create a layout with a tab panel that has 2 tabs. In tab1, put a portal filtered by "Software" to your product table. In tab2, put a portal filtered by "Hardware" to your product table. Well the entire problem arises when a found set is established, filtered portals knows nothing about the the found set. Eventthough one of the portal criterias might be a calc' field using a CF to aggregate the found set, will only fields where and if such an aggregation is scripted, actually change the found set shown in the portal. So when it has to be scripted anyway could it just as well be the constrained set as you second suggestion. The big problem is that an urgent requirement is that navigation only are under script control ... the end user should be deprived the native navigation found in the status area. --sd Link to comment Share on other sites More sharing options...
Newbies peeel Posted December 19, 2008 Author Newbies Share Posted December 19, 2008 Thanks, bcooney for providing 2 potential solutions. Apologize for the delay in responding as I am traveling currently. I think I will go with the 2nd solution and create two buttons to run scripts to constrain the found set. Thanks again. peeel Link to comment Share on other sites More sharing options...
bcooney Posted December 19, 2008 Share Posted December 19, 2008 Remember, if you Constrain by Hardware, then try to Constrain by Software--you'll get no records. Constrains are usually preceded by a Find. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5745 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now