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
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.
