3 Replies Latest reply: May 15, 2014 9:58 AM by Nick Osdale-Popa RSS

    LARGE FILTER

    JCC _

      I am needing to search for all of these specific numbers and wanted to know what the easiest way to put all of them in a filter. Below is the list.

      Monarch V 4.05 Thanks for your assistance.

      John

      00042,00053,00054,00071,00074,00079,00083,00097,00100,00116,00120,00126,00130,00142,00144,00156,00292,00306,00340,00350,00368,00376,00392,00412,00418,00424,00430,00491,00578,01025,01031,01093,01493,01495,01499,01501,01528,01530,01532,01534,01536,0153 8,01540,01542,01544,01546,01558,01560,01566,01568,01574,01578,01638,01640,01652,01688,01712,01720,01750,01752,01763,01765,01866,01870,01894,01896,01916,01920,01934,01986,01989,01992,02026,02038,26150,26184,30022,30024,30028,30030,30032,30052,30053,30 079,30097,30228,30230,30232,30234,30236,30392,30438,30440,30478,30484,30486,30540,30542,30548,30550,30580,30586,30588,30606,30608,30610,30614,30616,30624,30630,30666,30668,30670,30672,30676,30678,30680,30682,30684,30686,30688,30690,30704,30706,30708, 30716,30728,30732,30734,30739,30741,30790,30824,30910,30912,30991,30993,31014,31053,31078,31080,31082,31084,31088,43817,43819,60074,60131,60133,60135,60137,60139,60141,60143,60145,60147,60149,60151,60153,60157,60158,60159,60160,60161,60162,60163,6016 4,60165,60166,60167,60168,60169,60170,60171,60172,60173,60174,60175,60176,60177,60178,60179,60180,60181,60182,60184,60186,60188,60190,60192,60194,60196,60198,60200,60202,60204,60206,60208,60210,60212,60214,60216,60218,60220,60222,60224,60226,60227,60 228,60229,60230,60231,60232,60233,60234,60235,60236,60237,60238,60239,60240,60241,60242,60243,60244,60245,60246,60247,60248,60249,60250,60251,60252,60253,60254,60255,60256,60258,60260,60262,60263,60264,60265,60266,60267,60268,60269,60270,60271,60272, 60273,60274,60275,60276,60277,60278,60279,60280,60281,60282,60283,60284,60285,60286,60287,60288,60289,60290,60291,60292,60293,60294,60295,60296,60297,60298,60299,60300,60301,60302,60303,60304,60305,60306,60307,60308,60309,60310,60311,60312,60313,6031 4,60315,60316,60317,60318,60319,60320,60321,60322,60323,60324,60325,60326,60327,60328,60329,60330,60331,60332,60333,60334,60335,60336,60337,60338,60339,60340,60341,60342,60343,60344,60345,60346,60348,60349,60350,60351,60352,60353,60354,60355,60356,60 358,60360,60361,60362,60363,60364,60365,60366,60367,60368,60369,60370,60371,60372,60373,60374,60375,60376,60377,60378,60379,60380,60381,60382,60383,60384,60385,60386,60387,60388,60389,60390,60391,60392,60393,60394,60395,60396,60397,60398,60399,60400, 60401,60402,60403,60404,60405,60406,60407,60408,60409,60410,60411,60412,60413,60414,60415,60416,60417,60418,60419,60420,60421,60422,60423,60424,60425,60426,60427,60428,60429,60430,60431,60432,60433,60434,60435,60436,60437,60438,60439,60440,60441,6044 2,60443,60445,60446,60447,60448,60449,60450,60451,60452,60453,60454,60455,60456,60457,60458,60459,60460,60461,60462,60463,60464,60465,60467,60468,60469,60470,60471,60472,60473,60474,60475,60476,60477,60478,60479,60480,60481,60482,60483,60484,60485,60 486,60487,60488,60489,60500,60502,60504,60506,60508,60510,60512,60514,60516,60518,60520,60522,60524,60526,60528,60530,60532,60534,60536,60538,60540,60542,60546,60548,60550,60552,60554,60556,60558,60560,60562,60564,60566,60568,60570,60572,60574,60576, 60578,60580,60582,60584,60586,60588,60589,60590,60591,60592,60593,60594,60595,60596,60597,60598,60599,60600,60601,60602,60604,60606,60608,60610,60612,60614,60616,60620,60622,60624,60626,60628,60630,60632,60634,60636,60638,60640,60642,60644,60650,6065 2,60654,60656,60658,60660,60662,60664,60666,60668,60670,60672,60674,60676,60678,60680,60682,60684,60686,60688,60690,60692,60694,60696,60698,60700,60702,60704,60706,60708,60710,60712,60714,60716,60718,60720,60724,60726,60728,60732,60734,60736,60738,60 740,60742,60750,60752,60754,60756,60758,60760,60762,60764,60766,60768,60770,60772,60774,60776,60778,60780,60782,60784,60786,60788,60790,60792,60794,60796,60802,60804,60810,60812,60814,60816,60818,60820,60822,60824

        • LARGE FILTER
          Grant Perkins

          JCC,

           

          I can't remember if 4.05 has internal lookup tables - somehow I think not.

           

          But if I havd the facility, particularly as an External Lookup using one of the Monarch Pro versions, I would create a table of the filter values you want and set a flag against the Monarch Table record using the lookup facility.

           

          Then all you need to do is filter based on the existence (or not) of the flag.

           

          You could also extend the idea to use several flags (but far fewer than codes to be flagged) and then define one or more smaller filters to provide flexible reporting.

           

          Are there any other data associated with the records that could be used as successful substitutes to the numbers for filtering purposes?

           

           

          Grant

          • LARGE FILTER
            Nick Osdale-Popa

            The internal lookup or external tables are your best bet, as Grant has stated. You'll probably run out of character space using a direct filter with all those numbers, but I believe it would be written as such:

            [font="courier"][YourField].IN.("00042","00053","00054","00071","00074",...)[/font][/quote]I'm assuming YourField is character because of the leading zeros.

            • LARGE FILTER
              Nick Osdale-Popa

              It was pointed out to me (thanks, Grant!) that v4 does not have .IN.() function. In that case, the filter could be written as

              [font="courier"]INSTR(,"00042,00053,00054,00071,00074,...,60816,60818,60820,60822,60824") >0[/font][/quote]This will look for amongst the large string of your numbers. Again, you may run into a character limit for the filter.