Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #1716 > unrolled thread

Search Portal etc

Back to article view | Back to comp.databases.filemaker

Contents

  Search Portal etc JayBee <Jennifer_Beecroft@hotmail.com> - 2014-02-11 06:24 -0800
    Re: Search Portal etc "E. Appeldoorn" <ursus.kirk@ziggo.nl> - 2014-02-11 22:21 +0100
      Re: Search Portal etc John G <greentest@ozemail.com.au> - 2014-02-12 11:00 +1100
        Re: Search Portal etc "E. Appeldoorn" <ursus.kirk@ziggo.nl> - 2014-02-12 09:25 +0100
          Re: Search Portal etc Martin Τrautmann <t-usenet@gmx.net> - 2014-02-12 09:32 +0000
            Re: Search Portal etc Martin Τrautmann <t-usenet@gmx.net> - 2014-02-12 09:34 +0000
    Re: Search Portal etc Thibaud Taudin Chabot <tchabot@hccnet.nl> - 2014-02-12 10:24 +0100

#1716 — Search Portal etc

Hello Erik Appeldorn

You gave me a technique for creating a search portal once; for searching for products in a db via a search portal.  'Search' is a T.O. related to the original product db.  Relationship exists via the following text calculation functions.

searchstring (but with every space character replaced with a carriage return) <= searchstringzzzzzzzzzzzzzz
AND
searchstring (but with every space character replaced with a carriage return) >= searchstring . 

I've used it before and it's worked ok , but for my current data set of products - it seems to be working in a wierd way.. I don't know what I'm missing or I've done wrong!  I've matched all the calcs and relationships etc to my prvious solutions.

However for example in this solution , for the following product description:

AM Slim Med Eco Stripe - AM00597

I would expect to be able to search on any of those words and be returned the correct result.  However only the product code entered as: 'AM00597' returns the correct result!  In reality the user will never have the product code to search with but only a description.

'AM' Strangely returns no products even though that is the beginning description of more than several products stored in the db.

'SLIM' returns nothing! 

'AM SLIM' returns nothing etc.

I hope somebody can help

Thanks
J

[toc] | [next] | [standalone]

#1717

JayBee schreef op 11-2-2014 15:24:

Answered in a PM

Erik

> Hello Erik Appeldorn
>
> You gave me a technique for creating a search portal once; for searching for products in a db via a search portal.  'Search' is a T.O. related to the original product db.  Relationship exists via the following text calculation functions.
>
> searchstring (but with every space character replaced with a carriage return) <= searchstringzzzzzzzzzzzzzz
> AND
> searchstring (but with every space character replaced with a carriage return) >= searchstring .
>
> I've used it before and it's worked ok , but for my current data set of products - it seems to be working in a wierd way.. I don't know what I'm missing or I've done wrong!  I've matched all the calcs and relationships etc to my prvious solutions.
>
> However for example in this solution , for the following product description:
>
> AM Slim Med Eco Stripe - AM00597
>
> I would expect to be able to search on any of those words and be returned the correct result.  However only the product code entered as: 'AM00597' returns the correct result!  In reality the user will never have the product code to search with but only a description.
>
> 'AM' Strangely returns no products even though that is the beginning description of more than several products stored in the db.
>
> 'SLIM' returns nothing!
>
> 'AM SLIM' returns nothing etc.
>
> I hope somebody can help
>
> Thanks
> J
>


-- 
met vriendelijke groeten,
Erik Appeldoorn

[toc] | [prev] | [next] | [standalone]

#1719

E. Appeldoorn formulated the question :
> JayBee schreef op 11-2-2014 15:24:
>
> Answered in a PM
>
> Erik
>
>> Hello Erik Appeldorn
>>
>> You gave me a technique for creating a search portal once; for searching 
>> for products in a db via a search portal.  'Search' is a T.O. related to 
>> the original product db.  Relationship exists via the following text 
>> calculation functions.
>>
>> searchstring (but with every space character replaced with a carriage 
>> return) <= searchstringzzzzzzzzzzzzzz
>> AND
>> searchstring (but with every space character replaced with a carriage 
>> return) >= searchstring .
>>
>> I've used it before and it's worked ok , but for my current data set of 
>> products - it seems to be working in a wierd way.. I don't know what I'm 
>> missing or I've done wrong!  I've matched all the calcs and relationships 
>> etc to my prvious solutions.
>>
>> However for example in this solution , for the following product 
>> description:
>>
>> AM Slim Med Eco Stripe - AM00597
>>
>> I would expect to be able to search on any of those words and be returned 
>> the correct result.  However only the product code entered as: 'AM00597' 
>> returns the correct result!  In reality the user will never have the 
>> product code to search with but only a description.
>>
>> 'AM' Strangely returns no products even though that is the beginning 
>> description of more than several products stored in the db.
>>
>> 'SLIM' returns nothing!
>>
>> 'AM SLIM' returns nothing etc.
>>
>> I hope somebody can help
>>
>> Thanks
>> J

Whatever is a PM? :-Z
One of the benefits of newsgroups is that lots of us learn things for 
latter without haveing to ask the qestion. :-?

-- 
John G

[toc] | [prev] | [next] | [standalone]

#1720

John G schreef op 12-2-2014 01:00:
> E. Appeldoorn formulated the question :
>> JayBee schreef op 11-2-2014 15:24:
>>

>>> 'AM SLIM' returns nothing etc.
>>>
>>> I hope somebody can help
>>>
>>> Thanks
>>> J
>
> Whatever is a PM? :-Z
> One of the benefits of newsgroups is that lots of us learn things for
> latter without haveing to ask the qestion. :-?
>

John, a PM is a private mail. JayBee and I discussed this privately way 
before. She just wasn't sure about were to reach me now and tried my 
mailaddress and the newsgroup. But if you are interested: this is what I 
answered.

Hi Jenny, I can't exactly tell what you might have done.
Trying to recreate what youve done. But it seems you might have mistyped.

cFields are calculated field, returning text in this case)

Table ( Main)
Fields
cProductname ( "some¶product¶name¶and¶number")
gSearch = global textfield to hold the searchpattern
cFA = Case ( not IsEmpty ( gSearch ) ; gSearch ; 
"a¶b¶c¶d¶e¶f¶g¶h¶i¶j¶k¶lm¶n¶o¶p¶q¶r¶s¶t¶u¶v¶w¶x¶y¶z" )
cFZ= gSearch & "zzzzzzzzzzzzzz"

Create A T.O. of MAIN and call it searchMain
create a relation between cFA and cProductname. set the option to <= 
(cFA <= cProductname)
in the same window now add
cFZ >= cProductname

That should do it. If in doubt try it on an empty (new) file first, that 
makes is so much simpler to debug.

I might add that with newer FMP versions there are more flexible options 
now. If you have script triggers then you will also have Filtered 
Portalrecords. Both can be combined very fluently (but that is a 
personal opinion)
The cFA cFZ version does still work, but I have fazed it out for new 
solutions almost completely.

Did this solve the problem?

-- 
met vriendelijke groeten,
Erik Appeldoorn

[toc] | [prev] | [next] | [standalone]

#1722

On Wed, 12 Feb 2014 09:25:22 +0100, E. Appeldoorn wrote:
>  John, a PM is a private mail. JayBee and I discussed this privately way 
>  before. She just wasn't sure about were to reach me now and tried my 
>  mailaddress and the newsgroup. But if you are interested: this is what I 
>  answered.

thanks for sharing.

>  Hi Jenny, I can't exactly tell what you might have done.
>  Trying to recreate what youve done. But it seems you might have mistyped.

Hm, I wonder what your solution is for - personally, I'd try to find out
first why the search does fail. The usual answers are

* search within the wrong field
* field with wrong field type (usually number instead of text)

... or for a search within a portal: broken relations. 
There a first step would be to find out whether a search within related
data does work, then recheck the relations.

- Martin

[toc] | [prev] | [next] | [standalone]

#1723

On Wed, 12 Feb 2014 09:32:32 +0000 (UTC), Martin Τrautmann wrote:
>  Hm, I wonder what your solution is for - personally, I'd try to find out
>  first why the search does fail. The usual answers are
> 
>  * search within the wrong field
>  * field with wrong field type (usually number instead of text)

Oh, and one more: replacing spaces by the incorrect replacement - e.g.
replacing space by non breaking space.

For a search there's no need to replace a space by a paragraph mark. 
That's just good for indexing and then for value lists from field
contents (and thus its index).

- Martin

[toc] | [prev] | [next] | [standalone]

#1721

JayBee schreef op 11-2-2014 15:24:
> Hello Erik Appeldorn
>
> You gave me a technique for creating a search portal once; for searching for products in a db via a search portal.  'Search' is a T.O. related to the original product db.  Relationship exists via the following text calculation functions.
>
> searchstring (but with every space character replaced with a carriage return) <= searchstringzzzzzzzzzzzzzz
> AND
> searchstring (but with every space character replaced with a carriage return) >= searchstring .
>
> I've used it before and it's worked ok , but for my current data set of products - it seems to be working in a wierd way.. I don't know what I'm missing or I've done wrong!  I've matched all the calcs and relationships etc to my prvious solutions.
>
> However for example in this solution , for the following product description:
>
> AM Slim Med Eco Stripe - AM00597
>
> I would expect to be able to search on any of those words and be returned the correct result.  However only the product code entered as: 'AM00597' returns the correct result!  In reality the user will never have the product code to search with but only a description.
>
> 'AM' Strangely returns no products even though that is the beginning description of more than several products stored in the db.
>
> 'SLIM' returns nothing!
>
> 'AM SLIM' returns nothing etc.
>
> I hope somebody can help
>
> Thanks
> J
>
and 'Slim' or 'AM Slim'?

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.filemaker

csiph-web