Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Get RecordCount for a filter on a query??
Wed, Sep 11 2019 7:54 PMPermanent Link

Ian Branch

Avatar

Hi Team,
I have a browse view based on a Query called JobTickets.
I want to filter the records, no problem there, and be able to indicate to the User how many records are in the Filter.
I tried  Jobtickets.RecordCount but it always returns the full Query qty of records.
I'm sure I'm not the only one who has had this issue/problem.

Advise/suggestions please?

Regards & TIA,
Ian
Thu, Sep 12 2019 4:43 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Ian


I'm not certain I'm interpreting correctly. Are you using a Query or a View?

If you're using a query then I would advise against using a filter - use the WHERE clause that creates the query to start with.then its simply RecordCount. There used to be a property FilterRecordCounts but its been removed.


Roy Lambert
Thu, Sep 12 2019 6:36 AMPermanent Link

Ian Branch

Avatar

Hi Roy,
I suspected as much.
Regards,
Ian
Image