How to give where condition in query text inside csv data set.

Hi,
I am stuck in a BIRT java program .I want to provide query text with where condition for a csv data set for eg select * from Account Overview.csv where "ACCT_NAME" ='Managed ETF'.I am using birt data engine API and fetching result through query definition.I have search a lot.Somewhere I found filters for that problem.But I am not aware how to add filter in a QueryDefinition. I hadn't got any code for that purpose.
So please guide me.
 
Thanks
Meenakshi

Find more posts tagged with

Comments

mnegi@

Hi,
Still ,I don't get any solution for the problem.Eagerly waiting for reply.
 
 
Thanks
Meenakshi

shamo

I'm not sure where you are lost. But when you select the filter tab under the dataset, you then select new and decide to use either static or dynamic. say with static, there is a drop down to select the field you want to apply the filter on once you select the dropdown, the middle becomes activated from which u can select the condition then the last space is where you type the results. u can either type or use dropdown to select value. it is case sensitive so just be careful if typing

mnegi@

<blockquote class="ipsBlockquote" data-author="shamo" data-cid="142186" data-time="1455035597">
<div>
I'm not sure where you are lost. But when you select the filter tab under the dataset, you then select new and decide to use either static or dynamic. say with static, there is a drop down to select the field you want to apply the filter on once you select the dropdown, the middle becomes activated from which u can select the condition then the last space is where you type the results. u can either type or use dropdown to select value. it is case sensitive so just be careful if typing
</div>
</blockquote>
Hi Shamo,
 
I had mentioned through data engine API I am trying to do that.I have already done that in BIRT designer as you said above.I am trying to do thing via a java program not by BIRT visual designer.
 
Thanks
Meenakshi