url list filter issue

Status
Not open for further replies.

smart

Member
index.php?option=com_fabrik&view=list&listid=57&&resetfilters=1&&tk___ktid={teacher___tid}
when click on that element, the below url appear.

.org/talksm/talk-working/list/57?resetfilters=1&tk___ktid=16

then "Filter" box briefly appear and no record showed up.
When the "filter" box is expended, that teacher (id 16) is selected but the list doesn't show the records.
If click on "Go", the list shows up.
What am I doing wrong here?
 
Update here on the problem.
I found that "WHERE" clause on the initial call on URL is different after "GO" button on the filter is pressed.
I am still trying to find out why it happen.

INITIAL URL CALL
Code:
SELECT  `tk`.`kid` AS `tk___kid`,
`tk`.`kid` AS `tk___kid_raw`,
`tk`.`ktid` AS `tk___ktid_raw`,
`teacher`.`tnickn` AS `tk___ktid`,
`tk`.`kaid` AS `tk___kaid_raw`,
`tkalbum`.`kaname` AS `tk___kaid`,
......
, `tk`.`kid` AS `__pk_val`

FROM `tk`
LEFT JOIN  `cats3` AS `cats3` ON `cats3`.`c3id` = `tk`.`kc3id`
..........
LEFT JOIN  `teacher` AS `teacher` ON `teacher`.`tid` = `tk`.`ktid`
WHERE (  `teacher`.`tnickn` = 16 )
ORDER BY  `tk`.`kdatepub` DESC,`tk`.`kdatepub` DESC

AFTER "GO" Button
Code:
SELECT  `tk`.`kid` AS `tk___kid`,
`tk`.`kid` AS `tk___kid_raw`,
`tk`.`ktid` AS `tk___ktid_raw`,
`teacher`.`tnickn` AS `tk___ktid`,
`tk`.`kaid` AS `tk___kaid_raw`,
`tkalbum`.`kaname` AS `tk___kaid`,
.......
`tk`.`kid` AS slug
, `tk`.`kid` AS `__pk_val`

FROM `tk`
LEFT JOIN  `cats3` AS `cats3` ON `cats3`.`c3id` = `tk`.`kc3id`
.........
LEFT JOIN  `source` AS `source` ON `source`.`sid` = `tk`.`ksid`
LEFT JOIN  `teacher` AS `teacher` ON `teacher`.`tid` = `tk`.`ktid`
WHERE (  `tk`.`ktid` = '16' )
ORDER BY  `tk`.`kdatepub` DESC,`tk`.`kdatepub` DESC
 
Status
Not open for further replies.
We are in need of some funding.
More details.

Thank you.

Members online

No members online now.
Back
Top