When entering Search SQL for a field I discovered there is a character limitation. in the database the table in question is the Custom_Edits table and the column is Colp_SearchSQL this has a limitation of 128 characters, but the screen in the application is actually less, major pain in the butt surrounding this.
Thanks for the comment.
I'll pass this on to my colleagues. Were you able to able to work around the issue.
Once again my savior is Mr. Jeff Richards. My situation was able to be worked around, but only because I was being dumb with my SQL statement, and I was able to re-write using less characters. However, the issue still applies only because if I continue in the path I am going (based on company needs) this will become an issue again in the future.
I appreciate you escalating this. I just wanted to point out the fact once again that while the Custom_Edits table field allows for 128 characters (which is very low), when you are actually in the application it doesn't allow you to enter more than a lower number of characters compared to the 128 character limit in the database. I appreciate all of this Mr. Richards!
Easiest way to work around this is to set the Search SQL in the Create Script of the ASS field.
SearchSQL = 'select x from y';
This option also allows you to do dynamic search SQL based on other fields/data in the DB.
Sage CRM specialist and all round fan! Please feel free to follow me on twitter @dannycrm
© The Sage Group plc 2017All Rights Reserved