ETM - fetch item by Custom Field value (variable assyst search?)

Hi,

as i just found in an related Topic, this seems currently not possible:

if there already exists a correpsonding Idea, i would like to support it.

Kind Regards

Christian Margardt

It seems this *might* be possible. assyst 11.6 seems to have added the ability to query by shared  custom fields. So you’ll need to define a suitable shared field.

Once you do this the new query parameter should appear in the RAML (http://<assyst>/REST/v2/raml?showDetail=true).

/items:

  type: collection

  get:

    queryParameters:

      CSGId:

        type: integer

      CSGShortCode:

        type: string

      FilteringCSGId:

        type: integer

      LookupCSGId:

        type: integer

      acquiredDate:

        type: date

      acquiredMethod:

        type: integer

…

      customColumns.testitemboolean:

        type: boolean

      customColumns.testitemdate:

        type: date

      customColumns.testitemdecimal:

        type: number

      customColumns.testiteminteger:

        type: integer

      customColumns.testitemlookup:

        type: string

      customColumns.testitemstring:

        type: string

…

If you get this far then ETM should be able to use these query parameters to find items. There are a couple of caveats to that:

1. You’ll need to use ETM 1.6 or later (earlier versions only support query parameters that correspond to a field on the entity definition)
2. You’ll need to force ETM to re-read the RAML definition (ETM assumes it’s static for each assyst version). To do this
   1. delete the file  <IPAAS>\apache-karaf-4.1.1\restmodel<ipaas version>.mod
   2. restart IPaaS

I haven’t had a chance to verify this, but it should work. 

Hello Paul,

thanks for your reply.

It might actually work, but unfortunately the custom fields are not available even under ETM 1.7.1 - at least in relation with our current assyst Version 11.4.1. We will try again after an Update.

Kind Regards

Christian

It’s core assyst that will need to be on a later version (>=11.6) for this to (probably) work.