Alpha Video Training
Results 1 to 4 of 4

Thread: Two filters in table.external_record_content_get

  1. #1
    Member
    Real Name
    Denis Ahmet
    Join Date
    Jul 2005
    Location
    United Kingdom
    Posts
    988

    Default Two filters in table.external_record_content_get

    Hi.

    I want to filter this by two variables

    1. "model_id="+quote("00283")
    2. "unavailable_date>=date()"

    What syntax do i need to use to add item 2 above to the filter?

    myvar=table.external_record_content_get("[PathAlias.ADB_Path]\tbl_unavailable_dates","(unavailable_date)","unavailable_date","model_id="+quote("00283"))

    Thanks in advance.

    Denis

  2. #2
    "Certified" Alphaholic
    Real Name
    John Koh
    Join Date
    Jan 2004
    Location
    Maryland, USA
    Posts
    1,081

    Default Re: Two filters in table.external_record_content_get

    Denis

    vDynamic_model_id ="00283"
    vfilter = "("model_id="+quote( vDynamic_model_id ) +" ) .and. ( "unavailable_date>="+s_quote( date() ) +" )"

    myvar=table.external_record_content_get("[PathAlias.ADB_Path]\tbl_unavailable_dates","(unavailable_date)","unavailable_date", vfilter )

  3. #3
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,625

    Default Re: Two filters in table.external_record_content_get

    Code:
    vDynamic_model_id ="00283"
    vfilter = "(model_id="+quote( vDynamic_model_id ) +" ) .and. ( unavailable_date>="+s_quote( date() ) +" )"
    
    ?vfilter
    Use this in the interactive window

    ?vfilter shows what is stored in the vfilter variable.

    Modify the vfilter definition until you get something that looks correct and works.
    I got this...

    = (model_id="00283" ) .and. ( unavailable_date>={12/18/2018} )


    Then use Jon's last line.
    myvar=table.external_record_content_get("[PathAlias.ADB_Path]\tbl_unavailable_dates","(unavailable_date)","unavailable_date", vfilter )
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  4. #4
    Member
    Real Name
    Denis Ahmet
    Join Date
    Jul 2005
    Location
    United Kingdom
    Posts
    988

    Default Re: Two filters in table.external_record_content_get

    Perfect. Thanks Al.

Similar Threads

  1. table.external_record_content_get ~ for sql
    By Dan Blank in forum Application Server Version 11 - Web/Browser Applications
    Replies: 5
    Last Post: 11-09-2013, 11:14 PM
  2. Table.external_record_content_get()
    By netgeorger in forum Alpha Five Version 10 - Desktop Applications
    Replies: 6
    Last Post: 04-08-2011, 02:51 PM
  3. using var in table.external_record_content_get
    By Steve Wood in forum Alpha Five Version 10 - Desktop Applications
    Replies: 8
    Last Post: 03-14-2010, 03:27 PM
  4. Table.external_record_content_get()
    By MikeC in forum Archived Wishlist
    Replies: 0
    Last Post: 02-10-2010, 10:55 AM
  5. table.external_record_content_get
    By Blake in forum Alpha Five Version 5
    Replies: 5
    Last Post: 08-18-2003, 06:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •