Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

giakoum
Honored Contributor II

How to see bookmark size

Hi.

I have a user that created a huge bookmark (selected 1m customer names) and thus the shared file quadrupled in size. How can I find out which user or which bookmark id this is?

1 Solution

Accepted Solutions
giakoum
Honored Contributor II

Re: How to see bookmark size

This is how it can be done :

CUSTOM CONNECT TO "Provider=QvServerObjectConnector.exe;Folder=<your public data folder>;XUserId=<your user>;XPassword=<your password>;";

Objects:

SQL SELECT

  FileName,

    ID,

    ObjectHidden,

    ObjectLength,

    ObjectTemporary,

    ObjectShared,

    ObjectType,

    ObjectUser

FROM Objects;

ObjectLength is the bookmark size if ObjectType is Bookmark


1 Reply
giakoum
Honored Contributor II

Re: How to see bookmark size

This is how it can be done :

CUSTOM CONNECT TO "Provider=QvServerObjectConnector.exe;Folder=<your public data folder>;XUserId=<your user>;XPassword=<your password>;";

Objects:

SQL SELECT

  FileName,

    ID,

    ObjectHidden,

    ObjectLength,

    ObjectTemporary,

    ObjectShared,

    ObjectType,

    ObjectUser

FROM Objects;

ObjectLength is the bookmark size if ObjectType is Bookmark


Community Browser