InfoQube IM - Community

Submitted by jan_rifkinson on 2009/01/14 18:10

Neither of these functions seem to work on my system

(1) default html - changed according to directions re: newHTML

[quote]

<HTML><HEAD>
<META content="SQLNotes 0.9.23.7c" name=GENERATOR>
<STYLE> body {font-family:verdana; font-size:10;}table {font-family:verdana; font-size:10;}</STYLE>
</HEAD>
<BODY style="MARGIN: 2px" bottomMargin=0 bgColor=#ffffff leftMargin=2
topMargin=2 rightMargin=2>
<DIV> </DIV></BODY></HTML>

[/quote]

(2) Sort - click column head, then drag column head into sort box. As soon as I refresh <F5>, the view reverts, i.e. column in sort box is cleared

closed / opened IQ; neither (1) or (2) value stuck

Jan Rifkinson

Ridgefield CT USA

Comments

A restart of IQ is required (AFAICR)
True. Column sort does not stick right now (and as the grouping depends on sorting...). This will be fixed. Perhaps, the pivot table can also do what you want...

Default sort is done via the source-bar

Alt+S

on the right hand side is the sortbox with the A-Z button

ensure it's not greyed out by clicking A-Z button if necessary

and type in the name of column you want to sort by - click the refresh button to right

this sort will stick

check/decide if you want sorting to affect sub-items

menu > Grids > Sort Criteria applies to sub-items

for some more info see "The Grids" in Getting Started

EDIT/ added "Default Sort" to -- link to nonexistent node ID 90 --

Tom, Thanks for your post.

Unless I'm missing something the A-Z button seems to refer to one way sorting, ie A-Z & I want to sort Z-A. It should toggle but doesn't. I think Pierre needs to fix / update this.

I'm sorting on creation date & want the most current input to my Inbox on top.

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

Jan

read the info about the sortbox in "The Grids" in Getting Started

Hi Jan,

The A-Z button is to turn the sort ON/OFF (see the tooltip). The sort per se is set by the sort box

From the page Tom was referencing:

The Sort Box: You specify here the order which you want the items to be presented. Multi-field sort is possible. This is saved with the grid, so the next time you open it, the sort will automatically be applied. Examples of sort is "StartDate DESC" or "EstimatedCost". The DESC tag means descending. ASCending is the default. Sort field do not need to be displayed in the grid. Left of the Sort box, there is a toggle button to turn the sort turn ON / OFF

Pierre, thanks for your patience. There are a couple of things I don't get.

1. How am I supposed to know the language IQ understands, i.e. DESC or ASC? Where do these come from? There is no drop down menu or anything that I see here.

2. I added "ItermCreated ASC" & "ItermCreated DESC" & refreshed w sort box icon in between the two sorts & nothing happened, ie sort did not change

I don't know what I'm doing wrong but I do know I'm getting frustrated

Thanks.

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

IQ uses SQL (hence the old name, SQLNotes). The Sort box gets mapped to the "Sort by" SQL Keyword: http://www.w3schools.com/Sql/sql_orderby.asp

In practice, it is much simpler for the sort than the filter. The sort format is:

Field1, Field2 Desc, ...

This will sort first by Field1 (default is ascending), then by Field2 (in descending order)

Sorry Pierre. I appreciate the explanation & reference. But in all honesty, this is over my head as a practical matter. All I know is I can't sort itemcreated in descending order to work or to stick.

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

[quote=jan_rifkinson]

All I know is I can't sort itemcreated in descending order to work or to stick.

[/quote]

try copy paste this in the sortbox as described above & clcik refresh button (or F5):

ItemCreated desc

Tom, that did it. I was using " <quote marks> around phrase thinking that was like a search phrase. Not to be un-appreciative but I think this kind of basic language ('asc' or 'desc') has to be offered in some kind of english & in a drop down menu or something for non-techies like me. Tks for sticking w me here.

Now if I could figure out the newhtml font settings problem........

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

[quote=jan_rifkinson]

[/quote]

the interface needs a lot of work (I think) as you say to make it eaasier

Sometimes the problem is the power of the programme -

you can sort in the sort box by two or more fields, the first ascending, second descending, third etc. - it's difficult to cover all those possibilities with buttons ... but it would obviously be helpful if initial interface was more intuitive while allowing people to use more advanced options

Re html you say your file says

[quote]

[/quote]

I changed mine to this and it works here - it presumably only works for new items

I initially left the last "quote" in by mistake and every new item had "quote" in the html pane!

Dunno what to suggest except - check the NewHTML.htm file again - IQ needs a restart if you change that file - then test with a new item

[quote=Tom]

Dunno what to suggest except - check the NewHTML.htm file again - IQ needs a restart if you change that file - then test with a new item

[/quote]

I discovered there is more than one "newhtml" file on my computer: one in appfiles, another in sqlnotes appfiles. Below is the one from the SQLnotes newhtml file

[quote]

<HTML><HEAD>
<META content="SQLNotes 0.9.23.7c" name=GENERATOR>
<STYLE> body {font-family:verdana; font-size:12;}table {font-family:verdana; font-size:10;}</STYLE>
</HEAD>
<BODY style="MARGIN: 2px" bottomMargin=0 bgColor=#ffffff leftMargin=2
topMargin=2 rightMargin=2>
<DIV> </DIV></BODY></HTML>

[/quote]

I don't know enough to see if there's anything wrong in there. It looks ok to me & I was cautious when I changed to verdana but, who knows -- maybe I screwed something up. This now seems an academic question since Pierre is going to make Verdana the default font (thanks Pierre).

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

Just lost post by accidentally clicking back button :(

Jan - file gets replaced each time new "install" done so save copy of file & replace after next install

Pierre, I guess this has to be done manually

Could you change default font to Verdana because

I cant find it here but there was some problem/confusion with MS sans serif (prob in old forum) and it's italic want to win a race - i find it almost illegible and it runs into the following text

Hi Tom,

Done (in the next release)

[quote=Pierre_Admin]

In practice, it is much simpler for the sort than the filter. The sort format is:

Field1, Field2 Desc, ...

This will sort first by Field1 (default is ascending), then by Field2 (in descending order)

[/quote]

can I sort by two fields in the sort-box? Wow, I can

I didnt know that ....