Change Order Of Fields In a Notification

Yes, in options Step 4 of Notification build, you do something like colopt 1=2 that will change the order of column 1 & 2

Select your Multi-Fact in Step 1
Click Select
Look at the order of the columns be for you Add
Transcribe them in the order they appear

EXAMPLE:
Company Acct Unit Account

Company = 1
Acct Unit = 2
Account = 3

on step 4 of your notification click Options link
In the dialog box you can specify the order of your columns

EXAMPLE
colopt1=2&colopt2=no&colopt3=1
Account is the 1st column
Company is the 2nd column
Acct Unit is not shown

There is more extensive examples and documentation on the API in the SN guide.

hth
Matt

Alot of what you will do in there will be examples like the following

colopt1=No Column will not display
Colopt4=1 Column 4 will display first

Thanks to both of you. This worked.

Just keep in mind, there ONLY place that you can see the true index of the columns is after you select your multi-fact. The Index in the InfoSet editor or the iundex of the query language is not always correct as SN reorders based on your Key, Attribute and Measure settings.

Where can you see the true order of index of the fields? I am basing mine on the index of the query tool.

The reason I am asking this question is in my result set I have employee number, then a number of fields and then the last name, first name and middle init. The users want the last name, the first name and middle init to be right next to the employee number.

I ordered the lastname like &colopt11=2 and this works but when I use the first name to be &colopt12=3 it is not taking it till I put it in this order &colopt11=2&colopt12=2&colopt13=2(middle init).

Thanks in advance.

Did you see my reply at 01:45 PM? I think that addresses your follow up question right?

I read the post at 12:45 PM. Is there anyway to look at what the true index of the fields are ? 

Right, so there is only 1 place you can see the actual index for this and that is on Step 1 of the Notification creation process after you select your Items (Keys and Attributes) and Measures. The order from right to left is the index you need to use.

Thanks. This helps in designing the notification.