Feature request: Column view, ordering and searching

Started by Franky73

Feature request: Column view, ordering and searching   12 January 2017, 18:29

Hi

In "change column view", it could be great if there were multiple highlighting conditions, and then, we could get multiple colors according to the specified values.

Also, the regular expression is fine, but the column must be sorted by the result of the regular expression, which I think it does not do.

I think it could be great if "Ordering" were improved (order by column X, then column Y, then column Z for example). And "searching" of any term as well. Something like... Excel

Thanks, great product.
SoftPerfect Support forum - Andrew avatar image

Re: Feature request: Column view, ordering and searching   13 January 2017, 16:30

You are right about sorting: it didn't take into account any regular expressions. It has just been fixed that in these builds.

Regarding multiple highlighting conditions, I guess we could add a way to manipulate colors based on column value with VBScript, perhaps something like:
If InStr(column.value, "foo") Then
    column.color = "#AABBCC"
ElseIf InStr(column.value, "bar") Then
    column.color = "#001122"
Else
    column.color = "#000000"
End If
What do you want to use the multiple highlighting conditions for?

Re: Feature request: Column view, ordering and searching   16 January 2017, 18:10

Hi, Andrew.

First, sorry: i didn't see the search button. So searching is ok.

About multiple highlighting conditions: for example, i have a column with "Operating System" and i would like that:

- windows 10: green
- windows 7: yellow
- windows xp: red
- windows server: blue

So, different columns with different colors according to values of its own highlighting conditions. This, together with "sorting with regular expression result" would bring a useful and pretty look.

But the best would be that sorting were "a jerarchy of sort columns" (maybe three columns is ok), for example:

Sort first: column "IP address"
Sort second: column "Computer Organizational Unit" (i have this column. Regular expression is applied here).
Sort third: column "Operating System" (Regular expression is applied here as well).

This would bring a, in english.. maybe is.. a three-column arrangement?

Thanks.

Reply to this topic

Sometimes you can find a solution faster if you try the forum search, have a look at the knowledge base, or check the software user manual to see if your question has already been answered.

Our forum rules are simple:

  • Be polite.
  • Do not spam.
  • Write in English. If possible, check your spelling and grammar.

Author:

Email:

Subject

A brief and informative title for your message, approximately 4–8 words:

     

Spam prevention: please enter the following code in the input field below.

 **      **   ******    **          ******   ********  
 **  **  **  **    **   **    **   **    **  **     ** 
 **  **  **  **         **    **   **        **     ** 
 **  **  **  **   ****  **    **   **        ********  
 **  **  **  **    **   *********  **        **        
 **  **  **  **    **         **   **    **  **        
  ***  ***    ******          **    ******   **        

Message: