03-31-2023 02:53 PM - edited 03-31-2023 02:54 PM
Hi,
we have CUIC 12.5(1) and we would like extract from the database the default filter of the reports.
From the table cuicreport we get the value of the column defaultfilterid but we don't find the table where is define the value of defaultfilterid. We noted that each time that we save a report (with or without do changes), the version column increase (expected) but the defaultfilterid change to.
we found the following tables but we have not had luck:
cuicreportdefinitionfilter
cuicreportdefinitionfilterfield
cuicreportdefinitionfilterparameter
do you know in what table is define the default filters?
thanks.
04-01-2023 06:02 AM
Hi, have you tried exporting the full list of tables (sample of how to do it here)? I don't have access to a system at the moment.
https://community.cisco.com/t5/contact-center/cuic-how-to-export-scheduled-reports/td-p/4437440
04-01-2023 02:24 PM - edited 04-01-2023 02:25 PM
hi,
thanks for your answer.
we have *cuic* tables and their columns but we have not found where is saved the information.
run sql SELECT tabname from cuic_data:systables
run sql select t.tabname, c.colname from cuic_data:systables t join cuic_data:syscolumns c on t.tabid=c.tabid where t.tabname like "cuic%" order by t.tabname
regards,
04-03-2023 06:16 AM
Finally we found the way for collect the default filter:
run sql select v.id, c.name Folder, v.name ReportName, v.description, v.reportdefinitionid rptDefinitionId, rd.name rptDefinition, v.defaultfilterid, cv.key Filterkey, cv.description FilterDescription, v.bypass, u.name Owner from cuic_data:cuicreport v, cuic_data:cuiccategory c, cuic_data:cuicreportdefinition rd, outer cuic_data:cuicuser u, cuic_data:cuicreportdefinitionfilterfield rdff, cuic_data:cuiccollectionvalue cv where v.parentcategoryid= c.id and v.reportdefinitionid=rd.id and v.owner=u.id and v.defaultfilterid=rdff.parentfilterid and cv.cuiccollectionid=rdff.collectionid and (v.name like "%test%")
04-04-2023 10:33 AM
You nailed it. Its wonderful knowledge that we can easily query the CUIC datasource itself which maintains the state of all the reports, definitions and filter which is built over the uccx/ucce datasource.
Thanks
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide