Jump to content

Chris Scalzi

Members
  • Content count

    19
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Chris Scalzi

  • Rank
    member
  • Birthday 10/30/1980

Profile Information

  • Gender
    Male
  • Location
    Queens, NY
  • Interests
    Photography & Technology.

    But mostly coffee. ALL, of the coffee.

    My photography company:
    http://www.distilledminds.com

Contact Methods

  • Website URL
    http://www.datapanda.com
  • Skype
    sethethero

Recent Profile Visitors

2,055 profile views
  1. Chris Scalzi

    Searchable Virtual list

    Sorry, i typed sort by accident , I meant search. I think I've realized that the problem has nothing to do with Virtual Lists and is entirely a question on how to search for data that is within a portal.
  2. Chris Scalzi

    Searchable Virtual list

    There are some great examples in here, and yes they are all searchable. If the data was in a portal the only way I can think of searching it would be to define a portal filter by a variable and then have it sort by that field.
  3. Chris Scalzi

    Searchable Virtual list

    Thanks for this example file Bruce! I must admit I'm still deconstructing it. I notice that you are using field repetitions instead of a variable array, is there a benefit to this method or is this just another way of doing it?
  4. Chris Scalzi

    Searchable Virtual list

    When I wrote "eSQL" I was referring to the ExecuteSQL function which I am using to gather my data for the Virtual List. Thinking about it further the biggest issue I am having is that my Virtual List is within a Portal and I need to be able to search the Portal. I am thinking this is more of a Portal searching issue than a Virtual List issue. Does that make sense?
  5. Chris Scalzi

    Searchable Virtual list

    I'm not sure if this has been answered before but I'm trying to figure out if there is any way of making a virtual list searchable. I can create buttons that will modify the eSQL search and add parameters to the search in a fairly complex way but I'm talking about just hitting the search button and searching within the table. I know that calculation fields cannot be searched, I have also attempted to make a text field with a calculated result with full indexing and it seems to still not be working. Any thoughts?
  6. @BruceR I just referenced this post for a project I'm working on. Great stuff, and thanks!
  7. Chris Scalzi

    Short name or long name?

    If the open script doesn't run on this particular solution more than just the names would get messed up. I have a variety of variables and settings that are grabbed for the database session that are necessary for the core functionality for the solution. The names are in two places: 1. The OS X Open Directory server where you could only log in as Full Name or Short Name. That is secured by physically being locked in a server cabinet, then software locked on the local level and on the OD level for Server Account access. Various groups in the OD are linked to the filemaker pro security groups with limited names for access to different tables. 2. The table of names in filemaker has strict read and modify access. And only super-administrators are able to modify the long name or short name. The thing is though, even if the table of names gets modified it's only really for reference. Access and privileges are always driven by the OS X OD Server and FMP security groups.
  8. Chris Scalzi

    Short name or long name?

    I realize this topic was nearly two years about now but I came accross this problem and at the very least found a solution that I was happy with for consistently reporting what the username was. Since the other way of authenticating was the long name in the Open directory the way to differentiate them was always that one contained a space between the first and last name and the other ( the short name ) had no spaces. So I did indeed "register" each user with my database by way of adding the short name to their individual record within the database and then called it up on the database opening script. The script that only runs when the database is first opened. I also added this script to a function for re-logging in as another user. I did: Set Variable [If ( PatternCount ( Get ( AccountName ) ; " " ) ; Let ( [ User=Get ( AccountName ); Result=ExecuteSQL( " SELECT accountname FROM FacultySPR WHERE EmployeeFullName = ? " ; "" ; "" ; User ) ]; Result ) ; Get ( AccountName ) ) ] And then after that I set another variable: Set Variable [ $$CurrentUser; Value:$$CurrentUserCheck] This way if I ever needed to report the current user I could reliably do so by their short name whether or not they used their full name to log in or not.
  9. Interesting. This sounds like it might be the solution. I will work to implement this and let you know how it goes. Thank you so much for you advice on this!
  10. It is simply easier for the schools administration to keep track of it starting from 1 each year. The numbers would quickly go into the thousands and get annoying to track from them. It's hard to explain because I'd have to go into the lottery process for how children are chosen which is also prioritized by sibling, district, etc. Yes there is another table that contains the lottery info for that year and grade. Example "2014-2015-k" for the kindergarten lottery for this upcoming school year.
  11. I'm not completely certain if this is the right section for this problem / question. I have a situation where I need to make sure that a field in one of my tables has a unique number under certain circumstances. I have student information system which has a lottery module I built so that they can manage student applications for the coming year. Each student once entered into the database is assigned a lottery number and associated with a specific lottery which is associated with the school year and the grade they are applying for. When each student is entered they are given a lottery number, starting at 1. The problem is I need to make sure that that number is not assigned again for the current lottery they are associated with. There may be other students assigned the number 1 (for instance) within that field but they are associated with lottery's of years past, so I cannot simply check the Require Unique Value option. It has to be unique based on the foreign key of the lottery they are associated with. Any suggestions? I really appreciate any insight! ~ Chris
  12. Back from outer space (Florida), and ready to code.

  13. Chris Scalzi

    ExecuteSQL pk grab

    Thanks Dan! I ended up adding your suggestion as well as quoting the values of my variables and double checking my white space. My final code ended up being: Let ( [ x = "1"; y = "2013"; $query = " SELECT "_pkLotteryRecordID" FROM Lottery WHERE LotteryGrade = ? AND LotteryYearOnly = ? "; $result = ExecuteSQL ( $query ; "" ; "" ; x ; y ) ]; $result )
  14. I have a question which might just come down to improper syntax. I'm giving my first attempt at using the ExecuteSQL command and I've gone through some of the primers (specifically the one by Beverly) but I am having trouble with what seems like a basic query. I'm attempting to find the primary key of my record in a table using two fields and their data. Here's what I got: Let ( [ x = 1; y = 2013; $query = " SELECT _pkLotteryRecordID FROM Lottery WHERE LotteryGrade = ? AND LotterYearOnly = ? " ; $result = ExecuteSQL ( "$query"; "" ; "" ; x ; y ) ]; $result )
  15. This place rocks, so glad I found it!

×

Important Information

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