Create custom view, which only shows the Document of a certain Zone - Forum - Rollbase - Progress Community

Create custom view, which only shows the Document of a certain Zone

 Forum

Create custom view, which only shows the Document of a certain Zone

This question is answered

Hi there,

In Rollbase I have done some simple scripting to Show a google maps map, centered to your current location.

The object in which I show this, is called Zone Coordinates, for you can create a zone and enter the Corner coordinates.

So when the google maps map will load, it will plot the zone as a polygon and will show on the map.

Also a marker is placed on your current location and a buttons is added.

This button, when clicked, will set the current user field "Zone" to the name of the zone you currently are in and the field "Zone ID" to that Zone's record ID.

Then in another Object, called PDF.

We can create a new record with a PDF attached and link it to a zone, for example Zone A or Zone B.
You can select the Zones with a Lookup field.

Now I want to accomplish the following.

I want the view of PDFs, to only show the PDFs of my current location.

As you can see, in this case I am currently in Zone A, so i would Like to only see the PDFs linked to Zone A.

Now I see the PDFs of Zone A and Zone B. This is not wanted.

When i go to edit the View or add a filter. I can't seem to filter on the current user's Zone.

I want to filter if the PDF zone coordinate is equal to the Current User's Zone or Zone ID.

so eerr.... HELP!

Verified Answer
  • Filter's table is helpful for basic filter conditions on simple types. As this is more advanced case wherein you want to compare between related record on listview object and current user related record, you should define a 'Formula' filter.

    Please refer this documentation for additional details:

    documentation.progress.com/.../

    Regards,
    Siraj.
All Replies
  • Filter's table is helpful for basic filter conditions on simple types. As this is more advanced case wherein you want to compare between related record on listview object and current user related record, you should define a 'Formula' filter.

    Please refer this documentation for additional details:

    documentation.progress.com/.../

    Regards,
    Siraj.
  • I had tried this with a formula before.

    Tho when referring to a "Lookup Field" you only get the related record's ID, not the name.

    So when I figured that out I could add the Record Id to the current user and now the filters works as intended.

  • A sample formula filter that you can try (missed this as part of my earlier post):

    R111111  IN ({!#CURR_USER.R22222#id} )

    where R111111  say is PDF object lookup field for Zone object

    and R22222 is User object lookup field for Zone object

    Regards,
    Siraj.