I'm trying to create a view for user_list. And I include the total posts of each user. But when I sort the table based on the "Profile: Post Count" qty, it sort the "Profile: Post Count" as a string not as a number. I attach the preview for your ref. I assume that this case happen because the data type of the "profile_values_user_post_count_value" is String not an integer. Is there anything I can do to solve this problem?

CommentFileSizeAuthor
Clipboard01.jpg56.37 KBstrangerman

Comments

strangerman’s picture

strangerman commented

I need to alter the SQL query. Can somebody help to guide me, how can I manually alter the SQL query that had been created by the views module before?

merlinofchaos’s picture

merlinofchaos commented

Sorry, this can't be fixed at this time.

stephthegeek’s picture

stephthegeek commented
Status: Active » Closed (won't fix)