Hello All, While working on one view entity creation, I faced one problem and thought to share with you all. I used OR as entity alias for OrderRole, and while fetching the data the entity throws exception of incorrect SQL.
On research I found that while creating SQL query sql executer treat OR as OR operator and misinterpret the query. So I would suggest never ever use any SQL keyword for entity alias in view entity like OR, AND or any other while creating abbreviations for entity alias. Now I would like to ask to community, do we need to handle this? If yes then how, in code or in best practice document. Please advise. Best Regards, -- Rishi Solanki Sr Manager, Enterprise Software Development *HotWax Systems* *Enterprise open source experts* cell: +91-98932-87847 http://www.hotwaxsystems.com
