Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

Posted

Hi,

Here's attached a FM5 and a FM7 file.

I'm using this tip to parse out a category from a multiline field (through a script for real).

As there may be multiple matches, I'm locating the longer one with this technique.

The Last( ) function isn't returning the correct result with 7 right now, or may be I am missing something.

If all fields are indexed, then it works though.

Posted

It's not quite like you to forget to post the attachment. Maybe it's time for a nap? wink.gif

Posted

Oops

Here back the 3 files. The v7 Index works, the other involving a global doesn't.

Note that the category field isn't a global though, which in the real life and v5 is the case. But this doesn't make any difference.

FM7RepeatBug.zip

Posted

I remember this being a problem before. Last doesn't seem to evaluate unstored repetition calculations. Poot.

Posted

What is it that you say isn't working? They all seem to work for me. At least, if I pick item 2 in the value list I see the repeats for item 2. Same for item 1 or 3. But I must be missing something, what's the problem?

Posted

Hi Bruce,

It's the "correct category" field, which should return the longest match.

In v5, Last( ) would return this value, either if the repeating field is stored or not. With v7, if the repeating field isn't indexed, Last( ) is empty.

As Max( ) works, the workaround, at the moment, is to change the filterMatch so that you can use GetRepetition( ) then.

This topic is 7392 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.