Firstly, non-spatial mean no geometry. however, polygon geometry is implying spatial.

So maybe the where clause is not your problem: change reader to a spatial sql source.

But regardless, use 'where = *' as a wildcard and take all.

thanks,i have changed it to spatial but is it possible to read only two polygon from all polygons directly from reader ; i do not want to export all polygons . i want to specify only two polygon

thanks for help

SELECT * where [objectidfield] = [xx] or [objectidfield] = [xx].

I would read them all and use a sampler transformer. Or if you know the database and the row's id then you can use similar statement above.

thanks for reply . i got it but i have still problem .

when i use SELECT * where objectidfield] = xx] or objectidfield] = xx]

i show only in quicktranslator only one row id to enter ,it does not show me two empty field to enter two row's id

only one empty field

my target

when i want to use quick translator ,i would like to write two row's id in quick translator then the workbench works to export it .

at inside workbench what i tried to do ,i used apply to for one of user parameters set where clause and connect it to the reader of polygon

and i created another user parameter with another name and connects to the same reader where set clause .i found ,reference at first user parameter will delete after i connected to the second user parameter at this reader .

should i create two user parameter or is it possible to do with one user parameter ?

i am new in fme and i am confused ,how could i do this process .

Thanks for help

step 1 add sql reader and select table in parameter; press ok

step 2 in workbench, double click on feature type

step 3 locate where clause and open text editor

step 4 pull down database tables tab

please utilize FME's resources such as this: https://www.safe.com/training/recorded/introduction-fme-desktop-2020/

thanks alot . it works and i will watch the video .