halbj Posted December 21, 2001 Share Posted December 21, 2001 2 db's, Contacts.fp5 and Interests.fp5 - related 1-M by Contact ID. I want find all contacts that have both sailing AND skiing as there interests. If i do multiple find requests from either db, I get sailing OR skiing. Is there a way I can use boolean in a portal field in a find request? Cheers Hal. Link to comment Share on other sites More sharing options...
BruceJ Posted December 21, 2001 Share Posted December 21, 2001 I beleive that if you go into your Contacts file and go to a protal of the Interests, enter Find Mode, then enter "sailing", Choose DUPLICATE Find, then change Sailing to Skiing, it will result in a AND type of find. Link to comment Share on other sites More sharing options...
halbj Posted December 21, 2001 Author Share Posted December 21, 2001 Thanks Bruce That doesn't work. I have tried multiple find request - this emulates an "or" condition. If I create an identical portal with it's own (identical) relationship it will work. But this is not satisfactory - not only is it cruddy interface design, irf I want to do a similar find with 3 or 4 or more criteria, i would need that many portals and relationships (No thanks!). I am after something a little more dynamic. Link to comment Share on other sites More sharing options...
halbj Posted December 21, 2001 Author Share Posted December 21, 2001 Aha!!! Sometimes I excel myself! If I : 1.Go to the Interests db and set the clint ID feild to "!" (Duplicates) then set the interest field to "Sailing" 2. Create another find request and set the client ID to "!" then set the interest feild to "Skiing" 3. Perform the find - hey presto! Surely that little puppy deserves a star? Link to comment Share on other sites More sharing options...
Thom Posted December 21, 2001 Share Posted December 21, 2001 That will find all contacts who have more than two interests, one of which is either skiing or sailing. Create two contacts, one interested in skiing and camping, the other interested in sailing and running. Your search will find both. The work-around is one of the few legitimate uses of repeating fields. In the INTERESTS file create a calc field: interestRepeating(calc,text,repeating)=interest Give it as many repetitions as you have portal rows. In CONTACTS create a layout just for searching. Duplicate the interests layout, and replace the portal with the repeating field, showing all repetitions, sized about the same as the portal. In Find mode you can search the repeating field for as many interests as you have repetitions. Only contacts who have all of those interests will be found - an AND search. Link to comment Share on other sites More sharing options...
halbj Posted December 24, 2001 Author Share Posted December 24, 2001 But doesn't this only calculate the first related record? How do you get it to calc consecutive related records in to the repititions? Link to comment Share on other sites More sharing options...
Thom Posted December 26, 2001 Share Posted December 26, 2001 It doesn't matter. The repeating field is only for searching. After the Perform Find, the script should take you back to the portal layout for browsing. When you search a repeating field, criteria entered in any of the repetitions will be searched for in all repetitions. Link to comment Share on other sites More sharing options...
Newbies krswitky Posted December 26, 2001 Newbies Share Posted December 26, 2001 Here's a slight variation on the original question. I am new to portals and am unsure how to do a different kind of find. Same basic setup - an individuals db, and a donations db, related by ID number. In the individual db I have a portal that shows that person's donations. I would like to do a find on all donations of a certain size in a certain date range (again, an "AND" request, but of a different sort). If I request find date>1/1/2001 and gift size>99, I get records for any individuals who made a gift (of any size) >1/1/2001 OR who made a gift (at any time) >99. Is there a way to do the "And" find I'm looking for? (I'm hoping I'm missing something basic here!) Many thanks--Kathy Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8155 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