Hi,

So, I'm wondering if it's okay to have views integration for the userpoints_txn table.

I'm using the other fields in that table to have context-specific userpoints logic.

I've attached a patch (applied to 6.x-1.x-dev) that will allow for Views to be created on this table.

Thanks,
Mike

CommentFileSizeAuthor
#6 userpoints.views_.inc_.patch3.01 KBjcmarco
#4 userpoints.views_patch.patch1.62 KBmmilo
#1 userpoints_transactions.patch5.29 KBmmilo
userpoints_transactions.patch5.07 KBmmilo

Comments

mmilo’s picture

mmilo commented
StatusFileSize
new userpoints_transactions.patch5.29 KB

Put in 2 additional arguments.

kbahey’s picture

kbahey commented
Status: Active » Fixed

Committed.

Thank you!

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

mmilo’s picture

mmilo commented
Status: Closed (fixed) » Needs review
StatusFileSize
new userpoints.views_patch.patch1.62 KB

Added more sort/filter handlers for the following fields:
status
reference
expired
entity_type
operation

The patch ALSO includes #791890: Views information for the userpoints_txn.tid field is defined incorrectly. - I can do this separately if you'd like.

Thanks!

kbahey’s picture

kbahey commented

I need someone to confirm that these are tested and found to be working.

jcmarco’s picture

jcmarco commented
StatusFileSize
new userpoints.views_.inc_.patch3.01 KB

I confirm that this patch is needed to make userpoints transactions views work.
Using filter handler for everything was wrong and new handlers are very useful.

I re-rolled the patch with the right format (fixes in line endings and absolute file paths)

kbahey’s picture

kbahey commented
Status: Needs review » Fixed

Committed.

Thank you both.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

oxford-dev’s picture

oxford-dev commented

Can I just ask, will this patch allow you to select which points categories can be used in views?

I would like to be able to have a view whereby the userpoints value in the view is the sum of all categories or even the sum of some categories but not others.

Is that what this patch is working towards?