This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Search Multi Property by alias to get their ID

Hi all,

I am trying to set (flag) a property (called attached) within object class to yes (true). I do have a vbscript that works (within workflow state) but only for single properties list. I don't know how to make it work for MULTI properties list. Is there a way i can loop between all individual objects by Alias on the list (that i have added on the form) and set their attached property to true?


option explicit

'Define variables
Dim titleTypedValue
Dim oPropVal: Set oPropVal = CreateObject("MFilesAPI.PropertyValue")
Dim oProp: Set oProp = vault.PropertyDefOperations
Dim oPropValsCurrent: Set oPropValsCurrent = CreateObject("MFilesAPI.PropertyValues")
Dim IsAttached
Dim Ref
Dim Prop

'Get ID of Property
Set Ref = SearchForObject("Milestone", 1)

'Call "ATTACHTED" property and get latest version of property
set IsAttached = vault.ObjectPropertyOperations.GetProperties (Ref.ObjVer, true)

'Set "ATTACHTED" Property value to true (Yes)
oPropVal.PropertyDef = oProp.GetPropertyDefIDByAlias("Attached")

oPropVal.TypedValue.SetValue MFDatatypeBoolean, true
oPropValsCurrent.Add -1, oPropVal

'Apply the new properties value
Vault.ObjectPropertyOperations.SetProperties Ref.ObjVer, oPropValsCurrent


'********************************************************************************************************************
'Search For Object method
function SearchForObject(PropertyID, Index)

Dim oPropertyValsSearch: set oPropertyValsSearch = vault.ObjectPropertyOperations.GetProperties (Objver, true)
Dim EmpName
Dim titleProperty
titleProperty = 1055

EmpName = oPropertyValsSearch.SearchForPropertyByAlias(vault, PropertyID , true).Value.DisplayValue


' Find the title property of the current object.
Dim titleSearch
Set titleSearch = CreateObject("MFilesAPI.SearchCondition")
Dim titleExpression
Set titleExpression = CreateObject("MFilesAPI.Expression")
titleExpression.SetPropertyValueExpression titleproperty, 0, Nothing

Dim titleTypedValue
Set titleTypedValue = CreateObject("MFilesAPI.TypedValue")
titleTypedValue.SetValue MFDatatypeText ,EmpName
titleSearch.Set titleExpression, MFConditiontypeEqual, titleTypedValue

Dim SearchResults
Set SearchResults = Vault.ObjectSearchOperations.SearchForObjectsByCondition(titleSearch, false)

Dim oObjID: set oObjID = SearchResults.Item(Index)

set SearchForObject = oObjID

end function
Parents
  • Almost there, i can feel it :P I tested the script as you sent me and i got this error: "The object is not checked out". Caused by this line:
    Vault.ObjectPropertyOperations.SetProperty oObjVer, oPropVal


    Knowing that the object must be checked out, I tried adding CheckOut and CheckIn functions. The code turned like this:

    Dim iOTChild : iOTChild = Vault.ObjectTypeOperations.GetObjectTypeIDByAlias("Milestone") 'The other object type
    Dim iPDSiblings : iPDSiblings = Vault.PropertyDefOperations.GetPropertyDefIDByAlias("Milestones") 'The other object type multi property
    Dim oSibling : set oSibling = CreateObject("MFilesAPI.Lookup")
    Dim oSiblings : set oSiblings = PropertyValues.SearchForProperty(iPDSiblings).TypedValue.GetValueAsLookups()
    Dim oObjVer, oObjVerProps
    Dim oObjID: set oObjID = CreateObject("MFilesAPI.ObjID")
    Dim oPropVal: Set oPropVal = CreateObject("MFilesAPI.PropertyValue")
    oPropVal.PropertyDef = Vault.PropertyDefOperations.GetPropertyDefIDByAlias("Attached_Milestone")
    oPropVal.TypedValue.SetValue MFDatatypeBoolean, true
    'Added variable
    Dim CheckedOutObjeactVersion

    For Each oSibling in oSiblings
    oObjID.SetIDs iOTChild, oSibling.Item
    set oObjVer = vault.ObjectOperations.GetLatestObjVer(oObjID,False,True)

    'Added Check Out
    CheckedOutObjeactVersion = vault.ObjectOperations.CheckOut(oObjID)

    Vault.ObjectPropertyOperations.SetProperty CheckedOutObjeactVersion.ObjVer, oPropVal

    'Added Check In
    vault.ObjectOperations.CheckIn(CheckedOutObjeactVersion.ObjVer)
    Next


    I tested the loop and it's giving me the correct object ID.

    However I get another error "Object doesn't support this property or method" at line:
    CheckedOutObjeactVersion = vault.ObjectOperations.CheckOut(oObjID)


    I tried some other declaration alternatives however I'm still stuck getting this error.

    Do you know any way to break free out of this one?
Reply
  • Almost there, i can feel it :P I tested the script as you sent me and i got this error: "The object is not checked out". Caused by this line:
    Vault.ObjectPropertyOperations.SetProperty oObjVer, oPropVal


    Knowing that the object must be checked out, I tried adding CheckOut and CheckIn functions. The code turned like this:

    Dim iOTChild : iOTChild = Vault.ObjectTypeOperations.GetObjectTypeIDByAlias("Milestone") 'The other object type
    Dim iPDSiblings : iPDSiblings = Vault.PropertyDefOperations.GetPropertyDefIDByAlias("Milestones") 'The other object type multi property
    Dim oSibling : set oSibling = CreateObject("MFilesAPI.Lookup")
    Dim oSiblings : set oSiblings = PropertyValues.SearchForProperty(iPDSiblings).TypedValue.GetValueAsLookups()
    Dim oObjVer, oObjVerProps
    Dim oObjID: set oObjID = CreateObject("MFilesAPI.ObjID")
    Dim oPropVal: Set oPropVal = CreateObject("MFilesAPI.PropertyValue")
    oPropVal.PropertyDef = Vault.PropertyDefOperations.GetPropertyDefIDByAlias("Attached_Milestone")
    oPropVal.TypedValue.SetValue MFDatatypeBoolean, true
    'Added variable
    Dim CheckedOutObjeactVersion

    For Each oSibling in oSiblings
    oObjID.SetIDs iOTChild, oSibling.Item
    set oObjVer = vault.ObjectOperations.GetLatestObjVer(oObjID,False,True)

    'Added Check Out
    CheckedOutObjeactVersion = vault.ObjectOperations.CheckOut(oObjID)

    Vault.ObjectPropertyOperations.SetProperty CheckedOutObjeactVersion.ObjVer, oPropVal

    'Added Check In
    vault.ObjectOperations.CheckIn(CheckedOutObjeactVersion.ObjVer)
    Next


    I tested the loop and it's giving me the correct object ID.

    However I get another error "Object doesn't support this property or method" at line:
    CheckedOutObjeactVersion = vault.ObjectOperations.CheckOut(oObjID)


    I tried some other declaration alternatives however I'm still stuck getting this error.

    Do you know any way to break free out of this one?
Children
No Data