hi everyone, can you tell me how to get the information below?
I am looking for all modules that are using an action that I am coding.
Hi @Bao Nguyen Khac Not Sure if you're looking for same thing I 'm gettingIf you right the action you'll see two option one is find usage and other is find usage in all modules
You can see them in Service Center. Go in Modules, search this module you want to see consumers, then there is section Dependencies next to the versions tab. in dependencies you can see consumers and producers as well, and also you can see what are consumers using in details.
There is a table named Espace_Reference in the System module that contains information about elements referenced across different modules. You can use this table to identify which elements are being referenced and from where, and based on that, implement the appropriate logic.
Also join Espace_Version with Consumer_Version_Id, and Espace with Espace_Version.Espace_Id, to get the module. You probably also want to exclude deleted modules, and likely only take the latest version of a module (so you probably need some SQL instead of an aggregate).
Hi everyone, I need to summarize the numbers like the image above. For example, an action A is being used 3 times in module B, 5 times in module C. I want to find out where to get these numbers using sql instead of manually listing them.
I think with database you can only see the dependency directions in general, but not the number of dependency used in one module because that is compiled in the code.
here you can find all the dependencies of any module is consuming you can filter it with
this attribute and get consumers of one concrete producer module, but not the count because that part is not in the db it is in the code.
I thought it would be possible to do that if you download JSON snapshot from Discovery, but then I realised the result would be same, just connections through the espaces not the count of usage in it
Hi @Bao Nguyen Khac,You cannot get the "Find Usages" information (module name and number of usages) in other modules using a direct SQL query against the OutSystems database. The "Find Usages" functionality in Service Studio relies on undocumented REST APIs to communicate with the Service Center, which queries the database for the references. Thanks
That's just patently false. See the other answers given.