December 21, 201114 yr Hey everyone; i have been looking but cant find a source here on FMFORUMS with regards to Portal search filter or the like. I have been using patterncount which is very slow over the network, but now want to learn how to filter using either a relationship or custom function or something else which is super fast. What i mean is user types '" i " and script trigger does what it has to do . any links please? thanks, -ian
December 21, 201114 yr Hi Ian, Here is a very simple example showing relational filter. The calculation and/or global fields you use will be determined by the values you want to filter. This example shows alpha restriction a...az for example so User could click buttons A - Z with only script parameter attached to each button with only the single alpha in it. Then script would set the global with the alpha. There are many techniques and variations but this is the first and most basic example to get this discussion started. SearchRelational.zip
December 21, 201114 yr Author Great LaRetta. Which method do you prefer? Clairvoyance seems to me the way to go right now for simplicity sake. Definately see a custom function coming for this though. -i You are so fast. I believe you and Comment are in a competition for who can "HELP the most!!"
December 21, 201114 yr Author Ok. So i have gotten the search down now and when an item comes up via a portal to select the item. i have a checkbox to select item The script is WhatAMI Go to Object [ Object Name: "Portal" ] Set Variable [ $me; Value:Product 3::product_Name ] Show Custom Dialog [ Message: $me; Buttons: “OK”, “Cancel” ] Quetion is. Can this be done better / cleaner or is this Good enough? thanks, -ian
December 21, 201114 yr I am in competition only with myself. There is no one-solution-fits-all here. You asked for a basic understanding user types '" i " and script trigger does what it has to do ... and you wanted it relationship-level and that is what I provided There are many techniques and variations but this is the first and most basic example to get this discussion started. I provided a simple, clear view of how relational keys (however you wish to implement them) can be used to strict ranges. :idunno:
December 21, 201114 yr Author I am in competition only with myself. There is no one-solution-fits-all here. You asked for a basic understanding ... and you wanted it relationship-level and that is what I provided I provided a simple, clear view of how relational keys (however you wish to implement them) can be used to strict ranges. OK . was just asking. Sorry to get you upset. OK . was just asking. Sorry to get you upset. Did i mention YOU ARE AWESOME!!! :laugh:
December 21, 201114 yr Did this signify I was upset? Or was it this ? The first is a thumbs up jovial gesture and the second is one of confusion; no 'upset' in the bunch. I was confused because you assumed it was a solution-to-be-posted-in-Tips&Techniques instead of a simple file to show a concept to someone asking how to use a relationship to filter a portal. Did i mention YOU ARE AWESOME!!! Nope. :laugh:
December 22, 201114 yr Author TriggerON.fp7.zip Hello Again. Lets continue the topic as i am stuck in a rut. I am trying to highlight the CHeckmark item on the right when user searched for item to signify it has already been selected. Dont know how to accomplish this. I have attached sample file -thanks -ian
December 22, 201114 yr What does "it has already been selected" mean? By definition, if your search function works, the items that appear in the portal are the ones that have been filtered.
December 22, 201114 yr Author TriggerON_SUCCESS.fp7.zip Hey Mr Robertson; This is my solution. Sometimes i can't really explain myself clearly. I have to work on that . HEre is what i came up thanks to your custom function. -ian here is my file- maybe that helps
December 22, 201114 yr I see that you are carrying on this conversation in two places (here and FMDEV) and you explained on FMDEV what you were actually looking for; but did not explain it here.
December 22, 201114 yr Author I see that you are carrying on this conversation in two places (here and FMDEV) and you explained on FMDEV what you were actually looking for; but did not explain it here. yes, i waited 8 hours to post on FMDEV though. so i had all day to think about the process, rather than 3am this morning when posting here not thinking about it at all.
Create an account or sign in to comment