Jump to content
Server Maintenance This Week. ×

PHP Find returning all records - even those not allowed in privilege set


This topic is 4362 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a simple FM11 database of inventory. I have set the Privilege Set's (File>Security>Privilege Set) Custom Records Privileges "View" "Limited" to the calculation "On Web = 1" (without quotes) - where "On Web" is the checkbox field that has the boolean of 1 or 0.

So, if the record has "On Web" checked, the record shows up on the website. All this is working fine, as long as the person enters a variable in the find, but if they just click "Find Records", all the records in the database show up. Here's the kicker - all the records that are are not "On Web" are there, it is just that their contents are blank - so, FM is being literally correct, they are not allowed to "view" the record, but it still includes it in the result - albeit, in a blank row.

How can I get FM to not include these records? The site is at:

http://mobayen.macusa.net/findrecords.php

I hope I am being clear here - only took me 30 minutes to write the two paragraphs above...

I am not a php coder (sorry) - this just may be a bug? Or does something in my method look suspicious?

Thanks for any help

-- Don

Link to comment
Share on other sites

Can't tell much without looking at the php code (which we can't see by viewing the site), but it seems like something like:

foreach($records as $record){

	 $checkweb =  $record->getField('On Web');

	 if($checkweb == 1){

		  // your line item display code here;

	 }

}

ought to work.

Link to comment
Share on other sites

You really don't need Custom Privilege's to do this.

just adding a criteria that any search also includes 'On Web == 1' in it will do the same thing... As per doughemi, without php code it's hard to say exactly how to implement this.

Link to comment
Share on other sites

This topic is 4362 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.