Omitting Records from a search

[mindtpi99]

Hi

I want to use a url like this;

http://mydomain/FMPro?-db=mydatabase.fp5&-layout=detail&-format=results.htm&-error=search.htm&materialstatus=searchtermtofind&-sortfield=destinationsort&-sortorder=ascend&-find

to find a set of records but to omit a specific value in searchtermtofind - in this case I want to find every record other than ones with "Completed" in the JobStatus field. I thought I might be able to use something like -LOP=neq etc, but according to the CDML reference this only works AND & OR. I can do it by creating another calculation field to search on but would rather do it this way - any ideas?!

[FMPBrad]

Hello,

Since "Completed" is the only value you wish to avoid, could you find all your records with "Completed" values then omit them.... then return those results?

I don't think that CDML has an "-omit" tag, so it would have to be scripted (trigger using "-script=omitThem").

... an idea.

Bradley

[Unable]

Bradley, using ScriptMaker is not advised in web solutions because of the issues involving ScriptMaker events. If you will spend a bit of time looking on these Internet forums searching for ScriptMaker, you will find the issues have been widely discussed.

The way to handle an "-omit" without an available "-omit" tag is to use the tools which are available. Refer to the CDMLRD. Study the options which are offered for use on the results.htm, specifically the use of [FMP-If:] conditional tags to control what is displayed.

[FMPBrad]

Unable,

Indeed using any script to iteriate through records doing anything would be a performance drain to the DB, but a simple omit wouldn't be too costly, I would think.

On the other hand, if you could remove any amount of data sent to the WC then that could also be a network savings, particulary since the WC is a single-thread process... does that sound right?

Do you recommend a good discussion thread regarding the ScriptMaker / Internet usage events issue?

Thank you ,

Bradley

[Garry Claridge]

What about "-op" and "neq". E.G. "&-op=neq&jobstatus=Completed&-find"

Good Luck.

Garry

[Anatoli]

RE: "Completed" in the JobStatus field

And/or you can use simple calculation field in FM which will have IF JobStatus <> Completed = YES

Then you just search for YES