Difference between revisions of "User: Bgrenon/2"
| Line 37: | Line 37: | ||
tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId,ComponentRN__ComponentId=CompId,Component | tables=ComponentRN,ComponentRN__DeploymentTypeId=DepId,ComponentRN__ComponentId=CompId,Component | ||
|join on=ComponentRN._ID=DepId._rowID,DepId._rowID=CompId._rowID,CompId._rowId=Component.Id | |join on=ComponentRN._ID=DepId._rowID,DepId._rowID=CompId._rowID,CompId._rowId=Component.Id | ||
| − | |fields=CompId._value=ComponentId | + | |fields=CompId._value=ComponentId,Component.Name |
|group by=ComponentRN.ComponentId | |group by=ComponentRN.ComponentId | ||
|order by=Component.Name DESC | |order by=Component.Name DESC | ||
| − | |format=template | + | <!--|format=template |
|template=GetMaxReleaseDate | |template=GetMaxReleaseDate | ||
|named args=yes | |named args=yes | ||
|intro=<table class="wikitable sortable"><tr><th>Service</th><th>Release</th><th>Released On</th><th>Released for</th><th>Highlights</th></tr> | |intro=<table class="wikitable sortable"><tr><th>Service</th><th>Release</th><th>Released On</th><th>Released for</th><th>Highlights</th></tr> | ||
| − | |outro=</table> | + | |outro=</table>--> |
|where=ComponentRN._pageNamespace="0" AND (DepId._value='5439f1be-1868-4091-b058-1667389b6ce1' OR DepId._value='ec194bf2-b79a-436d-8ff6-eaff94d9f43a') AND ReleaseDate IS NOT NULL | |where=ComponentRN._pageNamespace="0" AND (DepId._value='5439f1be-1868-4091-b058-1667389b6ce1' OR DepId._value='ec194bf2-b79a-436d-8ff6-eaff94d9f43a') AND ReleaseDate IS NOT NULL | ||
}} | }} | ||
</tabber> | </tabber> | ||
Revision as of 15:18, April 29, 2022
Query: SELECT `cargo__ComponentRN`.`ComponentId` AS `ComponentId` FROM `cargo__ComponentRN` LEFT OUTER JOIN `cargo__Component` ON ((`cargo__ComponentRN`.`ComponentId` HOLDS `cargo__Component`.`Id`)) WHERE ReleaseDate IS NOT NULL AND `cargo__ComponentRN`.`_pageNamespace`="0" AND DATEDIFF(ReleaseDate,NOW()) >= -7 GROUP BY `cargo__ComponentRN`.`ComponentId` ORDER BY `cargo__Component`.`Name` LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS `cargo__Component`.`Id`)) WHERE ReleaseDate IS NOT NULL AND `cargo__Comp' at line 1 (127.0.0.1)
Query: SELECT `cargo__ComponentRN`.`ComponentId` AS `ComponentId` FROM `cargo__ComponentRN` LEFT OUTER JOIN `cargo__Component` ON ((`cargo__ComponentRN`.`ComponentId` HOLDS `cargo__Component`.`Id`)) WHERE ReleaseDate IS NOT NULL AND `cargo__ComponentRN`.`_pageNamespace`="0" AND DATEDIFF(ReleaseDate,NOW()) >= -30 GROUP BY `cargo__ComponentRN`.`ComponentId` ORDER BY `cargo__Component`.`Name` LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS `cargo__Component`.`Id`)) WHERE ReleaseDate IS NOT NULL AND `cargo__Comp' at line 1 (127.0.0.1)
| ComponentId | Name |
|---|---|
| 3422613a-aedc-4c60-8382-2568e9d0c983 | Workforce Management API |
| 074d8cb2-e6a5-4df8-97d2-d1044727c558 | Voice Orchestration Service |
| 0ed06171-d761-4c0c-855b-af391b57e8a5 | Intelligent Workload Distribution |
| edfa30cc-f909-4114-b72e-0934810e3cd4 | Authentication Service |
| acaca529-aedd-4820-8557-4966ab8490db | |
| edfa30cc-f909-4114-b72e-0934810e3cd4 | |
| 38f7f170-d83e-483b-a2ca-4dd424a28fde | |
| 38f7f170-d83e-483b-a2ca-4dd424a28fde | |
| 074d8cb2-e6a5-4df8-97d2-d1044727c558 | |
| 9d93d57b-8e44-4ecb-97a7-ece81aa8fae8 | |
| f1190ccf-1166-4200-9105-524d0f613a35 | |
| bdc82b52-150e-4825-9a98-3c45bca3c72d | |
| dc95d354-6dba-4291-98d9-f11343c12f7b | |
| 9d93d57b-8e44-4ecb-97a7-ece81aa8fae8 | |
| 074d8cb2-e6a5-4df8-97d2-d1044727c558 | |
| e17cb0c3-b6d6-41c2-8dfc-40ee83f99d56 | |
| e17cb0c3-b6d6-41c2-8dfc-40ee83f99d56 | |
| 6e3d490b-bb6c-4e5d-8a61-313290c6d632 | |
| fd8aff3a-6766-4eb1-9281-c5c235de3426 | |
| edfa30cc-f909-4114-b72e-0934810e3cd4 | |
| b9e5e9d4-37a0-4fa2-87a3-957773249c9b | |
| 3422613a-aedc-4c60-8382-2568e9d0c983 | |
| 3be11e5d-6a28-4409-95d5-9b1af2b66417 | |
| 3be11e5d-6a28-4409-95d5-9b1af2b66417 | |
| 3be11e5d-6a28-4409-95d5-9b1af2b66417 | |
| 4c32d167-fb8a-4157-a204-8dbb1342a9f8 | |
| b9e5e9d4-37a0-4fa2-87a3-957773249c9b | |
| 7802d66f-e043-41e3-8ef9-fa8f01a5d482 | |
| c6d90412-17a5-4d3b-b822-060c75731775 | |
| 35daaa1d-708e-48b8-af6c-cf258cbd4e0a | |
| e17cb0c3-b6d6-41c2-8dfc-40ee83f99d56 |