freshservice_agentfreshservice_agent_rolefreshservice_announcementfreshservice_assetfreshservice_asset_componentfreshservice_asset_contractfreshservice_asset_typefreshservice_business_hourfreshservice_changefreshservice_change_notefreshservice_contractfreshservice_contract_typefreshservice_departmentfreshservice_locationfreshservice_problemfreshservice_problem_notefreshservice_problem_taskfreshservice_problem_timeentryfreshservice_productfreshservice_purchase_orderfreshservice_releasefreshservice_release_notefreshservice_release_taskfreshservice_release_timeentryfreshservice_requesterfreshservice_servicefreshservice_sla_policyfreshservice_softwarefreshservice_software_installationfreshservice_software_userfreshservice_solution_articlefreshservice_solution_categoryfreshservice_solution_folderfreshservice_ticketfreshservice_ticket_conversationfreshservice_ticket_taskfreshservice_ticket_timeentryfreshservice_vendor
Table: freshservice_solution_folder
Obtain Solution Folders from the FreshService instance.
Examples
List all solution folders
select *from freshservice_solution_folder;
Get a specific solution folder by id
select *from freshservice_solution_folderwhere id = 200964200;
Schema for freshservice_solution_folder
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
category_id | bigint | ID of the category under which the solution folder is listed. | |
created_at | timestamp with time zone | Timestamp when the solution folder was created. | |
default_category | boolean | Set to true if the solution folder is the default one. | |
department_ids | jsonb | Array of IDs of the departments to which this solution folder is visible. | |
description | text | Description about the solution folder. | |
group_ids | jsonb | Array of IDs of the agent groups to which this solution folder is visible. | |
id | bigint | = | ID of the solution folder. |
manage_by_group_ids | jsonb | Array of IDs of groups which manage this solution folder. | |
name | text | Name of the solution folder. | |
position | bigint | The rank of the solution folder in the folder listing. | |
requester_group_ids | jsonb | Array of IDs of requester groups to which this solution folder is visible. | |
updated_at | timestamp with time zone | Timestamp when the solution folder was last updated. | |
visibility | bigint | Accessibility of this solution folder. |