Category
Administration
Product Version
9.0
Field Folders in Table/SQL?
Answered
Hello,
I'm currently looking for a specific table in the repository that contains a column for Field Folders (Field Folders - Yellowfin Guide 9 - Globale Seite).
With SQL I found one table named "ReportFieldTemplate" that includes the column "Groupcode" which should be the ID for these Field Folders (SQL: SELECT * FROM reportfieldtemplate), but it don't displays always the right names or sometimes numbers.
Did some table with these informations exist? Let me know, where I might find this.
Additionally, if I can get a general SQL query which give me informations from the YF Repository with 2 Colums: "Viewdescription and Field Folders" would be perfect and would be helpful.
Thanks in advance,
Janus
The same question
Hi Janus,
Thanks for contacting Yellowfin with your question.
Although I don't know this information off the top of my head, let me see if I can add a folder and search for it in the database to find where it's located.
Please bear in mind that support don't generally give out information on how the configuration database works, as that's considered proprietary, so I just want to set expectations on what level of depth I can go into.
Kind regards,
Chris
Hi Janus,
Thanks for contacting Yellowfin with your question.
Although I don't know this information off the top of my head, let me see if I can add a folder and search for it in the database to find where it's located.
Please bear in mind that support don't generally give out information on how the configuration database works, as that's considered proprietary, so I just want to set expectations on what level of depth I can go into.
Kind regards,
Chris
Hi Janus,
After some quick testing, the Field Folders are stored in the orgreferencecode table with the reftypecode = "FIELDCATEGORY".
I hope that helps. If needed, you should be able to build your SQL query from that information.
Kind regards,
Chris
Hi Janus,
After some quick testing, the Field Folders are stored in the orgreferencecode table with the reftypecode = "FIELDCATEGORY".
I hope that helps. If needed, you should be able to build your SQL query from that information.
Kind regards,
Chris
Hey Chris,
looks good to me!
I keep that in mind for the next time! Thank you, for that clarification. You can set this ticket to Completed/Answered.
Thank you,
Janus
Hey Chris,
looks good to me!
I keep that in mind for the next time! Thank you, for that clarification. You can set this ticket to Completed/Answered.
Thank you,
Janus
Hi Janus,
No worries. I'm glad that helped! Have a good week!
Kind regards,
Chris
Hi Janus,
No worries. I'm glad that helped! Have a good week!
Kind regards,
Chris
Replies have been locked on this page!