Jump to content

Find and sort at same time


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

Recommended Posts

Inside an inlineaction tag, I want to find a match for a field called 'userid' and then sort the result in descending order by field 'recid'.

Userid is a user name ( which I'm trying to dedupe) and recid is a field containing the record's unique ID.

My problem is that I can't get it to work - all that happens is that the find aspect works but the sort does not appear to happen.

Here is the code I've been using:

[FMP-InlineAction: -db={CurrentDatabase}, userid={fmp-field: userid}, -sortfield=recid, -sortorder=descend, -find]

on]

Any/all help gratefully appreciated.

Graeme

Link to comment
Share on other sites

Whatever my problem was I have solved it by using a workaround of a calculation field to highlight the duplicate records thereby saving me losing the current recID.

This dispensed with the need for the inlineaction tag and its associated difficulties.

If anyone wants a more complete solution let me know.

Also I later realised the reason the code wasn't working was because the sortfield is called recordID, not recID. Doh!

Graeme

[ October 18, 2001: Message edited by: graemeaustin ]

Link to comment
Share on other sites

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