CUIC - Default Filter

[CoDeC]

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.

[bill.king1]

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

[CoDeC]

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,

[CoDeC]

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%")

[CuicReportingEngineer]

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