Q:
How can I dynamically change select box data based on specific criteria?
A:
If you have played with select boxes in Genie, you should already know that you can attach any of them to an i database file. But if you only want to retrieve the data that belongs to the current user, selected customer, etc.
Genie provides a convenient way to subset the data with its “choices selection criteria” property. This property maps to a WHERE clause in an SQL statement. Sometimes, a simple expression like “COMPANY = 1” is all you need, but often times you want this expression based on some information on the screen. Here is what you can put into the “choices selection criteria” property to implement this:
Script: “COMPANY = “ + get(“D_6_3”)
Here, D_6_3 is the id of the element that contains the company number.
Pretty simple.
Creating Dynamic Select Boxes in Genie
-
- Site Admin
- Posts: 252
- Joined: Fri Dec 14, 2007 1:09 pm
- Contact:
-
- Experienced User
- Posts: 2711
- Joined: Wed Aug 01, 2012 8:58 am
- First Name: Scott
- Last Name: Klement
- Company Name: Profound Logic
- City: Milwaukee
- State / Province: Wisconsin
Re: Creating Dynamic Select Boxes in Genie
This technique changed when enhanced security mode was added. If you are running with enhanced security mode (and you should be, it has been the default since version 4.5, and is important for security purposes) you should use the technique explained at the following link, instead:
http://www.profoundlogic.com/docs/displ ... urity+Mode
http://www.profoundlogic.com/docs/displ ... urity+Mode
Who is online
Users browsing this forum: No registered users and 3 guests