logo icon

Hosted Payload Website

Help

  • "Search all columns": This box performs a string search show all that contain the input string. The input string will search all columns containing that string including numerical and date columns. This allows users to type "11/" to show all records containing this string included dates such as a Launch Date of "11/30/2013". A user can also show all records containing "91" including the orbit longitude of "91.5".
  • "Show # entries": The number of entries to show can be chosen from this dropdown. If anything other than "All" is chosen, the user can scroll to the bottom of the screen and choose "Next"/"Previous" to move among pages of data or click the page number. The "First" and "Last" buttons are used to jump to the first and last page of data.
  • "CSV": This button will export the filtered data to a comma separated file that can be imported into any spreadsheet program. Search criteria used will also be exported to the file in text format to give users information about the search performed to arrive at the data exported.
  • "PDF": This button will export the filtered data to a PDF file. Given the constraints in size of a PDF sheet, it is necessary to use a limited width of data in the export. Not all columns can be exported into PDF while maintaining readability. The first 7 columns shown will be exported. Search criteria used will also be exported to the file in text format to give users information about the search performed to arrive at the data exported.
  • Single Column Sort: To sort on a single column, left click on the column header. The ^ indicates sorting in alphabetical order or smallest to largest number/date order.
  • Multiple Column Sort: Hold down the shift key and left click the headers that you would like to sort.
    • Example A user wants to see the columns sorted first by the Launch Vehicle in ascending order and then by the Orbit Type in descending order. First the user left-clicks the Launch Vehicle column until the arrow shows "^". The user then holds down the shift key while left-clicking on the Orbit Type column until the arrow shows "v". Both columns will be highlighted to show that the data is sorted by these columns.
  • Full Screen button: Used to show a full screen view of the database within the browser window. You can use the browsers print function to print the page. To get out of this view you hit the Esc key. Note: This will print all of the database fields for the columns that fit on a page. Note: column sorting is not supported in full screen mode.
  • Copy button: Used to copy all fields shown and all columns of data on the page in tab delimited format for pasting into any desired editing program.
  • Row Clicking: Clicking a row will bring up a panel with all of the information related to that row. Panels can be moved, minimized and restored using the buttons in the upper right corner.
  • Conditional Filters: Use the "Add a Conditional Filter" button to add filters on the data. To find a number between two values, two filters will be needed.
    • Example 1. A user wishes to find the launches between Sept. 2, 2013 and Nov. 4, 2017. A conditional filter for "Launch Date" is chosen with ">" and the date "Sept. 2, 2013" from the calendar that pops-up when the user clicks on the text box. The user then goes through the same process again and chooses "<" and "Nov. 4, 2017" from the calendar.
    • Example 2. A user wishes to find out what satellites will be launched by the U.S. on an Atlas V. The user clicks the "Add a Conditional Filter" button and chooses "Operator Country", "contains", and types "United States" in the input box. Then the user clicks "Add a Conditional Filter" button and chooses "LV", "contains", and types "atlas V" in the input box.
  • Numerical and Date Operators
    • "=": "equals" operator shows all records with dates/numbers equal to the value in the input box.
    • "≠": "Does Not Equal" operator does not show any records with dates/numbers equal to the value in the input box.
    • "≥": "Greater than or equal to" operator shows all records with dates/numbers greater than or equal to the value in the input box.
    • "≤": "Less than or equal to" operator shows all records with dates/numbers less than or equal to the value in the input box.
    • ">": "Greater than" operator shows all records with dates/numbers greater than the value in the input box.
    • "<": "Less than" operator shows all records with dates/numbers less than the value in the input box.
  • String Operators Note: The strings in the database are searched and filtered without consideration of the case of the letters in the input string.
    • "contains": Operator that shows all records that are contain the input string. This operator is useful when a single fragment of a string is known but not the entire string.
      • Example: A user wishes to find all launches that will occur on "Atlas" rockets. The "LV" filter is added with the "contains" operator with "atlas" as input. All Atlas rockets in the database are shown.
    • "does not contain": Does not show any records that contain the input string. This operator is useful when a single fragment of a string is known, but not the entire string.
      • Example: A user wishes to find all launches that will not occur on "Atlas" rockets. The "LV" filter is added with the "does not contain" operator with "atlas" as input. All Atlas rockets in the database are no longer shown.
    • "equals": Finds records where strings within a field exactly match the input string disregarding letter case.
      • Example: A user wishes to find all launches that will occur on "Atlas V 551" rockets. The "LV" filter is added with the "equals" operator with "atlas v 551" as an input. All Atlas V 551 rockets in the database are shown.
    • "does not equal": Does not show any records where strings exactly match the input string disregarding letter case.
      • Example:A user wishes to find all launches that will not occur on "Atlas V 551" rockets. The "LV" filter is added with the "does not equal" operator with "atlas v 551" as an input. All "Atlas V 551" rockets are no longer shown in the database.
    • "like": Shows all records where the string in a field matches the input string using the percent sign (%) as a wildcard character. This operator is useful when multiple fragments of a string are known as well as the order of the fragments, but the entire string is unknown.
      • Example:A user wishes to find a POC phone number that the he/she previously called, but cannot remember exact number except that it contained "240" and "14". The user selects the Spacecraft POC Phone filter and the "like" operator with an input string "%240%14%". The individual's phone number appears in the filtered database.
    • "not like": Does not show any records where the string in a field matches the input string using the percent sign (%) as a wildcard character. This operator is useful when multiple fragments of a string are known as well as the order of the fragments, but the entire string is unknown.
      • Example:A user wishes to find all links within the Information Source column that do not contain "boeing" and "defense" in that order. The Information Source column filter is added and the "not like" operator is selected with an input string "%boeing%defense%". All of the records that contain the words "boeing" and "defense" are no longer shown in the database.