how to get records from system table for a specific esapce

how to get records from system table for a specific esapce

  
I need records from Role table of outsystems for my current espace. 

to achieve this, i can specify the espace_id and get the records, but for all the enviroment (development, testing, production) I'll have different espace_id. and thus its not a feasible idea.

Please help me, how can I get record for current espace from Role/User table of Outsystems.

Thanks
Hi Salil,

You can also join the Role table with the Espace table and filter with the espace module name because the name will be the same across environments.

Cheers,