Can we copy the Filters of the EG Query builder like values to a data set

[ykk]

Hi Team

I have a requirement where I need to copy the Filters that are used in a query builder to a variable in a data set.

Thanks

Kiran

[Reeza]

The filters are likely stored as macro variables, so you need to determine the macro variable names required and you can store them in data set.

[ykk]

Thanks for the reply.

My query builder contains a mix of Prompts and Static Filters that were added.I could not find any macro variable for the filters.Does it require any settings change to my EG.I had used %put _ALL_ to list down all the macro variables.

[Reeza]

I think they're called Parameters in EG, you don't see a parameter for each filter?

[ykk]

I am not using prompts in the Filter.I have a Filter which says EMP_ID IN (123,456) and DEPT_ID =20.  I all those filters to be extracted.

[Reeza]

Those are hardcoded then. I don't think they're included anywhere so you'll have to hardcode them into your output file.