Jump to content
  • 0

DataPage filter logic


Sam23
 Share

Question

I need  to pass into a datapage whether I want a private list (pv=1) or not (pv=0)

If pv=1, I need to filter by author

If pv=0, show all records

Is it possible to use if-then logic with a datapage filter? I am stuck

Thanks, Sam

 

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

This should be possible, but you might need to use a Search Form with auto-submit. What kind of datapage is receiving the parameter? Is the 'filter by author' part supposed to be so only the author can see their own records, and do they log in via an Author_Table or some sorts from your database?

 

I'm thinking you can receive the parameter in a virtual field on your search form. Then, include the Author field and create a 2nd criteria for it.

The first criteria will be used for the 'Filter by author' or 'pv=1' case. Set this to a dropdown element with a lookup table to your Author_Table. Then, go to the Security tab and click on the 'Limit lookup values based on user identity'. This will make it so the author can only see their work.

Then for the second criteria, set it to a dropdown element with just a blank custom value. On the Advanced tab, select 'match all when blank'.

Then in Rules, you can set 'If Virtual Field = 1, disable Criteria 2' and 'If Virtual Field = 0, disable Criteria 1'

After that is all done, you can  just throw in the Auto-Submit script

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...