ECSQL to find ECInstanceId by various IFC properties

[r-veenstra]

I have an iModel created from IFC. I'm trying to construct an ECSQL query that will allow me to find ECInstanceID's based on various IFC properties. For example:

SELECT ECInstanceId FROM bis.SpatialElement WHERE ifcglobalid = "2Ytno7yd91dQAhhP73ExwW"
SELECT ECInstanceId FROM bis.SpatialElement WHERE ifcname = "Upper Cabinet-Double Door-Short-Wall:27\"W x 28\"H:1319087"
SELECT ECInstanceId FROM bis.SpatialElement WHERE iFCClassName = "ifcfurniture"

At some stage I'd like to do this for properties that come from a Revit file, or other properties too. Is there a generic way to acheive this? It's not immediately obvious to me on how to query these sorts of properties.

Example properties that get returned via iModelConn.elements.getProps are below

[
    {
        "classFullName": "IFCDynamic:ifcfurniture",
        "id": "0x200000022e7",
        "userLabel": "Upper Cabinet-Double Door-Short-Wall:27\"W x 28\"H:1319087",
        "physicalMaterial": {
            "id": "0x20000001711",
            "relClassName": "BisCore.PhysicalElementIsOfPhysicalMaterial"
        },
        "iFCClassName": "ifcfurniture",
        "ifcglobalid": "2Ytno7yd91dQAhhP73ExwW",
        "ifcname": "Upper Cabinet-Double Door-Short-Wall:27\"W x 28\"H:1319087",
        "ifcobjecttype": "Upper Cabinet-Double Door-Short-Wall:27\"W x 28\"H",
        "ifctag": "1319087",
        "ifcpredefinedtype": "NOTDEFINED",
        "code": {
            "value": "",
            "spec": "0x1",
            "scope": "0x1"
        },
        "model": "0x20000000d24",
        "federationGuid": "a2df1c87-f272-419d-a2ab-ad91c33bbea0",
        "category": "0x20000000e96",
        "placement": {
            "origin": [
                417615.95371096185,
                78717.31761312821,
                255.37159999999977
            ],
            "angles": {
                "yaw": 26.015551784000138
            },
            "bbox": {
                "low": [
                    -0.313128837209305,
                    0.09207500000000005,
                    -5.994399999999933
                ],
                "high": [
                    0.3726711627906958,
                    0.4413250000000588,
                    -5.283199999999931
                ]
            }
        },
        "typeDefinition": {
            "id": "0x2000000019c",
            "relClassName": "BisCore:PhysicalElementIsOfType"
        }
    }
]

[khanaffan]

You can use Instance Query

Instance queries allow you to select properties defined in derived classes when selecting a base class or multiple properties with the same name defined in different derived classes.