isnotblank() & filter()

[Andy_strathmore]

Hi Guys,

I wrote an expression as following for existing row checking.

isnotblank(filter("tableA",([id] = [_thisrow].[id])))

Table A key column id,

Table B _ComputedKey id, timestamp.

There is a bot for Table B, checking existing id in Table A.

If it is isnotblank, then update, if blank then add new row.

It is strange that this expression doesn't work.

No matter there is same id in Table A or not,

always get result as blank.

Anyone know what is wrong with this expression?

[SkrOYC]

Make sure you understand the implication of a computed key. I would never use that unless I really need it

[Andy_strathmore]

Hi SkrOYC,

Thank you for you reply.

I removed computed key and tried again.

Still not working.

I did test the expression by using test function. Expression Result showed "Y",

But it worked as "N" during bot process.

result of test functionexpression in processexpression result showed in monitor

[SkrOYC]

Ok, I didn't say that you should delete your computed key, just that you need to understand the usage of it.

Second, check if you have a security filter, mainly based on usersettings