It more than helped me Scott !
Thanks a ton for that. I really love the auto-complete thing...
And sorry for my lack of knowledge, I am kind of a newbie to all this. ;)
Bruno
choices parameter value 2
-
- Profound User
- Posts: 61
- Joined: Wed Jul 16, 2014 8:35 am
- First Name: BRUNO
- Last Name: HAJJAR
- Company Name: APLUS INFORMATIQUE
- Phone: 0664771058
- Address 1: 9 AVENUE HENRI MATISSE
- Address 2: IMMEUBLE MATISSE
- City: NICE
- Zip / Postal Code: 06200
- Country: France
- Contact:
-
- Profound User
- Posts: 61
- Joined: Wed Jul 16, 2014 8:35 am
- First Name: BRUNO
- Last Name: HAJJAR
- Company Name: APLUS INFORMATIQUE
- Phone: 0664771058
- Address 1: 9 AVENUE HENRI MATISSE
- Address 2: IMMEUBLE MATISSE
- City: NICE
- Zip / Postal Code: 06200
- Country: France
- Contact:
Re: choices parameter value 2
Hi Scott,
One more thing please...
I have noticed that if a parameter (the ? in the choices selection criteria) is blank, the auto-complete query will not work.
Is it normal ?
I mean, sometimes you may want to select something where in the query, a variable=' '.
Do you know a workaround ?
One more thing please...
I have noticed that if a parameter (the ? in the choices selection criteria) is blank, the auto-complete query will not work.
Is it normal ?
I mean, sometimes you may want to select something where in the query, a variable=' '.
Do you know a workaround ?
-
- 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: choices parameter value 2
The get() (or pui.get()) routine in Profound UI automatically trims blanks from the data. So if you have a field that consists of one blank, and you then use script: get("id") to retrieve it, it'll return an empty string (one without any blanks at all.) It could be that SQL is making a distinction between an empty string and a blank, and that is throwing off your SQL statement.
We do have another API called getElementValue() that works the same way as get(), but does not strip the blanks.
I haven't heard any problems reported with this before -- but this may simply be something that nobody has tried yet. So... can you try coding script: getElementValue("your-id") rather than script: get("your-id")? Tell me if that makes any difference?
If not, let me know, and we'll see if we can reproduce the problem here so we can troubleshoot it.
We do have another API called getElementValue() that works the same way as get(), but does not strip the blanks.
I haven't heard any problems reported with this before -- but this may simply be something that nobody has tried yet. So... can you try coding script: getElementValue("your-id") rather than script: get("your-id")? Tell me if that makes any difference?
If not, let me know, and we'll see if we can reproduce the problem here so we can troubleshoot it.
-
- Profound User
- Posts: 61
- Joined: Wed Jul 16, 2014 8:35 am
- First Name: BRUNO
- Last Name: HAJJAR
- Company Name: APLUS INFORMATIQUE
- Phone: 0664771058
- Address 1: 9 AVENUE HENRI MATISSE
- Address 2: IMMEUBLE MATISSE
- City: NICE
- Zip / Postal Code: 06200
- Country: France
- Contact:
Re: choices parameter value 2
It doesn't work Scott.
-
- 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: choices parameter value 2
To assist me, can you create a JSON screen dump of your screen? You can do that by navigating to the screen where the SQL is not working and pressing Ctrl-F9. This will ask you to download a file named "json.txt".
Can you post that file here? Or e-mail it to support@profoundlogic.com?
With that, I will be able to bring up your screen on my development box, and I can try to troubleshoot the problem.
Thanks!
Can you post that file here? Or e-mail it to support@profoundlogic.com?
With that, I will be able to bring up your screen on my development box, and I can try to troubleshoot the problem.
Thanks!
-
- Profound User
- Posts: 61
- Joined: Wed Jul 16, 2014 8:35 am
- First Name: BRUNO
- Last Name: HAJJAR
- Company Name: APLUS INFORMATIQUE
- Phone: 0664771058
- Address 1: 9 AVENUE HENRI MATISSE
- Address 2: IMMEUBLE MATISSE
- City: NICE
- Zip / Postal Code: 06200
- Country: France
- Contact:
Re: choices parameter value 2
Here is the file Scott.
Thanks for your help one more time.
Bruno
Thanks for your help one more time.
Bruno
- Attachments
-
- json.txt
- (23.61 KiB) Downloaded 361 times
-
- Profound User
- Posts: 61
- Joined: Wed Jul 16, 2014 8:35 am
- First Name: BRUNO
- Last Name: HAJJAR
- Company Name: APLUS INFORMATIQUE
- Phone: 0664771058
- Address 1: 9 AVENUE HENRI MATISSE
- Address 2: IMMEUBLE MATISSE
- City: NICE
- Zip / Postal Code: 06200
- Country: France
- Contact:
Re: choices parameter value 2
Hi Scott,
Did you have time to look at my request ?
Bruno
Did you have time to look at my request ?
Bruno
-
- 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: choices parameter value 2
I looked at it, unfortunately, it wasn't clear what the problem was. (Since the files don't exist on my system, I cannot test it directly.)
I need to write a test program to see if I can reproduce the problem -- and I haven't had time to do that yet.
I need to write a test program to see if I can reproduce the problem -- and I haven't had time to do that yet.
Who is online
Users browsing this forum: No registered users and 0 guests