SQL query for Retrieve method(query expression) in plugin using SQL Profiler
If you have any doubt in the post please post comments. I will try to solve your problem.
In plugin to get the data for another entity, we normally used query expression. When you used filter expression and condition in the query expression. It is little bit difficult to understand how the query forms.
Solutions:
Open SQL profiler and connect the database and run the trace. All the plugin is run by crmservice user. when you search in the profiler you will get the query, how SQL query form and execute.
1) Open the SQL profiler
If you have any doubt in the post please post comments. I will try to solve your problem.
In plugin to get the data for another entity, we normally used query expression. When you used filter expression and condition in the query expression. It is little bit difficult to understand how the query forms.
Solutions:
Open SQL profiler and connect the database and run the trace. All the plugin is run by crmservice user. when you search in the profiler you will get the query, how SQL query form and execute.
1) Open the SQL profiler
2) Open the trace and give trace properties to catch the SQL query
3) Put ctrl+f find window pop up, give the table name and click.Now you can get query format
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.