DataCellDetail method query - how to filter on UD members

Ashok
New Contributor III

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 systax to make it work. In below example I am trying to filter and get all the rows for UD1 DL014. when I run the query it gives me erything for that Entity,Scenario and Time. Appreciate the help.

 

Ashok_0-1675716868301.png

 

1 ACCEPTED SOLUTION

kberry
New Contributor III

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

View solution in original post

2 REPLIES 2

kberry
New Contributor III

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

Ashok
New Contributor III

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'}