{"id":1624,"date":"2021-11-04T15:51:56","date_gmt":"2021-11-04T06:51:56","guid":{"rendered":"https:\/\/kintools.com\/?post_type=docs&p=1624"},"modified":"2021-11-04T15:51:56","modified_gmt":"2021-11-04T06:51:56","password":"","slug":"operators","status":"publish","type":"docs","link":"https:\/\/kintools.com\/en\/docs\/operators\/","title":{"rendered":"operator"},"content":{"rendered":"

Operators let you define the circumstances under which a condition is considered true. The available operators depend on the data type being operated on, so only the appropriate operators are available. For example, a logical condition can only be true or false, so it cannot be greater than what makes the greater-than operator inappropriate for its data type.<\/p>\n\n\n\n

operator<\/strong><\/th>Data type<\/strong><\/th>explanation<\/strong><\/th><\/tr>
string<\/strong><\/td>Numerical value<\/strong><\/td>date<\/strong><\/td>logic<\/strong><\/td>Expression<\/strong><\/td><\/tr>
be equivalent to<\/td>\"\"<\/td>\"\"<\/td>\"\"<\/td>\"\"<\/td>\"\"<\/td>The condition is true if the first value is equal to the second value. <\/td><\/tr>
not equal<\/td>\"\"<\/td>\"\"<\/td>\"\"<\/td>\"\"<\/td>\"\"<\/td>The condition is true if the first value is not equal to the second value. <\/td><\/tr>
Between<\/td> <\/td>\"\"<\/td>\"\"<\/td> <\/td>\"\"<\/td>The condition is true if the first value is within the range. <\/td><\/tr>
not between<\/td> <\/td>\"\"<\/td>\"\"<\/td> <\/td>\"\"<\/td>The condition is true if the first value is not in the range. <\/td><\/tr>
Greater<\/td> <\/td>\"\"<\/td>\"\"<\/td> <\/td>\"\"<\/td>The condition is true if the first value is greater than the second value. <\/td><\/tr>
that's all<\/td> <\/td>\"\"<\/td>\"\"<\/td> <\/td>\"\"<\/td>The condition is true if the first value is greater than the second value equal to the second value. <\/td><\/tr>
Less than<\/td> <\/td>\"\"<\/td>\"\"<\/td> <\/td>\"\"<\/td>The condition is true if the first value is less than the second value. <\/td><\/tr>
below or below<\/td> <\/td>\"\"<\/td>\"\"<\/td> <\/td>\"\"<\/td>The condition is true if the first value is less than or equal to the second value. <\/td><\/tr>
include<\/td>\"\"<\/td> <\/td> <\/td> <\/td> <\/td>The condition is true if the first value contains the second value. This operator is used only for strings. <\/td><\/tr>
Not included<\/td>\"\"<\/td> <\/td> <\/td> <\/td> <\/td>The condition is true if the first value does not contain the second value. This operator is used only for strings. <\/td><\/tr>
starts with<\/td>\"\"<\/td> <\/td> <\/td> <\/td> <\/td>The condition is true if the first value starts with the second value. This operator is used only for strings. <\/td><\/tr>
end with<\/td>\"\"<\/td> <\/td> <\/td> <\/td> <\/td>The condition is true if the first value ends with the second value. This operator is used only for strings. <\/td><\/tr><\/tbody><\/table><\/figure>","protected":false},"excerpt":{"rendered":"

\u6f14\u7b97\u5b50\u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u6761\u4ef6\u304c\u771f\u3067\u3042\u308b\u3068\u898b\u306a\u3055\u308c\u308b\u72b6\u6cc1\u3092\u5b9a\u7fa9\u3067\u304d\u307e\u3059\u3002\u4f7f\u7528\u53ef\u80fd\u306a\u6f14\u7b97\u5b50\u306f\u3001\u64cd\u4f5c\u5bfe\u8c61\u306e\u30c7\u30fc\u30bf\u578b\u306b\u3088\u3063 […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"","ocean_second_sidebar":"","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"","ocean_custom_header_template":"","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"","ocean_menu_typo_font_family":"","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","footnotes":""},"doc_category":[71],"doc_tag":[],"class_list":["post-1624","docs","type-docs","status-publish","hentry","doc_category-conditional-formatting","entry"],"year_month":"2026-05","word_count":40,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"yuko.imai","author_nicename":"yuko-imai","author_url":"https:\/\/kintools.com\/en\/author\/yuko-imai\/"},"doc_category_info":[{"term_name":"\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f","term_url":"https:\/\/kintools.com\/en\/docs-category\/conditional-formatting\/"}],"doc_tag_info":[],"_links":{"self":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs\/1624","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/comments?post=1624"}],"version-history":[{"count":1,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs\/1624\/revisions"}],"predecessor-version":[{"id":1625,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs\/1624\/revisions\/1625"}],"wp:attachment":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/media?parent=1624"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/doc_category?post=1624"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/doc_tag?post=1624"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}