Selecting addresses by SQL

0

Hello,
I think - SQL filter is missing the context of the current workflow instance.
....
AND WFD_ID={WFD_ID}


Best regards
Maryna

Hi,
try changing the [data source] to the default BPS database

Thanks, I also tried AND WFD_ID={WFD_ID}
again all records are returned

Thanks, I also tried with Default data source.
Again all records are returned

Hi Radostina,

I tested it in a 2025 version and it works just fine if the default data source is used. In this case the Test only shows the expected columns.

If the Users and groups data source is used, the SQL is ignored, at least when testing. I haven't tested it in a real scenario.

I agree with Jacek, you should be fine when switching to the default data source. Maybe you can post a screenshot when changing the data source and tell us your WEBCON BPS version.

Best regards,
Daniel

I am attaching a screenshot.
Data source is default. Now it doesn't return any results..
it looks like my filter is not working..

But now you can see that the query is targeting the correct database because you have the correct WFD_Attchoose2 column in the result :-)
You need to check if you're actually looking for the correct data in the WFD_AttText1 field (for example, if there are any spaces).
Could you screenshot this query in "Advanced mode?"

I have one additional comment. If you are executing the test, please ensure that you selected the correct instance id, which actually has a value in the form field. WEBCON loads the last existing instance id for the current process, this can be the correct one, but it's something you should check.
The easiest check is, to click on "Show".

Best regards,
Daniel

Hi,

I’m not 100% sure, but shouldn’t the SQL return only the ID part (which matches COS_BpsID in your case)?

That’s how I read the help text. If that’s correct, you’ll need to modify the SQL to return only the ID - similar to what’s shown in the screenshot.

I can’t test your specific case right now, but it’s worth trying.

Best,
Bjoern

P.S.: My ID is already an email adress - but try only the ID part in your case.

P.P.S.: I have added the picture "Real_Use_Case.png" - Just today I needed a SQL for my project (here again: ID=email / Name=surname, first name)

I am sending screenshot in "Advanced mode?"

Yes, It loads the last existing instance id for the current process and this is the correct one.
I am sending "Show" result, but still missing data from the data source

It works!
Thank you very much!

Perfect.