@univerjs-pro/engine-pivot v0.5.0-beta.1 • Docs

Enumeration: ST_PivotFilterOperatorEnum

Enum for IST_PivotFilter Operator

Enumeration Members

Enumeration Member	Value	Description	Defined in
`captionBeginsWith`	`1`	Filter by caption that begins with a specific value	types/enum.ts:288
`captionBetween`	`2`	Filter by caption that is between two values	types/enum.ts:294
`captionContains`	`3`	Filter by caption that contains a specific value	types/enum.ts:300
`captionEndsWith`	`4`	Filter by caption that ends with a specific value	types/enum.ts:306
`captionEqual`	`5`	Filter by caption that is equal to a specific value	types/enum.ts:312
`captionGreaterThan`	`6`	Filter by caption that is greater than a specific value	types/enum.ts:318
`captionGreaterThanOrEqual`	`7`	Filter by caption that is greater than or equal to a specific value	types/enum.ts:324
`captionLessThan`	`8`	Filter by caption that is less than a specific value	types/enum.ts:330
`captionLessThanOrEqual`	`9`	Filter by caption that is less than or equal to a specific value	types/enum.ts:336
`captionNotBeginsWith`	`10`	Filter by caption that does not begin with a specific value	types/enum.ts:342
`captionNotBetween`	`11`	Filter by caption that is not between two values	types/enum.ts:348
`captionNotContains`	`12`	Filter by caption that does not contain a specific value	types/enum.ts:354
`captionNotEndsWith`	`13`	Filter by caption that does not end with a specific value	types/enum.ts:360
`captionNotEqual`	`14`	Filter by caption that is not equal to a specific value	types/enum.ts:366
`count`	`15`	Filter by count	types/enum.ts:372
`dateBetween`	`16`	Filter by date that is between two values	types/enum.ts:378
`dateEqual`	`17`	Filter by date that is equal to a specific value	types/enum.ts:384
`dateNewerThan`	`18`	Filter by date that is newer than a specific value	types/enum.ts:390
`dateNewerThanOrEqual`	`19`	Filter by date that is newer than or equal to a specific value	types/enum.ts:396
`dateNotBetween`	`20`	Filter by date that is not between two values	types/enum.ts:402
`dateNotEqual`	`21`	Filter by date that is not equal to a specific value	types/enum.ts:408
`dateOlderThan`	`22`	Filter by date that is older than a specific value	types/enum.ts:414
`dateOlderThanOrEqual`	`23`	Filter by date that is older than or equal to a specific value	types/enum.ts:420
`lastMonth`	`24`	Filter by last month	types/enum.ts:426
`lastQuarter`	`25`	Filter by last quarter	types/enum.ts:432
`lastWeek`	`26`	Filter by last week	types/enum.ts:438
`lastYear`	`27`	Filter by last year	types/enum.ts:444
`M1`	`28`	Filter by dates in January	types/enum.ts:450
`M10`	`29`	Filter by dates in October	types/enum.ts:456
`M11`	`30`	Filter by dates in November	types/enum.ts:462
`M12`	`31`	Filter by dates in December	types/enum.ts:468
`M2`	`32`	Filter by dates in February	types/enum.ts:474
`M3`	`33`	Filter by dates in March	types/enum.ts:480
`M4`	`34`	Filter by dates in April	types/enum.ts:486
`M5`	`35`	Filter by dates in May	types/enum.ts:492
`M6`	`36`	Filter by dates in June	types/enum.ts:498
`M7`	`37`	Filter by dates in July	types/enum.ts:504
`M8`	`38`	Filter by dates in August	types/enum.ts:510
`M9`	`39`	Filter by dates in September	types/enum.ts:516
`nextMonth`	`40`	Filter by next month	types/enum.ts:522
`nextQuarter`	`41`	Filter by next quarter	types/enum.ts:528
`nextWeek`	`42`	Filter by next week	types/enum.ts:534
`nextYear`	`43`	Filter by next year	types/enum.ts:540
`percent`	`44`	Filter by percent	types/enum.ts:546
`Q1`	`45`	Filter by first quarter	types/enum.ts:552
`Q2`	`46`	Filter by second quarter	types/enum.ts:558
`Q3`	`47`	Filter by third quarter	types/enum.ts:564
`Q4`	`48`	Filter by fourth quarter	types/enum.ts:570
`sum`	`49`	Filter by sum	types/enum.ts:576
`thisMonth`	`50`	Filter by this month	types/enum.ts:582
`thisQuarter`	`51`	Filter by this quarter	types/enum.ts:588
`thisWeek`	`52`	Filter by this week	types/enum.ts:594
`thisYear`	`53`	Filter by this year	types/enum.ts:600
`today`	`54`	Filter by today	types/enum.ts:606
`tomorrow`	`55`	Filter by tomorrow	types/enum.ts:612
`unknown`	`56`	Filter by unknown	types/enum.ts:618
`valueBetween`	`57`	Filter by value that is between two values	types/enum.ts:624
`valueEqual`	`58`	Filter by value that is equal to a specific value	types/enum.ts:630
`valueGreaterThan`	`59`	Filter by value that is greater than a specific value	types/enum.ts:636
`valueGreaterThanOrEqual`	`60`	Filter by value that is greater than or equal to a specific value	types/enum.ts:642
`valueLessThan`	`61`	Filter by value that is less than a specific value	types/enum.ts:648
`valueLessThanOrEqual`	`62`	Filter by value that is less than or equal to a specific value	types/enum.ts:654
`valueNotBetween`	`63`	Filter by value that is not between two values	types/enum.ts:660
`valueNotEqual`	`64`	Filter by value that is not equal to a specific value	types/enum.ts:666
`yearToDate`	`65`	Filter by year-to-date	types/enum.ts:672
`yesterday`	`66`	Filter by yesterday	types/enum.ts:678

Pivotviewcellvaluetypeenum Clonelabelfieldtovaluefield