CC showing data before submit

Hi SLB,

I think you can do this by adding a WHERE condition that returns no results if the filter isn't set. Please turn on the CC Debugger and post the results here so that we can see the name of the filter variable(s).

Bob

Thanks for your help Bob.

This is what the Debugger shows...

Array
(
[0] => SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name` FROM `ai6go_chronoengine_extensions` AS `Extension` WHERE `Extension`.`enabled` = '1' ORDER BY `Extension`.`ordering` ASC
[1] => SELECT `Group`.`id` AS `Group.id`, `Group`.`parent_id` AS `Group.parent_id`, `Group`.`lft` AS `Group.lft`, `Group`.`rgt` AS `Group.rgt`, `Group`.`title` AS `Group.title` FROM `ai6go_usergroups` AS `Group` ORDER BY `Group`.`parent_id` ASC, `Group`.`lft`
[2] => SELECT `Connection`.`id` AS `Connection.id`, `Connection`.`title` AS `Connection.title`, `Connection`.`params` AS `Connection.params`, `Connection`.`extras` AS `Connection.extras`, `Connection`.`published` AS `Connection.published` FROM `ai6go_chronoengine_connections` AS `Connection` WHERE `Connection`.`title` = 'funcionaraCC' AND `Connection`.`published` = '1'
[3] => DESCRIBE `ai6go_chronoengine_chronoforms_datatable_publicarv01`
[4] => SELECT COUNT(`funmodel`.`id`) AS `funmodel.count` FROM `ai6go_chronoengine_chronoforms_datatable_publicarv01` AS `funmodel`
[5] => SELECT `funmodel`.`id` AS `funmodel.id`, `funmodel`.`uniq_id` AS `funmodel.uniq_id`, `funmodel`.`user_id` AS `funmodel.user_id`, `funmodel`.`created` AS `funmodel.created`, `funmodel`.`modified` AS `funmodel.modified`, `funmodel`.`dropdown1` AS `funmodel.dropdown1`, `funmodel`.`dropdown2` AS `funmodel.dropdown2`, `funmodel`.`dropdown4` AS `funmodel.dropdown4`, `funmodel`.`text13` AS `funmodel.text13`, `funmodel`.`text12` AS `funmodel.text12`, `funmodel`.`text8` AS `funmodel.text8`, `funmodel`.`text6` AS `funmodel.text6`, `funmodel`.`text17` AS `funmodel.text17`, `funmodel`.`text18` AS `funmodel.text18`, `funmodel`.`textarea12` AS `funmodel.textarea12`, `funmodel`.`dropdown7` AS `funmodel.dropdown7`, `funmodel`.`text9` AS `funmodel.text9`, `funmodel`.`text10` AS `funmodel.text10`, `funmodel`.`file10` AS `funmodel.file10`, `funmodel`.`file14` AS `funmodel.file14`, `funmodel`.`file15` AS `funmodel.file15`, `funmodel`.`button13` AS `funmodel.button13` FROM `ai6go_chronoengine_chronoforms_datatable_publicarv01` AS `funmodel` LIMIT 30
)

Beforehand, thank you very much!!

SLB.

Hi SLB,

What's the filter code you have ?

Regards,
Max

Hello Max,

The filter code it's in the front list->list display->table code and the filter it's doing it's work properly, but when I go to "home", shows all the data in the DB. I was thinking that if it's not possible to found a way, I will need to retrieve the data in a LIFO way.

Thanks for your concern.

SLB.

I think this the filter "field" code, but you should have another piece in the "Conditions" box, correct ?

Thanks Max, but I discovered the id DESC on sort tab, so It doesn't matter that CC shows the data before submit.

Ok, so this is solved ? I can't understand this part:

but I discovered the id DESC on sort tab