choices parameter value 2

Use this board to ask questions or have discussions with other Rich Displays users.
Bruno97
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

Post by Bruno97 »

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
Bruno97
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

Post by Bruno97 »

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 ?
Scott Klement
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

Post by Scott Klement »

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.
Bruno97
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

Post by Bruno97 »

It doesn't work Scott.
Scott Klement
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

Post by Scott Klement »

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!
Bruno97
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

Post by Bruno97 »

Here is the file Scott.

Thanks for your help one more time.

Bruno
Attachments
json.txt
(23.61 KiB) Downloaded 361 times
Bruno97
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

Post by Bruno97 »

Hi Scott,

Did you have time to look at my request ?

Bruno
Scott Klement
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

Post by Scott Klement »

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.
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests