Jump to content

Get number of filtered portal rows: How?


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

Recommended Posts

Hi,

 

using a "count of id" summary field in the enclosing layout/table I can get the current total number of rows in the portal based on the portal relationship. But I have three or four filters defined in the portal so that the portal only shows a subset of this total.

 

How can I possibly get the correct number of portal rows that are displayed at any time — outside of the portal on the enclosing layout? Preferably in a global field?

 

I can insert a Record Number Symbol on each portal row that displays the current record number down to the last number. That works fine. But I can't get this value into the enclosing layout/table, whatever means I try.

 

I could probably use a couple of ExecuteSQL queries (one for each case), but because my filters are quite complex these would be also very complex and cumbersome, especially because SQL treats the data a little bit differently than FileMaker (empty fields vs NULL fields, etc.).

 

Any suggestions how to achieve this?

 

Thanks a lot!

 

Gary

 

Link to comment
Share on other sites

How can I possibly get the correct number of portal rows that are displayed at any time — outside of the portal on the enclosing layout?

 

Assuming this is for display only: duplicate your portal, make the duplicate one row tall and place (only) a summary field, defined (in the child table) as Count of [serialID], inside that row.

  • Like 1
Link to comment
Share on other sites

Yes, good idea.

At this time it's only used for display. However, it would be handy to have it in a field.

Thank you very much.

Gary

Link to comment
Share on other sites

However, it would be handy to have it in a field.

 

It is in a field. And if you need to refer to it, you could assign an object name to that field (or, more precisely, to the specific instance of that field). However, this would work only on layout level - same as portal filtering only works only on layout level - so if you need this for data processing, use a filtered relationship instead.

Link to comment
Share on other sites

This topic is 2581 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

  • Similar Content

    • By Sinky
      Hi guys!
      I hope someone can help me with this.
      I have a SUMMARY LIST field which contains types of items eg. (shoes, shoes,  sneakers, boxers, jumpers, boxers, jackets, shoes, sneakers...). These items are also listed in a value list (boxers, jumpers, shoes, jackets, sneakers)
      Is there a way how I can generate a count list of items by and in order of the value list? Taken the example above,  this count list would look like this (2, 1, 3, 1, 2). The commas here should actually be the carriage return.
      Tnx a lot! 
    • By Sinky
      Hi!
      I have a calculation field in a portal which shows the value according to ActivePortalRowNumber. Each row has a special determined value.
      When I manually enter the value in the field before the calculation field and thereby make a particular row active, my calculation field automatically shows the designated value. Great!
      But, if when I do the import from Excel, all data gets nicely imported and the portal shows the imported data but the calculation field is without value. I guess the importing process is not making a portal rows active so the calculation is not working.
      Any ideas how this can be solved?
      Many thanks!
    • By Tony Diaz
      The tables.
      Items::ID
      Items::Item
      Items::Publisher
      Items::Date
       
      The Genre data is already arranged like this:
      Genre::ID (Unique Key)
      Genre::Name
      Genre::Category_ID
      Genre::Category

      The Platform data is 'simple'. ID and Name. But each item could be multiple platforms.  (Example #1 vs. Example #2)
      Platforms::ID
      Platforms::Name
      An item can have multiple Genre Categories related to it, and those usually have a single choice from within their Category, but might have multiples.

      It's supporting the possible multiples that I'm trying to work out. At this point there's 15 possible Genre Categories that each Item could have a selection from. Most have 4-6 of them.

      Example 1: Items::Table on the left, Genre::Table on the right, with some Genre Categories (Genre, Perspective, Pacing, Gameplay, Interface, Setting) and their sub-options.
      This one has just one sub-option per category.

      Example 2:  The Gameplay Genre Category has two sub-options related to it.



      Example Genre Table content:

       
      Just cracking the surface on One to One and One to Many relationships, I don't think this scenario is quite covered this way.

      Would each of those Genre Categories be portals showing only their related category ID?

      I presume that I would add fields to the Items::Table so I can pull related records:
      Items::Platform_IDfk
      Items::Genre_IDfk
      Items::Category_IDfk
      But those only support one relationship.
      Would I make value lists from those Genre Categories and Platforms and set them as tick box fields?
       
    • By stan111
      Gents,
      I use self portal on my Clients layout to serve two things:
      1. display all the records and
      2. quick navigate among them. 
      This portal is not displayed in Webdirect. 
      Is it possible to make it work?
    • By Guy_Smith
      This should be easy, but my brain just won't cooperate!
      I'm moving a bunch of stuff and want to inventory what is in each moving container.  I have a very simple parent-child relationship with the parent record having the container number and category of parts/equipment/supplies and the child records describe each piece of equipment in the container.  I have a portal with the child records showing for each container, but want to put anatto-entered item number for each piece that has the container number followed by a dash and then followed by a serialized number for each item in that particular container.  For example, I would have container 1 labeled "Glassware" and Container 2 labeled "Chemicals".  In Container 1's portal I'd like to see:
      Item    Description          Qty
      1-1      Beakers, 500ml    4
      1-2      Beakers, 250 ml   2
      and in Container 2's portal I'd like to see:
      Item    Description          Qty
      2-1      Potassium           4 g
      2-2      Sodium                26 g
      I'd like to auto-fill the item numbers, but can't figure out how to reset the serialization for each parent record.
      Any help is greatly appreciated.
      Thanks and keep yourselves safe!
       
×
×
  • Create New...

Important Information

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