Page MenuHomePhabricator

Make minfraud risk score to Fraud Scan SK
Closed, ResolvedPublic

Description

See this report, we'll need the minfraud score field from that report.

Then we can add the minfraud score the Fraud Scan SK.

Event Timeline

Lars triaged this task as Medium priority.May 13 2026, 8:17 PM
Lars moved this task from Triage to Next on the Fundraising-Backlog board.
Lars added a project: FR-donorrelations.
Lars updated the task description. (Show Details)
Lars renamed this task from Make payments_fraud tables available in SK and add to Fraud Scan SK to Make minfraud risk score to Fraud Scan SK.May 15 2026, 10:13 AM
Lars updated the task description. (Show Details)

@MBeat33 I've added the risk score to the searchkit, as it was in the report. Does that look right to you? Turns out to have been very easy, it was just a matter of adding a with Payment Frauds and then a with Payment Fraud Breakdowns and then selecting the risk_score field, as you can see in there.

While we're here, do you want to turn this into a formbuilder search form so that it is a little easier to use or do you prefer the flexibility of being able to add additional filters directly in searchkit?

Thank you so much, @Lars

I just tested the SK, and I have two followup questions:

  1. Instead of the Payments Fraud Breakdown: risk_score column, the info that I would most like to drill down to is the minfraud score. That's what is most helpful for the edge cases. Would it be possible to add just that column to the existing SK?
  1. The export spreadsheet now contains 17 lines for each transaction, as it looks to be pulling in each separate filter score. This is more info than I need, and makes the export files much bigger so I can't export as many transactions. Is it possible to return to just one line per transaction in the export?

turn this into a formbuilder search form?

I am still learning about the distinction between formbuilder search forms versus regular SK's. For now all I really need is the SK to include the minfraud scores, as it is really solid for how I use it, but I will consider the option.

@MBeat33 I think I understand now, does that look right to you?

Thank you @Lars The one line per transaction in the export is great.

Just to confirm, if the column (Max) Payments Fraud Breakdown: risk_score in this SK is the same field as the minfraud column in the Fredge form, then this is perfect.

Being able to sort the spreadsheet by the highest Minfraud scores will itself be a great new tool, thank you so much for making this!

@MBeat33 Yes, that's the same field as in the Fredge report. If you wanted to, you could also set up a filter to only show those rows with a minfraud score above a certain (configurable) threshold.

Thank you for confirming, and the filter option. When a great tool gets even better, that's a good day - TY.

XenoRyet set Final Story Points to 2.