Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 7263 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

What is the best way to have a URL that will find multiple records?

I know haw to use one for a single record search by including items such as:

[FMP-Field:e1]=2&[FMP-Field:e2]=229&[FMP-Field:e3]=3344

But how would I do a search for 3 different records where:

1) All 3 records have [FMP-Field:e2]=229&[FMP-Field:e3]=3344. This is the same for all 3 records.

2) Each of the 3 records has different criteria for [FMP-Field:e1]=

for example, [FMP-Field:e1]=1 and [FMP-Field:e1]=3 and [FMP-Field:e1]=5

Larry

Posted

In FM6

You can find records for [FMP-Field:e2]=229&[FMP-Field:e3]=3344

Then sort by [FMP-Field:e1]

Then export records to other file with "summary by" option

Then you can see your foundset in new file.

Posted

Good suggestion. Is there a way to do this that does not include exporting and manually finding the records in question? I want only the records in question to be displayed in the web browser:

In other words, I could include [FMP-Field:e1]=1...3&[FMP-Field:e2]=229&[FMP-Field:e3]=3344

This would find 3 records for e1. But what if I want to find 3 records that were not 1...3 but were more like e1=1 and e1=3 and e1=5?

Larry

Posted

Larry,

You can use a "-lop=or&e1=1&e1=3&e1=5" or you can use "-lop=or&e1=1 3 5".

However, be aware that you cannot mix your "-lop" the whole URL will either be "or" or "and" frown.gif To achieve a mixture you will need to use an [FMP-If] in the Format file.

All the best.

Garry

This topic is 7263 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.