Filter on RecordID

sd484

Hello,

I tried to set a filter on a field of type RecordID, but it does not work, why??
I tried it with SETFILTER and SETRANGE

Lin

You cannot set filters on a field of type Record ID.

kine

When I am using RecordID in some table, I have second field of type text where I save same value. When I need to filter, I am setting the filter over this text field...

ronvdw

I have recently tested this with the new 5.0 (beta) client and noticed that it is possible to filter on record id's in 5.0:

RecLink.SETCURRENTKEY("Record ID");
RecLink.SETFILTER("Record ID",FORMAT(Record.RECORDID));
IF RecLink.FINDSET THEN
  REPEAT
    MESSAGE(FORMAT(RecLink."Record ID"))
  UNTIL RecLink.NEXT=0;

Lin

Can you show your filtering code ?

micieb

NAV help says that you cannot set filters on RecordID but you can apply textfilters on it. So I think you can filter like:

RecLink.SETFILTER("Record ID",FORMAT(prec."Record ID"));


The Format is essential, no other way of filtering (except flowfield in the table using a recordid field) will work.

grtz.