SQL syntax in plugins - refering to collections

I would like to use the sql plugin to extract data in a workflow, but I can not refer to the collection names I have created, the reponse says it does not exist?

This works fine: select * from Users

But trying to select from a collection I have created do not work: select * from Resurser

image

It’s hard to provide assistance with only this information. You can minimize the reproduction of your scenario in a demo.

I do not think it is hard. I olny need to know how to refer to a collection I have cretaed myself. The collections cretaed by “system” users and roles I can query using Select but I can not refer to a collection I have created myself. There must be prefix or so that I need, but I can not figure that out myself I´m afaraid.

Custom collections are exactly the same as users and roles, and there’s nothing special about them.

OK, I will create a limmited test case and see if I can replicate the problem there. Thank´s for now.