Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: what table in db are registrants saved?

what table in db are registrants saved? 12 years 5 months ago #18043

  • roll82
  • roll82's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 11
  • Thank you received: 0
Hi,
where in the J! Database are the registration stored? I would like to do some customised reporting straight from the database and would need the table name. Have looked for it but could see the registrants anywhere.

thank you

Please Log in or Create an account to join the conversation.

what table in db are registrants saved? 12 years 5 months ago #18048

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
First, in the table jos_dtregister_user is a record of each registrant. Then the actual data for each field is found in jos_dtregister_user_field_values. Each field value has an entry in this table that corresponds to the _user table.

Please Log in or Create an account to join the conversation.

what table in db are registrants saved? 12 years 5 months ago #18057

  • roll82
  • roll82's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 11
  • Thank you received: 0
Great, thank you! have found it but the payment amount in all the fields was 0? Would that be stored anywhere else?

Cheers

Please Log in or Create an account to join the conversation.

what table in db are registrants saved? 12 years 5 months ago #18059

  • roll82
  • roll82's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 11
  • Thank you received: 0
Sorry, all the data in the "paid amount" field are NULL

Please Log in or Create an account to join the conversation.

what table in db are registrants saved? 12 years 5 months ago #18060

  • roll82
  • roll82's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 11
  • Thank you received: 0
found it in the jos_dtregister_fee table


THANK YOU!!!

Please Log in or Create an account to join the conversation.

what table in db are registrants saved? 12 years 5 months ago #18061

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
Sorry, forgot a table. The payment amount details for each record are in this table:
jos_dtregister_fee

Those records connect also to the dtregister_user table using the "user_id" field.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.227 seconds