Combobox in grid

(0) Share

Report

Posted on by Community Member

i have combo box in a grid with populated item numbers data. when i click on combo box it takes a lot of time just to enable, when enable and again click than data show. what is the reason of slow enabling combo box OR any event of combo for enabling.

Thanks,

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Vilmos Kintera 46,149 on at

Like (1)

Report

Most likely bad code, or design. Is your combo box using an edit method, or is it datasource+field bound?

You can use the AX Trace Parser tool to capture what is going on client and server-side.

During the trace analysis you should be looking for high number of calls to a specific method/function or SQL statement, or check SQL statements which are not called frequently but takes a long time to execute.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi Vilmos

i am using datasource + field bound and use lookup for getting data using query build. but the main question is that when i first time click combo it takes time to enable when enabled and again click it to fetches record for select it fetches fast.

Thanks ,

Was this reply helpful? Yes No
Vilmos Kintera 46,149 on at

Like (1)

Report

I am sorry but your description is very confusing.

A combo box allows a dropdown selection of values of a base enumeration, or values that you are populating yourself as combobox elements. While now you mention a datasource-bound field in your next post, for which you are using a query to populate a lookup, which is typically not for a combobox.

Please share technical details of your solution, because it is unclear on what you have done exactly.

Was this reply helpful? Yes No
Lizelle 140 on at

Like (1)

Report

Hi there,

I agree. Ensure that your tables you are using in your query have the correct indices on them. In addition, try using a field selection only.

Always ensure that the query are fully optimized.

Regards,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks,

Resolved, the issue was validations checks in "cansubmitToWorkflow" method.

Was this reply helpful? Yes No
Zain Bokhari 3,208 Moderator on at

Like (0)

Report

So it was not a combobox then? Just a custom lookup for itemIds?

Please update the thread heading, and use correct terms with exact elaboration in future so everyone here can help and it doesn't waste anyone's time. Thanks.

Was this reply helpful? Yes No