Forum Discussion

Ashok's avatar
Ashok
New Contributor III
2 years ago

DataCellDetail method query - how to filter on UD members

Hey Experts, I am trying to read the Datacelldetail line items. thought of using Method query but not able to filter it based on UD filter criteris. does anyone know if it is possible? whats the sy...
Dashboards
  • kberry's avatar
    kberry
    2 years ago

    It is possible. You are using the UD1 prefix in the UD4 field in your method string example. 

kberry's avatar
kberry
New Contributor III
2 years ago

It is possible. You are using the UD1 prefix in the UD4 field in your method string example. 

  • Ashok's avatar
    Ashok
    New Contributor III
    2 years ago

    Thanks Berry. my bad. even then it was giving all rows so tried to use the last field as below and it worked.

    {AUM}{E#RevAccComments}{RevAccRecon}{T#2022Q3}{}{}{}{}{}{}{}{}{}{}{}{UD4='DL014'}