i have a workflow report as the following ima...

expressions
(葉志成) #1

i have a workflow report as the following image. I want to constrain list when [d_aviblenum]<>0. what expression i can set?

(Aleksi Alkio) #2

Try with SELECT([Related AM Ds][h_id],NOT([d_aviblenum]=0))

(葉志成) #3

@Aleksi_Alkio <<Start: SELECT([Related AM Ds][h_id],NOT([d_aviblenum]=0))>><<[d_numkey]>>

I had tried,but there is no thing happen.

is that have other solution?

(Aleksi Alkio) #4

Are you seeing any error messages?

(葉志成) #5

not any error messages! it not any report show in my mail, but as the standard <<Start: [Related AM Ds]>><<[d_numkey]>> it can show the report in my mail. so i have no idea where it’s wrong?

(Aleksi Alkio) #6

Is your column [d_aviblenum] a number or text field?

(葉志成) #7

number