{"id":2595,"date":"2021-06-01T09:52:18","date_gmt":"2021-06-01T09:52:18","guid":{"rendered":"https:\/\/help.hbsoftware365.com\/?p=2595"},"modified":"2021-07-19T09:51:58","modified_gmt":"2021-07-19T09:51:58","slug":"using-filters","status":"publish","type":"post","link":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/exsion-help-eng\/exsion-eng-06-exsion-functions\/using-filters\/","title":{"rendered":"Using filters"},"content":{"rendered":"\n

 <\/p>\n\t

When you enter a filter, you can use all the numbers and letters that you can normally use in the field. In addition, you can use some special symbols or mathematical expressions.<\/p>\n

Here are the available formats:<\/p>\n\t\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Symbol<\/th>\nMeaning<\/th>\nSample Expression<\/th>\nRecords Displayed<\/th>\n<\/tr>\n
=<\/td>\nEqual to<\/td>\n377<\/td>\nNumber 377.<\/td>\n<\/tr>\n
<\/td>\n<\/td>\nBLUE<\/td>\nThose with the BLUE code, for example, the BLUE warehouse code.<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n22-1-2015 10:00<\/td>\nAn exact datetime: 22-jan-2015 10:00:00.<\/td>\n<\/tr>\n
..<\/td>\nInterval<\/td>\n1100..2100<\/td>\nNumbers 1100 through 2100.<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n..2500<\/td>\nUp to and including 2500.<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n..31-12-2014<\/td>\nDates up to and including 31-dec-2014.<\/td>\n<\/tr>\n
|<\/td>\nEither\/or<\/td>\n1200|1300<\/td>\nThose with number 1200 or 1300.<\/td>\n<\/tr>\n
&<\/td>\nAnd<\/td>\n<2000&>1000<\/td>\nNumbers that are less than 2000 and greater than 1000.<\/td>\n<\/tr>\n
<><\/td>\nNot equal to<\/td>\n<>0<\/td>\nAll numbers except 0.<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<>A*<\/td>\nNot equal to any texts that start with A.<\/td>\n<\/tr>\n
><\/td>\nGreater than<\/td>\n>1200<\/td>\nNumbers greater than 1200.<\/td>\n<\/tr>\n
>=<\/td>\nGreater than or equal to<\/td>\n>=1200<\/td>\nNumbers greater than or equal to 1200.<\/td>\n<\/tr>\n
<<\/td>\nLess than<\/td>\n<1200<\/td>\nNumbers less than 1200.<\/td>\n<\/tr>\n
<=<\/td>\nLess than or equal to<\/td>\n<=1200<\/td>\nNumbers less than or equal to 1200.<\/td>\n<\/tr>\n
*<\/td>\nAn indefinite number of unknown characters<\/td>\n*cem*<\/td>\nTexts that contain “cem”.<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n*cem<\/td>\nTexts that end with “cem”.<\/td>\n<\/tr>\n
<\/td>\n<\/td>\ncem*<\/td>\nTexts that begin with “cem”.<\/td>\n<\/tr>\n
?<\/td>\nOne unknown character<\/td>\n?im<\/td>\nTexts such as Jim of Tim.<\/td>\n<\/tr>\n
()<\/td>\nCalculate before rest<\/td>\n30|(>=10&<=20)<\/td>\nThose with number 30 or with a number from 10 through 20 (the result of the calculation within the parentheses).<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\t

You can also combine the various format expressions:<\/p>\n\t\n\n\n\n\n\n\n\n
Sample Expression<\/th>\nRecords Displayed<\/th>\n<\/tr>\n
5999|8100..8490<\/td>\nInclude any records with the number 5999 or a number from the interval 8100 through 8490.<\/td>\n<\/tr>\n
..1299|1400\u2026<\/td>\nInclude records with a number less than or equal to 1299 or a number equal to 1400 or greater (all numbers except 1300 through 1399).<\/td>\n<\/tr>\n
>50&<100<\/td>\nInclude records with numbers that are greater than 50 and less than 100 (numbers 51 through 99).<\/td>\n<\/tr>\n
*C*&*D*<\/td>\nTexts containing both C and D.<\/td>\n<\/tr>\n
*co?*<\/td>\nTexts containing “co” such as cot, cope and incorporated.”co” must be present, followed by at least one character, but there can be an indefinite number of characters before and after these.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

  When you enter a filter, you can use all the numbers and letters that you can normally use in the field. In […]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[66],"tags":[],"class_list":["post-2595","post","type-post","status-publish","format-standard","hentry","category-exsion-eng-06-exsion-functions"],"_links":{"self":[{"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/posts\/2595","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/comments?post=2595"}],"version-history":[{"count":7,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/posts\/2595\/revisions"}],"predecessor-version":[{"id":3071,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/posts\/2595\/revisions\/3071"}],"wp:attachment":[{"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/media?parent=2595"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/categories?post=2595"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/tags?post=2595"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}