The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
Parameter like
I know you can add discrete values in a parameter llike London
I would like to have a flexible parameter like London% where the user can state London in the paramenter and it will find all values stating with London
Can this be done and if so how
Gordon
I would like to have a flexible parameter like London% where the user can state London in the paramenter and it will find all values stating with London
Can this be done and if so how
Gordon
Asked:
-
4
2-
2
2 Solutions
Hi
I would like to give the users a list to select from
ie
Selsey
Runcton
Fruit
When they select Selsey (for example) I want information returned for Selsey and Selsey Leaf
Hope this makes sense
Gordon
I would like to give the users a list to select from
ie
Selsey
Runcton
Fruit
When they select Selsey (for example) I want information returned for Selsey and Selsey Leaf
Hope this makes sense
Gordon
Hi
Do I still create a formula
UpperCase({?myparam}) = uppercase(left({myfield},l
Gordon
Do I still create a formula
UpperCase({?myparam}) = uppercase(left({myfield},l
Gordon
Hi
I tried to add the formula
?myparam guess this is replaced with ?factory being the parameter
Not sure what the other 2 are replaced with?
Gordon
I tried to add the formula
?myparam guess this is replaced with ?factory being the parameter
Not sure what the other 2 are replaced with?
Gordon
Create a parameter with values like London, Selsey, etc.. the use the following record selection criteria:
{table.field} like {?param}
No need to convert to uppercase unless your database doesn't allow for case insensitivity (Oracle, for example) AND you have mixed case data. A "like" isn't particularly efficient, but at least it processes on the databaes, where as an uppercase against a databased field won't be.
~Kurt
{table.field} like {?param}
No need to convert to uppercase unless your database doesn't allow for case insensitivity (Oracle, for example) AND you have mixed case data. A "like" isn't particularly efficient, but at least it processes on the databaes, where as an uppercase against a databased field won't be.
~Kurt
Hi
I found the solution
A simple case of using the slect feature and adding field with starts with and add the ?parameter
It works ok
Gordon
I found the solution
A simple case of using the slect feature and adding field with starts with and add the ?parameter
It works ok
Gordon
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
UpperCase({?myparam}) = uppercase(left({myfield},l