choices parameter value 2

[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]

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]

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]

It doesn't work Scott.

[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]

Here is the file Scott.

Thanks for your help one more time.

Bruno

[Bruno97]

Hi Scott,

Did you have time to look at my request ?

Bruno

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