where is data stored on database

  • Chris Moyses
  • Topic Author
  • Away
  • Premium Member
  • Premium Member
More
4 weeks 1 day ago #176550 by Chris Moyses
where is data stored on database was created by Chris Moyses
We are going through a exercise to tidy up the data of  Subscribers in Membership Pro

One thing we are looking at is tiding up children details were they  are older than 18 years old

when I export  a record with Children information from the front end, it shows details of the Children (see attached file)

I am assuming the database table the information is stored on is ' wrunv_osmembership_subscribers'  (See attached file)

When I look at this record on this table,  there is no details about the children .

I was wondering were details of the children is stored on the database?

Regards

Chris
 

File Attachment:

File Name: childre_query.docx
File Size:75.13 KB

 

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

More
4 weeks 1 day ago #176561 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic where is data stored on database
Hi Chris

I believe the data you are looking for is from a none core custom field. So you will need to look at data in #__osmembership_field_value database table

Regards,

Tuan

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

  • Chris Moyses
  • Topic Author
  • Away
  • Premium Member
  • Premium Member
More
4 weeks 21 hours ago #176574 by Chris Moyses
Replied by Chris Moyses on topic where is data stored on database
Hi Tuan

Once again, you have answered my query, I have created a script to extract details of children more than 18 years Old

Regards

Chris

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

More
4 weeks 10 hours ago #176579 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic where is data stored on database
Great. Happy to hear that. Thanks for the update, Chris

Tuan

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

Moderators: Tuan Pham Ngoc