In Event Portal, when you update an Event API Product, you can update an existing version or create a new version of the Event API Product. Versions allow you to work on updates and test new versions in development and staging environments while the stable version remains in the production environment. Each version also has a lifecycle state.
- Provide a numeric
id
if you want to query for a specific Event API Product version. This can be either set directly in awhere
clause, or specified as part ofjoin
with another table.
- Be careful when requesting all columns (
*
) without using anid
in the query. To load this data, Steampipe will have to issue multiple API request to retrieve all resources (essentially issuing a paginated queries).
select
ev.version as version,
ev.display_name as versionName,
e.name as name
from
solace_eventapi_product_version ev
join
solace_eventapi_product e
on ev.event_api_product_id = e.id
where
ev.id = 'n5o41x2fh62';
-- or a simplified version
select
id,
version,
display_name
from
solace_eventapi_product_version;
select
id,
version,
display_name,
summary,
event_api_version_ids,
state_id,
created_time,
created_by,
changed_by,
updated_time
from
solace_eventapi_product_version
where
id = 'n5o4xx2fh62';
select
id,
version,
display_name,
summary,
event_api_version_ids,
state_id,
created_time,
created_by,
changed_by,
updated_time
from
solace_eventapi_product_version
where
created_time >= now() - interval '30' day;
select
id,
version,
display_name,
summary,
event_api_version_ids,
state_id,
created_time,
created_by,
changed_by,
updated_time
from
solace_eventapi_product_version
where
updated_time <= now() - interval '10' day;