1. Clear All hierarchy columns.py
  2. Clear a particular column.py
  3. Clear multiple columns.py
  4. Export Table from active visualisation.py
  5. Find max value of a column.py
  6. Get all values of a column.py
  7. Get distinct values of columns.py
  8. Hide Filter based on Document Property value.py
  9. Open Directory.py
  10. Reading from a file.py
  11. Reset Zoom Sliders.py
  12. Select all for a Hierarchy Column.py
  13. Select all for a particular column.py
  14. Send Mail.py
  15. Show Ironpython output in a label.py
  16. Switch Visualisations.py
  17. Write Back to Database.py
  18. Write to a file.py
  19. Yes-No MsgBox.py
  20. Tags for Search on Graphs (ie., Document Property) which will work on Graph
     1.Go to “View > tag” named “New Tag Collection” to “Result” and with in it make two tag “Yes” and “No”.
     2.	Add attached Iron python in document properties > scripts > iron python.
        (Note:Do not forget to add script parameter ”myTable” as Data Table.Name this script as search_python)
     3. Add a textarea and in that , add an input field (string) as “search” and link above iron python created script to that.
     4.	To change a graph acc to search just go to that graph right click > “properties > data > limit data using expression” and write “Result=”Yes” ”.

   from System.Threading import Thread 
   print Thread.CurrentPrincipal.Identity.Name 

   for page in Application.Document.Pages:
   print page.Title

case when Upper([City]) ~= Upper("${wildcard}") then "Y" else "N" end

   a = Document.Properties['StartDate']
   a = a.AddDays(-1)
   Document.Properties['StartDateNew'] = a 

1. Make a string input document property in textarea area & name its div as "uid"

<span id="uid">
Spotfire Id control of string input document property
</span>

2. Write following javascript in the same textarea area to update step 1 document property with date. 
Note the DOMsubtreemodified function is to make sure everytime when something changes in 'fun' section this js runs 

         $("#fun").on("DOMSubtreeModified",function(){

         var d = new Date().getTime()/1000;
         $("#uid input").val(d).blur();
         function value()
         {
            var d = new Date().getTime()/1000;
            $("#uid input").val(d).blur();
         }
         })

3. On the change/set of this date input field call following ironpython script. 
Note testdata is going to be your datatable & id is going to be your column name.

activeFilteringSelection = Document.ActiveFilteringSelectionReference.GetSelection(testdata).AsIndexSet()
column = testdata.Columns["Id"]
max = column.RowValues.GetMaxValue(activeFilteringSelection).ValidValue
#print max
Document.Properties["maxvalue"]=str(max)