RecruitingCEJobRequisitionsflexFieldsFacetvalues
RecruitingCEJobRequisitionsflexFieldsFacetvalues
Columns
Name | Type | Description |
RecruitingCEJobRequisitionsSearchId [KEY] | Long | Finds job requisitions using a search ID and a primary key |
FlexfieldsfacetName [KEY] | String | Finds job flexfields facet using a unique ID and ID |
Id [KEY] | String | ID assigned to the flexfield facet value. |
Name | String | Name assigned to the flexfields facet value. |
TotalCount | Long | Total count of the flexfields facet values. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
SearchId | Long | SearchId |
CandidateNumber | String | candidateNumber |
CorrectedKeyword | String | correctedKeyword |
ExecuteSpellCheckFlag | String | executeSpellCheckFlag |
FacetsList | String | facetsList |
Finder | String | finder |
HotJobFlag | String | hotJobFlag |
JobFamilyId | String | jobFamilyId |
Keyword | String | keyword |
LastSelectedFacet | String | lastSelectedFacet |
Latitude | String | latitude |
Limit | Long | limit |
Location | String | location |
LocationId | String | locationId |
Longitude | String | longitude |
Offset | Long | offset |
OrganizationId | String | organizationId |
PostingEndDate | String | postingEndDate |
PostingStartDate | String | postingStartDate |
Radius | Long | radius |
RadiusUnit | String | radiusUnit |
RequisitionId | Long | requisitionId |
SelectedCategoriesFacet | String | selectedCategoriesFacet |
SelectedFlexFieldsFacets | String | selectedFlexFieldsFacets |
SelectedLocationsFacet | String | selectedLocationsFacet |
SelectedOrganizationsFacet | String | selectedOrganizationsFacet |
SelectedPostingDatesFacet | String | selectedPostingDatesFacet |
SelectedTitlesFacet | String | selectedTitlesFacet |
SelectedWorkLocationsFacet | String | selectedWorkLocationsFacet |
SelectedWorkplaceTypesFacet | String | selectedWorkplaceTypesFacet |
SiteNumber | String | siteNumber |
SortBy | String | sortBy |
UseExactKeywordFlag | String | useExactKeywordFlag |
UserTargetFacetInputTerm | String | userTargetFacetInputTerm |
UserTargetFacetName | String | userTargetFacetName |
WorkLocationCountryCode | String | workLocationCountryCode |
WorkLocationZipCode | String | workLocationZipCode |