Jump to content


Photo

Get Data from Custom Profile Field

profile custom data report

  • This topic is locked This topic is locked
1 reply to this topic

#1 April

April

    Member

  • Members
  • PipPip
  • 14 posts

Posted 23 June 2015 - 02:07 PM

We are using AccuLite 6.0 and have a created a custom field on the profile so that we will know if students are 'eligible' or 'ineligible,'  Staff manually enters this field for each student in the profile.

However, when we export the data, we do not get this field; we get the total count of those who are 'eligible' or 'ineligible,' but we need to know which students specifically are one or the other and to be able to filter it in the file that we download.  Is this possible, and if so, what should we do differently?

 

Thanks for any ideas!



#2 dfoster

dfoster

    Advanced Member

  • Moderators
  • PipPipPip
  • 238 posts
  • Gender:Male
  • Location:Winter Park FL
  • Interests:Guitar

Posted 15 July 2015 - 01:35 PM

Hi April sorry for that late response. The only way you can get that information would be to use a 3rd party tool in order to query the database directly.

 

If you do that, then you want to query the user_inf table and the P1.P2,P3..P10 values correspond to the Profile table opt_no values.

 

So for Profile field 1 it would be something like:

 

SELECT * FROM user_inf inner JOIN profile ON user_inf.p1 = Profile.opt_no


David Foster
Engineerica Systems Support





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users