Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook

Announcement

Collapse

The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic


Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.


If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.


Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.



Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

Help with field rule Lookup filter?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Help with field rule Lookup filter?

    The following list is from a file of over 5000 product records. When creating an invoice, I need to do a lookup to find all records that contain "madrid" and "oak". As you can see the data is not all in the same order. Unfortunately, this is how the data is supplied to the retailer from the manufacturer.
    Code:
    78X24 OAK MADRID 2 PANEL PFIN                     
    78X27 OAK MADRID 2 PANEL PFIN                     
    78X30 OAK MADRID 2 PANEL PFIN                     
    80X32 OAK MADRID 2 PANEL PFIN                     
    78X33 OAK MADRID 2 PANEL PFIN                     
    2040X626X40MM MADRID OAK 2 PANEL PRE FINISHED     
    2040X726X40MM MADRID OAK 2 PANEL PRE FINISHED     
    2040X826X40MM MADRID OAK 2 PANEL PRE FINISHED     
    78X24 OAK MADRID 2 PANEL PFIN FIRECHECK           
    78X27 OAK MADRID 2 PANEL PFIN FIRECHECK           
    78X30 OAK MADRID 2 PANEL PFIN FIRECHECK           
    78X33 OAK MADRID 2 PANEL PFIN FIRECHECK           
    2040X726X44MM MADRID OAK 2P FIRECHECK P/FIN       
    2040X826X44MM MADRID OAK 2P FIRECHECK P/FIN
    Advice please as how best to filter the lookup in field rules.
    Regards
    Keith Hubert
    Alpha Guild Member
    London.
    KHDB Management Systems
    Skype = keith.hubert


    For your day-to-day Needs, you Need an Alpha Database!

    #2
    Re: Help with field rule Lookup filter?

    So you have imported this data into a table? Actually after re-reading this, you have built a list from the records that are already in a table...

    Field is part_name.

    Then a filter can be:

    "oak"$part_name .and. "madrid"$part_name

    I sense there is more to this story.
    Last edited by Al Buchholz; 02-08-2015, 05:07 PM.
    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.
    "Make it as simple as possible, but not simpler."
    Albert Einstein

    http://www.iadn.com/images/media/iadn_member.png

    Comment


      #3
      Re: Help with field rule Lookup filter?

      I use filter_string_smatch() as a mainstay, goto function. You can run the follwing in IW as an example. I'm not sure what the speed would be like with 5000 records, except I know from a speed test Ira ran a few years ago, it came out on top of all list filtering methods as the fastest.

      Code:
      dim vL0 as C
      for i = 1 to 10
      	vL0=vL0+"SOMETHING NOT HAVING THE WORDS 00"+i+crlf()
      next
      
      dim vL as C
      vL=<<%l%
      78X24 OAK MADRID 2 PANEL PFIN                     
      78X27 OAK MADRID 2 PANEL PFIN                     
      78X30 OAK MADRID 2 PANEL PFIN                     
      80X32 OAK MADRID 2 PANEL PFIN                     
      78X33 OAK MADRID 2 PANEL PFIN                     
      2040X626X40MM MADRID OAK 2 PANEL PRE FINISHED     
      2040X726X40MM MADRID OAK 2 PANEL PRE FINISHED     
      2040X826X40MM MADRID OAK 2 PANEL PRE FINISHED     
      78X24 OAK MADRID 2 PANEL PFIN FIRECHECK           
      78X27 OAK MADRID 2 PANEL PFIN FIRECHECK           
      78X30 OAK MADRID 2 PANEL PFIN FIRECHECK           
      78X33 OAK MADRID 2 PANEL PFIN FIRECHECK           
      2040X726X44MM MADRID OAK 2P FIRECHECK P/FIN       
      2040X826X44MM MADRID OAK 2P FIRECHECK P/FIN
      %l%
      
      vL=vL+vL0
      msgbox(vL)
      
      dim vLfind as C
      vLfind=filter_string_smatch(vL,"*madrid*",crlf())
      vLfind=vLfind+crlf()+filter_string_smatch(vL,"*oak*",crlf())
      vLfind=word_unique(vLfind,crlf())
      
      dim vR as C
      vR=ui_dlg_box("Found",<<%dlg%
      {lf};
      [.70,16vpick^#vLfind];
      {lf};
      <Close>
      %dlg%)
      Mike W
      __________________________
      "I rebel in at least small things to express to the world that I have not completely surrendered"

      Comment


        #4
        Re: Help with field rule Lookup filter?

        Hi Guys,

        Thanks for replies.

        Will try Al's syntax first.

        Mike, not sure how to use your code in Field Rules lookup?
        Regards
        Keith Hubert
        Alpha Guild Member
        London.
        KHDB Management Systems
        Skype = keith.hubert


        For your day-to-day Needs, you Need an Alpha Database!

        Comment


          #5
          Re: Help with field rule Lookup filter?

          filter_string_smatch(part_name,"*madrid*",crlf())+crlf()+ filter_string_smatch(part_name,"*oak*",crlf())>""
          There can be only one.

          Comment


            #6
            Re: Help with field rule Lookup filter?

            Performance is definitely important.

            Keith - what have you found with both expressions?
            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.
            "Make it as simple as possible, but not simpler."
            Albert Einstein

            http://www.iadn.com/images/media/iadn_member.png

            Comment


              #7
              Re: Help with field rule Lookup filter?

              Hi Stan,

              That looks very interesting. I would like to give it a try with variables. What do I need to change for Madrid= var->v_lookup and Oak= var->vc_finish ?

              I'm thinking s_quote(var->vc_finish). What do you think?
              Last edited by Keith Hubert; 02-07-2015, 07:31 PM. Reason: correction of typo
              Regards
              Keith Hubert
              Alpha Guild Member
              London.
              KHDB Management Systems
              Skype = keith.hubert


              For your day-to-day Needs, you Need an Alpha Database!

              Comment


                #8
                Re: Help with field rule Lookup filter?

                No. You have to add the asterisks. Tableting at the moment, will post later.

                Probably "*"+var->vc_finish+"*".

                Tested, that should work.
                Last edited by Stan Mathews; 02-07-2015, 09:40 PM.
                There can be only one.

                Comment


                  #9
                  Re: Help with field rule Lookup filter?

                  Hi Stan,

                  Many thanks for extra syntax. Unfortunately I could not get this to work as desired. The lookup list filtered only on vc_lookup and ignored the vc_finish.

                  I got the right result with
                  Code:
                  Product_Category_Id=Var->vc_cat_id.AND.alltrim(Var->vc_lookup)$description.AND.Alltrim(Var->vc_finish)$description
                  Regards
                  Keith Hubert
                  Alpha Guild Member
                  London.
                  KHDB Management Systems
                  Skype = keith.hubert


                  For your day-to-day Needs, you Need an Alpha Database!

                  Comment


                    #10
                    Re: Help with field rule Lookup filter?

                    Yes, probably should be

                    filter_string_smatch(part_name,"*madrid*",crlf())>"" .and. filter_string_smatch(part_name,"*oak*",crlf())>""
                    There can be only one.

                    Comment


                      #11
                      Re: Help with field rule Lookup filter?

                      Originally posted by Stan Mathews View Post
                      Yes, probably should be

                      filter_string_smatch(part_name,"*madrid*",crlf())>"" .and. filter_string_smatch(part_name,"*oak*",crlf())>""
                      Stan

                      I worked up an example system and used both coding styles. Both worked and provided about the same good response time.

                      I generated over 6000 records in the table and was surprised the the response was more that quick enough. Less than a full second.

                      I haven't heard anymore from Keith. Hopefully he's sailing on to other issues.
                      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.
                      "Make it as simple as possible, but not simpler."
                      Albert Einstein

                      http://www.iadn.com/images/media/iadn_member.png

                      Comment


                        #12
                        Re: Help with field rule Lookup filter?

                        Glad to hear it. I don't know how I arrived at that first expression just using the plus sign. Obviously wasn't thinking clearly. That would be satisfied if either of the variables was found in the field value, not both.
                        There can be only one.

                        Comment


                          #13
                          Re: Help with field rule Lookup filter?

                          Originally posted by Stan Mathews View Post
                          Glad to hear it. I don't know how I arrived at that first expression just using the plus sign. Obviously wasn't thinking clearly. That would be satisfied if either of the variables was found in the field value, not both.
                          My field and variable names are different. For my example this worked:

                          filter_string_smatch(Field_2,"*"+Var->vgChoice1-"*",crlf())>"" .and. filter_string_smatch(Field_2,"*"+Var->vgChoice2-"*",crlf())>""
                          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.
                          "Make it as simple as possible, but not simpler."
                          Albert Einstein

                          http://www.iadn.com/images/media/iadn_member.png

                          Comment

                          Working...
                          X