Facing prob while creating a dynamic adapter...

Hi

I am creating one dynamic adapter for couting the total records in the table based on some search criteria of user, but problem is when I am giving the query with condition i.e.

select count(*) from TABLE $(condition)

than in input of adapter service condition option is not there to map or to give input condition to adapter…

I tried a lot of it is not showing…
Anybody can help in it…

Thanks in adavance

Bijendra

Sorry
I got the problem…actually I was using wrong brakets…correct is {condition}.

Anyway thanks,

correct is ${condition/inputfield}