New answers tagged external-content-type
So after much trial and error and reading everything I could, I have found the general issue, so sharing so anyone else that stumbles upon this. The issue is that the wildcard does not seem to be capable of passing the functions such as substringof() or startswith() to the ODataEntityUrl. You have to use a Comparison instead of a Wildcard. Here is the ...
While adding the ReadList operation you can specify a Filter. Select the Data Source Element and then click Filter link. Once the filter is setup you can use that to pass the parameter. For that open the External List in browser. Then say modify view. Then put the Filter Value.
I would prefer the SharePoint for the tickting system, easy to use customization options Alerts, workflows etc Use BI tools to get the reports archiving the old tickets( if proper planed). Search. Only drawback for advance features you need the Enterprise License. Here are two Example of Ticketing systems, which will help you understand it. ...
Data in SharePoint has more advantage than storing in SQL. Search Workflow Alerts and Emails Automatic remainders Easily scale (Database or by extending farm) Powerview (SharePoint Enterprise) Export to excel and then create adhoc reports Easy form creation (Any change in fields will automatically updates the CRUD UI)
Top 50 recent answers are included