“1-2000 of xxxx (total result count)” instead of “2000 of more than 2000 ojects" size limit reached

Forum|Forum|1 year ago
October 10, 2024
3 replies
963 views

Version: Windchill 12.1

Use Case: I have a scenario that, when user searches for objects, the search results are more than 2000 (Which is above OOTB limit). In this case system troughing warning message that Table size limit reached, and the results object table showing at right top corner that “2000 of more than 2000 objects” and we can click Previous/Next buttons on the bottom left corner to see the other items of search result list. But I want to see the message at top right corner of the table like this “1-2000 of xxxx (total result count)” instead of “2000 of more than 2000 objects”. Is this achievable by standard configuration or we need a customization for this ?

Description:

I have a scenario that, when user searches for objects, the search results are more than 2000 (Which is above OOTB limit). In this case system troughing warning message that Table size limit reached, and the results object table showing at right top corner that “2000 of more than 2000 objects” and we can click Previous/Next buttons on the bottom left corner to see the other items of search result list.

But I want to see the message at top right corner of the table like this “1-2000 of xxxx (total result count)” instead of “2000 of more than 2000 objects”. Is this achievable by standard configuration or we need a customization for this ?

Requirement sample scenario : Lets say search result having 9850 objects.

Sample screenshot, it is set table size limit 20 for test pupose. I just placing here for reference

V

vnamboodheri

Community Moderator

Hi @AR_11016760,

Thank you for your question.

Your post appears well documented but has not yet received any response. I am replying to raise awareness. Hopefully, another community member will be able to help.

Regards,

Vivek N
Community Moderation Team.

avillanueva

23-Emerald I

I am not sure this is possible based on what I know about how this is being done. I think this is at the DB level where they are limiting results in chunks. Certainly there is the query limit which is a hard across the board DB setting. If Windchill does not request all the data at once from the database, then it does not know the total either. If so, customization would be tricky since it would have to transform your query into a count to get the total first and remember that.

I see why this can be a PITA with large searches. I would recommend if you need to get a sense of totals, to use a QML report that can provide this information for you without the limits.