Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

Stop displaying <No Access> records!

calden

By calden
in Other Internet Technologies

 Share

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

Recommended Posts

calden Apprentice

calden

Posted
Posted

This is driving me crazy, It's great that a user can't see someone elses records however it's no so good that their valuable screen space is taken up by <No Access> messages. How can I suppress these records. Thanks in advanced.

calden Apprentice

calden

Posted
  • Author
Posted

This is what's happening;

"When users access your database over the Web, they'll only be permitted to browse, edit, and delete the records to which their password gives them access. In Instant Web Publishing, when a user doesn't have browse access to a particular record, the record will be shown, but <No Access> will be placed in all fields. If a user doesn't have delete or edit record privileges, those commands will be removed from the navigation bar."

calden Apprentice

calden

Posted
  • Author
Posted

Sorry about his post, probably a real newbie question but I'm stuck. I know how to use "-op" with the usage "neq" however how can I impliment it with the following link;

FMPro?-db=StaffQueue.fp5&-Lay=Main Fields&-format=mainpage.html&-Op=neq&" MISSING PART"&isActive=1&-SortField=Dept&-SortOrder=ascend&-SortField=[FMP-ClientUserName]&-SortOrder=ascend&-SortField=PriorityNum&-SortOrder=descend&-Max=50&-FindAll

Why does FM even display this, "<No Access>", when you can't see a record doesn't that also mean, <No Access>!

Thanks

Leb i Sol Mentor

Leb i Sol

Posted
Posted

long shot but worth looking into:

maybe that field in question as you say set as "no access"...is restriced by web security DB.

look for:

Field Restrictions in WebSecuirty.fp5...."Don't Search and Don't Show" particualr field.....

good luck

calden Apprentice

calden

Posted
  • Author
Posted

Thankyou for your post, however I don't believe this to be the case since I am not using the Web Security DB. I think this is a problem with FM in general. I don't think the original programmers could figure how to suppress these records so they came up with a shortcut. I need a local solution like Java or PHP. Is there anyone who could recommend a good starting point as I need this for a production DB.

calden Apprentice

calden

Posted
  • Author
Posted

cjaegar, I'm using per record security as described in the Web Security PDF. garrycl mentioned the possibilty of using [FMP-if] but I'm having a tuff time. This isn't working right----->

[FMP-Record]

[FMP-if: field:Project .neq. No Access]

******fields*******

[/FMP-If]

[/FMP-Record]

<TABLE WIDTH="905" BORDER="1" CELLPADDING="0" CELLSPACING="0" BORDERCOLOR="#666699" BACKGROUND="images/back.gif" BGCOLOR="#000000">

<TR BORDERCOLOR="#666699" BGCOLOR="#666699">

<TD WIDTH="70">

<DIV ALIGN="center"><FONT COLOR="#FFFFFF" SIZE="-1" FACE="Arial, Helvetica, sans-serif"><STRONG>Record</STRONG></FONT></DIV>

</TD>

<TD WIDTH="249" HEIGHT="17">

<DIV ALIGN="center"><FONT COLOR="#FFFFFF" SIZE="-1" FACE="Arial, Helvetica, sans-serif"><STRONG>Who</STRONG></FONT></DIV>

</TD>

<TD WIDTH="224">

<DIV ALIGN="center"><FONT COLOR="#FFFFFF" SIZE="-1" FACE="Arial, Helvetica, sans-serif"><STRONG>Project</STRONG></FONT></DIV>

</TD>

<TD WIDTH="216">

<DIV ALIGN="center"><FONT COLOR="#FFFFFF" SIZE="-1" FACE="Arial, Helvetica, sans-serif"><STRONG>Description</STRONG></FONT></DIV>

</TD>

<TD WIDTH="216">

<DIV ALIGN="center"><FONT COLOR="#FFFFFF" SIZE="-1" FACE="Arial, Helvetica, sans-serif"><STRONG>Progress</STRONG></FONT></DIV>

</TD>

<TD WIDTH="216"><CENTER>

<B><FONT COLOR="#FFFFFF" SIZE="-1" FACE="Arial, Helvetica, sans-serif">NextSteps</FONT></B>

</CENTER>

</TD>

<TD WIDTH="394">

<DIV ALIGN="center"><FONT COLOR="#FFFFFF" SIZE="-1" FACE="Arial, Helvetica, sans-serif"><STRONG>State</STRONG></FONT></DIV>

</TD>

</TR>

<TR BORDERCOLOR="#666699" BGCOLOR="#666699">

<TD WIDTH="70" HEIGHT="1%"><DIV ALIGN="LEFT"><FONT COLOR="#FFFFFF" SIZE="1%" FACE="Arial, Helvetica, sans-serif"> [FMP-record][FMP-if: field:Project .neq. No Access]</FONT> </DIV>

</TD>

<TD WIDTH="249"><DIV ALIGN="LEFT"><FONT COLOR="#FFFFFF" SIZE="-7" FACE="Arial, Helvetica, sans-serif"></FONT></DIV>

</TD>

<TD WIDTH="224"><DIV ALIGN="LEFT"><FONT COLOR="#FFFFFF" SIZE="-7" FACE="Arial, Helvetica, sans-serif"></FONT></DIV>

</TD>

<TD WIDTH="216"><DIV ALIGN="LEFT"><FONT COLOR="#FFFFFF" SIZE="-7" FACE="Arial, Helvetica, sans-serif"></FONT></DIV>

</TD>

<TD WIDTH="216"><DIV ALIGN="LEFT"><FONT COLOR="#FFFFFF" SIZE="-7" FACE="Arial, Helvetica, sans-serif"></FONT></DIV>

</TD>

<TD WIDTH="216" BGCOLOR="#666699"></TD>

<TD WIDTH="394"><DIV ALIGN="LEFT"><FONT COLOR="#FFFFFF" SIZE="-7" FACE="Arial, Helvetica, sans-serif"></FONT></DIV>

</TD>

</TR>

<FORM ACTION="FMPro" METHOD="post">

<INPUT TYPE="hidden" NAME="-DB" VALUE="staffqueue.fp5">

<INPUT TYPE="hidden" NAME="-recid" VALUE="[FMP-currentrecid]">

<INPUT TYPE="hidden" NAME="-LAY" VALUE="All Fields">

<input type="hidden" name="-Error" value="failure.html">

<INPUT TYPE="hidden" NAME="-FORMAT" VALUE="completed.html">

<input type="hidden" name="-op" value="neq">

<input type="hidden" name="Project" value="<No Access>">

<TR VALIGN="MIDDLE" BORDERCOLOR="#666699">

<TD WIDTH="70" HEIGHT="1%" ROWSPAN="2" ALIGN="CENTER" BACKGROUND="images/back.gif">

<P ALIGN="CENTER"><FONT COLOR="#000000" SIZE="-1" FACE="Arial, Helvetica, sans-serif"> <FONT COLOR="#0000FF">[FMP-field:

RecNum]</FONT> </FONT></P>

<P ALIGN="CENTER"><FONT COLOR="#000000" SIZE="-1" FACE="Arial, Helvetica, sans-serif"><A HREF="[FMP-linkrecid: layout=Main Fields, format=Detail.html]" TARGET="_blank">

<input type="submit" name="-delete" value=" Delete " onClick="return confirm('Are you sure you want to delete this record?')">

</A></FONT></P></TD>

<TD WIDTH="249" ALIGN="CENTER" VALIGN="MIDDLE" BACKGROUND="images/back.gif">

<CENTER>

<P><FONT COLOR="#000000" SIZE="-1" FACE="Arial, Helvetica, sans-serif">

<SELECT NAME ="Who">

<OPTION VALUE=""> [FMP-Option: Who, list=username]

</SELECT>

</FONT></P>

</CENTER>

</TD>

<TD WIDTH="224" HEIGHT="44" ALIGN="CENTER" VALIGN="TOP" BACKGROUND="images/back.gif">

<CENTER>

<FONT COLOR="#000000" SIZE="-1" FACE="Arial, Helvetica, sans-serif">

<TEXTAREA NAME="Project" COLS="25" ROWS="3">[FMP-field:Project]</TEXTAREA>

</FONT>

</CENTER>

</TD>

<TD WIDTH="216" ROWSPAN="2" BACKGROUND="images/back.gif">

<DIV ALIGN="LEFT"><FONT COLOR="#000000" SIZE="-1" FACE="Arial, Helvetica, sans-serif">

<TEXTAREA NAME="Description" COLS="25" ROWS="5">[FMP-field: Description]</TEXTAREA>

</FONT></DIV>

</TD>

<TD WIDTH="216" ROWSPAN="2" BACKGROUND="images/back.gif">

<DIV ALIGN="LEFT"><FONT COLOR="#000000" SIZE="-1" FACE="Arial, Helvetica, sans-serif">

<TEXTAREA NAME="Progress" COLS="25" ROWS="5">[FMP-field: Progress]</TEXTAREA>

</FONT></DIV>

</TD>

<TD WIDTH="216" ROWSPAN="2" BACKGROUND="images/back.gif" BGCOLOR="#666699"><FONT COLOR="#000000" SIZE="-1" FACE="Arial, Helvetica, sans-serif">

<TEXTAREA NAME="NextSteps" COLS="25" ROWS="5">[FMP-field: NextSteps]</TEXTAREA>

</FONT></TD>

<TD WIDTH="394" ROWSPAN="2" VALIGN="MIDDLE" BACKGROUND="images/back.gif">

<CENTER>

<P><FONT COLOR="#000000" SIZE="-1" FACE="Arial, Helvetica, sans-serif">

<SELECT NAME="State">

<OPTION VALUE="[FMP-field: State]" SELECTED> [FMP-Option: State, list=Status]

</SELECT>

</FONT></P>

<P><FONT COLOR="#000000" SIZE="-1" FACE="Arial, Helvetica, sans-serif"><A HREF="[FMP-linkrecid: layout=Main Fields, format=Detail.html]" TARGET="_blank">

<INPUT TYPE="submit" NAME="-edit" VALUE=" Update ">

</A> </FONT> </P>

</CENTER>

</TD>

</TR>

<TR VALIGN="MIDDLE" BORDERCOLOR="#666699">

<TD WIDTH="249" ALIGN="CENTER" VALIGN="MIDDLE" BORDERCOLOR="#666699" BACKGROUND="images/back.gif"><CENTER>

<FONT COLOR="#3333FF" SIZE="-1" FACE="Arial, Helvetica, sans-serif">[FMP-field:

Dept]</FONT>

</CENTER>

</TD>

<TD HEIGHT="29" ALIGN="CENTER" VALIGN="MIDDLE" BGCOLOR="[FMP-field: FGcolor]"><CENTER>

<FONT COLOR="[FMP-field: FGcolor]" SIZE="-1" FACE="Arial, Helvetica, sans-serif">

<SELECT NAME="Priority">

<OPTION VALUE="[FMP-field: Priority]" SELECTED> [FMP-Option: Priority,

list=Priority]

</SELECT>

</FONT>

</CENTER>

</TD>

</TR>

</form>

<TR BORDERCOLOR="#666699" BGCOLOR="#666699">

<TD WIDTH="70" HEIGHT="1%"><DIV ALIGN="LEFT"><FONT COLOR="#FFFFFF" SIZE="1%" FACE="Arial, Helvetica, sans-serif">[/FMP-If][/FMP-record] </FONT></DIV>

</TD>

<TD WIDTH="249"><DIV ALIGN="LEFT"><FONT COLOR="#FFFFFF" SIZE="-7" FACE="Arial, Helvetica, sans-serif"></FONT></DIV>

</TD>

<TD WIDTH="224"><DIV ALIGN="LEFT"><FONT COLOR="#FFFFFF" SIZE="-7" FACE="Arial, Helvetica, sans-serif"></FONT></DIV>

</TD>

<TD WIDTH="216"><DIV ALIGN="LEFT"><FONT COLOR="#FFFFFF" SIZE="-7" FACE="Arial, Helvetica, sans-serif"></FONT></DIV>

</TD>

<TD WIDTH="216"><DIV ALIGN="LEFT"><FONT COLOR="#FFFFFF" SIZE="-7" FACE="Arial, Helvetica, sans-serif"></FONT></DIV>

</TD>

<TD WIDTH="216" BGCOLOR="#666699"></TD>

<TD WIDTH="394"><DIV ALIGN="LEFT"><FONT COLOR="#FFFFFF" SIZE="-7" FACE="Arial, Helvetica, sans-serif"></FONT></DIV>

</TD>

</TR>

</TABLE>

cjaeger Experienced

cjaeger

Posted
Posted

oops, record based security, while one of my favorites, does not really work with instant web publishing. no idea here as i work primarily with xml.

problem is, you cannot find (and therefore omit) records on which you have no access.

Try moving the sensitive data to another (related) file and show it in a portal.

Good luck!

calden Apprentice

calden

Posted
  • Author
Posted

Thankyou garrycl for replying, this is what I did first but as you know "<" and ">" are html tags and cannot be used in this context.

cjaeger Experienced

cjaeger

Posted
Posted

Thankyou garrycl for replying, this is what I did first but as you know "<" and ">" are html tags and cannot be used in this context.

have you tried &lt; or & gt; instead (or their corresponding hex representaion # ..; )?

Garry Claridge Grand Master

Garry Claridge

Posted
Posted

Using "<" and ">" should be OK, because it is WebCompanion processing them before they are sent to the browser.

You could try:

[FMP-Record]

[FMP-if: Project .ncn. No Access]

******fields*******

[/FMP-If]

[/FMP-Record]

.ncn. is "Does not contain".

All the best.

Garry

  • 3 weeks later...
kenneth2k1 Mentor

kenneth2k1

Posted
Posted

Hey guys:

Calden, are you using Instant Web Publishing? And if so, where did you put those cdml tags to try and make it work? I'm wondering because I am in the same situation and didn't think that cdml tags would work with IWP.

Thanks

Ken

  • 1 month later...
  • Newbies
s_t_e_v_e Newbie

s_t_e_v_e

Posted
  • Newbies
Posted

I don't know if you got an answer to this, but I have a very easy way of suppressing display of these records. I perform a find * on a group name field that contains the value of status(currentgroups). If you aren't implementing groups like this, perhaps you can perform a find * on some other field. You will still have the weird effect of having a large number of total records with a small number of found records.

This topic is 7849 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
 Share
Go to topic listing
×
×
  • Create New...

Important Information

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

  I accept