Skip to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Stop displaying <No Access> records!

calden
in Other Internet Technologies

Featured Replies

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.

  • Author

Better yet is there a way to omit a record from being shown, plus is there a way to impliment this in a link?

  • Author

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."

  • Author

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

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

  • Author

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.

Have you tried CDML and its [FMP-If] tags?

Good Luck.

Garry

does this happen on all records? do you use record-based security mechanisms?

  • Author

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>

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!

You may need to try:

[FMP-Record]

[FMP-if: Project .neq. <No Access>]

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

[/FMP-If]

[/FMP-Record]

All the best.

Garry

  • Author

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.

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 # ..; )?

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...

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

  • Author

Sorry kenneth2k1 I've been away for a while. Yes, I'm using,

  • 1 month later...
  • Newbies

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.

Yes, I'm using,

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

Account

Navigation

Search

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.