Page MenuHomePhabricator

Iterate on DS fredge query
Closed, ResolvedPublic1 Estimated Story Points

Description

The original scope of the tool is now on the production Civi. We have some followup tasks:

@MBeat33 wrote

@jgleeson the frdev links you sent are really, completely great, this is shaping up to be exactly what I was hoping for, and will enable me to train others in the process of reviewing these.

The follow up questions I have are:

  • how soon can I test this on real Civi?
  • how to sort the results by date/time? is it possible to add the date/time field to this list:

SortColumns.png (672×2 px, 255 KB)

  • is it possible to add the ScoreName filter to the columns? I don't see it here:

ColumnsAddScoreName.png (1×2 px, 185 KB)

does the error message you can see in the screenshots mean anything? Redis set (_CRM_Wmffraud_Form_Report_Fredge_f59678975965bb0ad4518f3903799948_9371_container) failed: NOAUTH Authentication required.
is there any practical limit to the size of the .csv we can upload? I don't imagine we'd every do more than several hundred at the most, but I'm curious
Thank you for all your help!

Related Objects

StatusSubtypeAssignedTask
OpenNone
ResolvedEileenmcnaughton
ResolvedEileenmcnaughton

Event Timeline

@MBeat33 I assume this q "how soon can I test this on real Civi?" is out of date now?

Yes, @Eileenmcnaughton just the sort by date & scorename filter questions are current - thank you

Eileenmcnaughton claimed this task.

Discussed on fortnightly - closing

@Eileenmcnaughton wait, should we close {T199268 } instead?

(is that just soooo 2001 to say that?)

If there is a way that I can sort by date/time and add the Scorename filter, please let me know. I'm still using the old manual workflow in the terminal, and using this new form will be a big boost.

Looks like the new filter donation_interface_fraud_email_pattern could be added too!

@MBeat33 I feel like once you have loaded the file you should be able to make changes on the filter tab & add additional filters without losing the list of ids? I see a date filter - not so sure about the others

Screen Shot 2019-04-13 at 11.19.29 AM.png (548×692 px, 51 KB)

Thanks, @Eileenmcnaughton I uploaded a .csv, but the filter tab does not (that I can see) give me the option of adding additional filters.

fredgetemplate.jpg (1×1 px, 231 KB)

I tried going to Report templates as well. Is there link where I can modify the existing report, to add the two extra filters?

we just need to add 2 new filters and then close this. We'll make new tasks for other changes.

2 new filters:
name (detects button mashing)
custom email pattern

Change 507722 had a related patch set uploaded (by Eileen; owner: Eileen):
[wikimedia/fundraising/crm@master] Add Score name & also generic filter name filter

https://gerrit.wikimedia.org/r/507722

Change 507722 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Add Score name & new email filter, also Ip Blacklist as there doesn't seem to be a good reason to exclude

https://gerrit.wikimedia.org/r/507722

so far so good, @Eileenmcnaughton, thanks to you and @jgleeson

I am building out this new workflow. If I wanted to add utm_source to the columns, would that require an update? I can spin off into a subtask if closing this one will help.