Hi
We’re working on a report taking data from the forms database, but we don’t find where the collections fields’ information is store, where can we find it?
Thanks and regards
Ricardo Cairo
All field values are stored in cf_bp_data. The field definitions are in cf_fields.
How do you want your collection data to be reported? I am wondering if you using third party tool to build a report. Depending on what report you have in mind, it could be very complicated to get all the information you need. The collection data is stored in cf_bp_data, with the repeat_id showing the multiple entries submitted by user.
It is generally not recommended to be accessing a database to a system like this, at least if you are trying to edit anything.
That being said, if you are trying to find its residing location, you will likely be best trying to start a form and submit it, then querying the DB for the unique information you put inside the collection. I would put something that would absolutely have to be unique and not be found anywhere else. This should give you your answer.
Also of note, if you are doing this on Forms 9.0 and then upgrade to 9.1, you will want to verify that the location is still the same.