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

Complex filter of dropdown list

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

    Complex filter of dropdown list

    I have a dropdown control which shows all personnel names. The problem is the list is becoming very long and shows personnel who no longer are employed here. I can filter the dropdown to show only current personnel but then the older records does not show a name at all since the filter is filtering them out.

    is there a way to filter the dropdown and still maintain the historic data?
    J.R.
    Epigate Software, LLC.

    [email protected]
    http://www.epigate.com
    sigpic

    #2
    Re: Complex filter of dropdown list

    I do not understand why we continue to have so many questions about filtered dropdowns. I will refer you to the method I give in this thread:

    http://msgboard.alphasoftware.com/al...tered+dropdown

    Sorry, cranky at the end of a long week maybe.
    -Steve
    sigpic

    Comment


      #3
      Re: Complex filter of dropdown list

      Steve, i have spent a couple of days on this and searched the message board but did not find anything that i recognized as a solution to my issue. Even your link does not work for me, unless i just do not understand it, and that does have a high probability. I may not have explained it very well, and i was confused on your link you sent. If it is what i am needing, then i just dont understand it. I'm still pretty new Steve.

      I have a dropdown that contains personnel names. I filter it so it only shows current personnel, and that works fine. But the problem is when an employee resigns that has a record in the database, then that record will show a blank instead of their name, because of the filter on the dropdown. I want it to still show their name in the dropdown for all the historic records, but if the dropdown is selected it will show only current personnel.

      These show how the name is blank once "Diane" is changed to former employee status.

      filter1.jpgfilter2.jpg

      I may be asking for my cake and eat it too, it may not be doable, but i'm sure someone has a solution or a workaround.

      And Steve, i hope they never make our week in Kentucky as long as your week in West Virginia. No sense in all of us being cranky. lol
      J.R.
      Epigate Software, LLC.

      [email protected]
      http://www.epigate.com
      sigpic

      Comment


        #4
        Re: Complex filter of dropdown list

        J.R. -

        It would appear to me that is more the data than the method to "filter" it :)

        For those that have resigned, either:

        - go and set their "position" to "Caregiver - Secondary - Resigned"
        - the more appropriate method: a new field called "Status" with the choices of (for example): Full Time, Part Time, Casual, Resigned, Terminated, etc.

        This is how I have done it for one of my apps:

        status_dropdown.png

        Note that Department - Group - Role are linked via the "Cascading" property in the DD choices setup; this works do slick! :)

        Easy!

        Cheers!
        Lyle
        Cheers!
        Lyle Chamney
        http://www.2ninerniner2.com/
        Websites rebuilt with WordPress
        http://goodcheapfastwebsites.com/
        Complete, ready to install WordPress websites
        http://snifflevalve.com
        WordPress training and tutorials

        Comment


          #5
          Re: Complex filter of dropdown list

          The caregiver section has nothing to do with it, i should have cropped that out. The images was only to show the missing name.
          There is a field in the personnel table which is called "Status" and it is either "Current Employee" or "Former Employee". That is what filters the dropdown.

          Filtering the dropdown is not the issue.
          J.R.
          Epigate Software, LLC.

          [email protected]
          http://www.epigate.com
          sigpic

          Comment


            #6
            Re: Complex filter of dropdown list

            Well, I guess I am just confused on what it is that you want then

            From what I gather, you want all the employees listed in the Employee DD regardless of their Status, yet you filter on the Status. I guess I just don't get it :)
            Cheers!
            Lyle Chamney
            http://www.2ninerniner2.com/
            Websites rebuilt with WordPress
            http://goodcheapfastwebsites.com/
            Complete, ready to install WordPress websites
            http://snifflevalve.com
            WordPress training and tutorials

            Comment


              #7
              Re: Complex filter of dropdown list

              Is this what you are trying to accomplish?

              You want the list of current employees for new records, but you want to include non-active employees when editing existing records.

              Can you filter to all active employees in the dropdown and set the flag to 'add if not found'? (sorry not at the computer, so guessing at the property)

              On the canInsert event, check if you are editing a record, and allow the employee code to be the same as the old value or a new active employee. Return an error to stop the insert.

              On the add, validate for active employees only.

              Another option I'd to disable the employee field on an edit - but not sure if this is viable for your situation.

              Thanks,

              Earl Allin
              REA Inc
              Earl Allin
              REAInc.net

              We can help you with mentoring and custom programming services in Alpha, .NET, React, PHP, ColdFusion, and more..

              Comment


                #8
                Re: Complex filter of dropdown list

                One other option for the 'add if not found' is to create a function (if you're db is MySQL or MSSQL) to return the employee codes that are valid + the current record employee code.

                Your dropdown would use these values - so the 'add if not found' flag wouldn't be necessary, and (I think) the edit-combo wouldn't be required.

                Thanks,

                Earl
                Earl Allin
                REAInc.net

                We can help you with mentoring and custom programming services in Alpha, .NET, React, PHP, ColdFusion, and more..

                Comment


                  #9
                  Re: Complex filter of dropdown list

                  Thanks Lyle, it is hard to explain what i am trying to do, and it may not even be doable in Alpha. I did it in another application by setting a dropdown to show only active employees, but this dropdown was only wide enough to show just the dropdown arrow, but when it was selected it would be wide enough to show all the names. There was another field which was visible and was close enough to the filtered dropdown that it looked like it actually was the dropdown, but this control had no filter so all the records would show.

                  When the dropdown was selected, the filtered dropdown would open and show only the current personnel. but as you navigated through the records, the other, non-filtered control would show all the personnel, whether they were current or former personnel.


                  This is so confusing, i confuse myself trying to explain it.

                  Robert, i will try your suggestions. Thanks.
                  J.R.
                  Epigate Software, LLC.

                  [email protected]
                  http://www.epigate.com
                  sigpic

                  Comment


                    #10
                    Re: Complex filter of dropdown list

                    Why not just sort it so that the Active appear at the top of the list and the inactive are at the bottom.

                    Comment


                      #11
                      Re: Complex filter of dropdown list

                      LOL, Never dawned on me to do that Lee. That will do exactly what i need to do. I would say I can't believe i didn't think of that, but i would be lying...i can believe it.
                      Thank you Lee.
                      J.R.
                      Epigate Software, LLC.

                      [email protected]
                      http://www.epigate.com
                      sigpic

                      Comment


                        #12
                        Re: Complex filter of dropdown list

                        JR - you could always add a looking-glass icon button next to the filtered drop-down which would pop up an unfiltered lookup which, when selected, could add a new choice to the dropdown list and select that choice. You may need a touch of javascript, however.

                        Comment


                          #13
                          Re: Complex filter of dropdown list

                          Lee and J.R. - NOW I get it!
                          Cheers!
                          Lyle Chamney
                          http://www.2ninerniner2.com/
                          Websites rebuilt with WordPress
                          http://goodcheapfastwebsites.com/
                          Complete, ready to install WordPress websites
                          http://snifflevalve.com
                          WordPress training and tutorials

                          Comment

                          Working...
                          X