latest note in HUD?

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

latest note in HUD?

Postby mtagliaf » Thu Dec 04, 2008 1:34 pm

I would like to display the latest note on each player in the HUD. Has anyone done this?

It looks like you can create a column based on table notes.notes, but I'm not sure what the system will do if there exists more than one note on a player.

alternately, perhaps I can create a column that shows only the note that begins with a custom string, say, "HUD:", using the sum(if...)) type functionality. Then I can just make sure that only one note exists that starts with HUD.

Any guidance in getting this working would be appreciated. I will be working on it this afternoon.
mtagliaf
 
Posts: 45
Joined: Tue Feb 12, 2008 10:30 pm

Re: latest note in HUD?

Postby kraada » Thu Dec 04, 2008 2:19 pm

As I said, I haven't tried it myself; I would recommend trying it and see what you can make work. Though I'm not aware of any way to display notes in the HUD at this time.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: latest note in HUD?

Postby mtagliaf » Thu Dec 04, 2008 2:39 pm

thanks. I tried to set up a column that pointed to max(notes.notes), and get it going in the HUD, it ended up displaying the same note for all players at the table. It looks like the HUD isn't smart enough to link the note to the Player_ID.

I'll keep trying
mtagliaf
 
Posts: 45
Joined: Tue Feb 12, 2008 10:30 pm


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 1 guest