Profound Logic Forums

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

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 ?

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.

It doesn't work Scott.

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!

Here is the file Scott.

Thanks for your help one more time.

Bruno

Hi Scott,

Did you have time to look at my request ?

Bruno

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.