Its long back to post some of the technical updates on my blog. I ‘ll be back again posting my learnings over this blog in the coming days and thought i can start with below tech note which i faces recently today on one of the project for an banking client. It was with respect to Freeform SQL where view filter was applied initially and it got changed different while it’s viewed by different user or an user editing the FFSQL report in Desktop to view the filter inside them.
(ie) Filter was applied as “YEAR ID EXACTLY 2013″ is changed as ” YEAR Field EXACTLY 2013″
Due to that, the reports/documents were not working as expected.
As this is an known issue, we need to follow the workarounds mentioned in the tech note below to resolve. It’s good to know and we might need to live with workarounds till the product got matured 🙂 which is indefinite 😉