Clear Your Browsing Data/Cache/Cookies
Always try this FIRST if something is not working properly! Make sure you have only one browser window open, go to the browser history and clear the cookies.
NOTE* If your screen in the Enterprise Applications folder (where you access your specific database) has been reduced to a tiny area, clearing your cache will do the trick!
Outputting Alphabetized List of Fields to Excel
If you are in need of selecting fields to output in alphabetical order:
- in the Query tab, alphabetize, then choose fields (be sure to do this in this order)
- Proceed to the Fields tab and output to Excel
ADDITIONAL NOTE: Excel and PS Query alphabetize certain things (spaces and underscores, for example) differently which results in your alphabetized list in PS differing from an alphabetized list in Excel.
Put name of field on Expression
When you create an expression, put the field name first before the case statement with commenting /*+name of field or purpose of case statement */.
Use Signed Number
Use "Signed Number" option under 'Expression Type' in order to get the correct numbers. (not "Number" option)
Set Default Value on Prompt
Enter default number/ data on prompt. Additionally, you can make the prompt "optional" by checking the box.
Attachments:
Expressions List Heading.png (image/png)
Edit Expression Properties.png (image/png)
Edit Prompt Properties.png (image/png)
