Searching on multiple Tabular Columns at once (i.e. search per-row)

noahMDMi
noahMDMi Member Posts: 8
Photogenic First Comment
**

Is it possible to search on tabular rows based on column values. I know we can specify a value for in_column when creating attribute.search_criterion(), which is a step in the right direction, but I want to be able to conditionally search on rows, for example, I want to check for rows where Column 1 has a value of "ABC", Column 2 has a value of "DEF", and Column 3 has a value of "GHI".

It's possible via Viewer, but is it possible via the STK?

Tagged:

Answers

  • Doug Addy
    Doug Addy Member, Moderator, Employee Posts: 22
    Second Anniversary 5 Answers 10 Comments Name Dropper
    ✭✭✭✭
    edited January 19

    This should be possible, the example code below will perform a search in the MI Training database for records where both of the following are true:
    1. The column Order in the attribute Characterization of this material is 1
    2. The column Technique in the attribute Characterization of this material is Light microscopy

    On a stock installation of MI Training you should see one result - the record Titanium (Ti)

    from GRANTA_MIScriptingToolkit import granta as mpy
    session = mpy.Session("http://your.mi.host/mi_servicelayer", autologon=True)
    database = session.get_db(db_key="MI_Training")
    table = database.get_table("Training Exercise for Import")
    attribute = table.attributes["Characterization of this material"]
    
    criterion_order = mpy.SearchCriterion(attribute=attribute, operator="EQUAL", value=1, column_name="Order")
    criterion_technique = mpy.SearchCriterion(attribute=attribute, operator="CONTAINS_ALL", value=["Light microscopy"], column_name="Technique")
    
    table.search_for_records_where([criterion_order, criterion_technique])
    
  • noahMDMi
    noahMDMi Member Posts: 8
    Photogenic First Comment
    **

    This isn't quite what I was looking for. I'm more looking for conditional searching per row.

    For example:

    If Record 1 has a tabular attribute that looks like this:

    C1 C2 C3 C4 C5
    A 1 7 3 5
    B 2 8 4 6

    And Record 2 has a tabular attribute that looks like this:

    C1 C2 C3 C4 C5
    A 2 8 4 6
    B 1 7 3 5

    I want to be able to do a search that returns me all records with a tabular attribute that have a row with a C1 value of A, that also have a C3 value of 8 and C5 value of 6, as well as another row with a C1 value of B, that has a C2 value of 1, and a C4 value of 3.

    Doing that search in MI Viewer would return only Record 2, but if I did it via the STK, The search criterion would end up returning Record 1 as well, since the tabular attribute does have a C1 with A and B, a C2 with 1, a C3 with 8, a C4 with 3, and a C5 with 6, which would not be the intended behavior, since my criteria is row specific depending on the first criterion.