📥 Export to Excel (CSV) ⚙ Advanced filters

userproperties

14 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: categoryId, userId, userKey, userValue

id ▼ categoryId subCategory1 subCategory2 sysProperty userId userKey userValue
1 4       16 calCategories 1,10,99
2 4       9 calCategories 1,30,31,32,33
3 4       17 calCategories 1,30,31,32,99
4 5       30 purchasing {"currentDateRange":"this-year","previousDateRange":"last-year"}
5 4       31 calCategories 1,20
6 4       46 calCategories 1,10,99
7 5       54 inventory {"currentDateRange":"this-month","previousDateRange":"last-month"}
8 5       9 sales {"currentDateRange":"this-year","previousDateRange":"last-year"}
9 5       9 purchasing {"currentDateRange":"this-year","previousDateRange":"last-year"}
10 5       56 sales {"currentDateRange":"this-year-to-date","previousDateRange":"last-year-to-counterpart-date"}
11 5       56 inventory {"currentDateRange":"this-year","previousDateRange":"last-month"}
12 5       62 inventory {"currentDateRange":"this-year","previousDateRange":"last-year"}
13 4       58 calCategories 1,20,30,31,99
14 5       69 purchasing {"currentDateRange":"this-quarter","previousDateRange":"last-quarter"}

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "userproperties" (
 "id" INTEGERNOT NULL ,
 "categoryId" INTEGERNOT NULL,
 "subCategory1" TEXT DEFAULT NULL,
 "subCategory2" TEXT DEFAULT NULL,
 "sysProperty" TEXT DEFAULT NULL,
 "userId" INTEGERNOT NULL,
 "userKey" TEXT NOT NULL,
 "userValue" TEXT NOT NULL,
 PRIMARY KEY ("id")
);