I also would like to calculate points based on Lifetime athletic giving. Ive created an attribute with the number of points the points vary from 1 to 9,343 points. So how would I go about doing a query for scoreomatic for that value?
Answer: Assuming that the attribute is a number attribute...
SELECT RECORDS.ID FROM RECORDS LEFT OUTER JOIN ConstituentAttributes AS CA ON CA.PARENTID = RECORDS.ID INNER JOIN AttributeTypes AS AT ON AT.ATTRIBUTETYPESID = CA.ATTRIBUTETYPESID LEFT OUTER JOIN Numbers on Numbers.Number WHERE AT.Description = 'Lifetime'
Change the name of the attribute accordingly. It is only returning a single column of IDs, so it shouldn't be too big of a hit even with 250,000 rows.
Afterthoughts: Numbers.Number If any single attribute value exceeds 100,000 you will need more rows in your numbers table.
Steve Schindler
So how would I go about doing a query for scoreomatic for that value?
Answer:
Assuming that the attribute is a number attribute...
SELECT RECORDS.ID FROM RECORDS
LEFT OUTER JOIN ConstituentAttributes AS CA
ON CA.PARENTID = RECORDS.ID
INNER JOIN AttributeTypes AS AT
ON AT.ATTRIBUTETYPESID = CA.ATTRIBUTETYPESID
LEFT OUTER JOIN Numbers on Numbers.Number WHERE AT.Description = 'Lifetime'
Change the name of the attribute accordingly.
It is only returning a single column of IDs, so it shouldn't be too big of a hit even with 250,000 rows.
Afterthoughts:
Numbers.Number If any single attribute value exceeds 100,000 you will need more rows in your numbers table.