DataPage filter logic

[Sam23]

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

 

[kpcollier]

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