Search summary

[Spice]

Hello All

I've been tryng to implement a search summary field that would return:

"Results of your search for 'Red' and 'New' and '1999' has returned 299 items"

I've tried with a SetField script with calculation which sets a "Search summary" field with contents of the Find window. This returns nothing when run as part of a Find script but runs OK in browse mode. All I need is the values entered by the user in Find mode.

Any ideas?

Thanks

[Søren Dyhr]

I think I need to get it established, if the search really is a AND search, and this means either "Constrain Found Set" is used extensively or all criterias are made inside the same request???

--sd

[Spice]

Thanks for the reply Copenhagen.

The search request is all from one 'Search' layout which is accessed in Find mode. Its actually a normal find with several criteria.

My script within the search script is:

If ( Product Catalog::Brand > 0 ; "Brand: " & Product Catalog::Brand & ¶ ; "" )

&

If ( Product Catalog::Date > 0 ; "Date: " & Product Catalog::Date & ¶ ; "" )

.... etc

Should I be using Constrain Found Set instead?

Thanks from Paris

Edited July 22, 2006 by Guest

[Søren Dyhr]

Should I be using Constrain Found Set instead?

No it's different fields so it's just one request, but there are something wrong in you message calculation, neither Brand which I expect is text as format nor Date makes much sence in your shown calculation why compare the field value of current record with 0???

The straight forward method is to display the result of the search as a subsummary report without the body or a dialog box. Is the calc of yours meant for such a dialog ...if so needs Get(FoundCount) have a place in the calc' instead of > 0 ...

Well, I still have too little to go on!

UPDATE - Alright after reading your question again, have I made a template I think must be what you're after provided the users keep away from multiple requests.

--sd

make.zip

Edited July 22, 2006 by Guest

[Spice]

Thanks for the example. I've studied it carefully and am begining to understand the $ concept - powerful stuff!

I'm running your script within my search script (attached below) but the calc only returns the FoundCount not the search criteria. I think this is a problem with my portion of the script, not yours! Do I specify a first field in 'GoToField [select/Perform]' ?

Thanks again, I'm getting there I think...

EDIT:

I just noticed that your script was running AFTER my change of layout. Everything is working fine now.

Thanks for the lesson.

Edited July 22, 2006 by Guest