When building a filter for the sake of linking a row to another row in the same table, it would be helpful to eliminate the accidental selection of the same row. For example, we are trying to match buy and sell transactions to each other inside the same table. We we build the filter to limit which rows are shown in the selector list, we filter on things like "SKU = This SKU" via dynamic data to pull in the current record's SKU. However, often the selection criteria causes the record we are editing to show in the quick select list, leading to easy mistakes. We'd like to add a filter to say something like "RecordID != This RecordID" but the recordID is an internal/API field only it seems. I suspect I could assign an autoID field, but those are dynamic and we see a warning about dynamic fields not matching correctly when trying that. To be able to do it on the recordID without a synthetic extra step would be an improvement anyway.
... View more
