Desktop productivity for business analysts and programmers

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

Reply
Contributor ykk
Contributor
Posts: 24

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

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

Grand Advisor
Posts: 17,427

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

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.
Contributor ykk
Contributor
Posts: 24

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

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.

Grand Advisor
Posts: 17,427

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

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

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

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.

 

 

Grand Advisor
Posts: 17,427

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

[ Edited ]

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

Ask a Question
Discussion stats
  • 5 replies
  • 361 views
  • 0 likes
  • 2 in conversation