runQueryWithParams

UnionSystems

I am calling AwareApp.runQueryWithParams (queryName, params, renderOption) as follows

AwareApp.runQueryWithParams('Timeline_Person_Attribute',{Object ID: '<<Person.ID>>', Attribute Name: 'Workplace'},{modeless: true, position: {top: 120, left: 100 }})

So
queryName = 'Timeline_Person_Attribute'
params = {ObjectID: '<<Person.ID>>', Attribute Name: 'Workplace'}
renderOption = {modeless: true, position: {top: 120, left: 100 }}

queryName and renderOption are doing what I expect but params is not working.

8.1 User Guide page 444 says

Provide the input values entered by the user in the params hashtable hashed by query parameter name

The query for Timeline_Person_Attribute is

FIND Timeline WHERE Timeline.ObjectName='Person' AND Timeline.ObjectID=?'Object ID' AND Timeline.AttributeName=?'Attribute Name' ORDER BY Timeline.Changed DESC

But when I execute AwareApp.runQueryWithParams as depicted above I get all rows from the Timeline object even Timeline.ObjectName='Person' is ignored. So I think my question is what is the format of the params hashtable and how does it map to the Query?

Jaymer

examine the Server Output/Tomcat Output window(s)

You may see exactly what is being decoded in the param string and it may enlighten you.
jaymer...

PS _ Ahh, if this is on Unix, You don't have the same easy way we have on Windows to see those output panels. They can be extremely useful when an error gets discovered internally, but not enough to warrant an actual Error Dialog box.
For example, a mistyped field name (Lead.Accounttype, should be Lead.AccountType) will be accepted in an HTML box on a form, but at runtime throw an error to the Server Output like "unable to resolve attribute Lead.Accounttype" and all you'll see is the field always showing up empty.) There's a trick to seeing this on Unix and I don't know it.

UnionSystems

Thanks Jaymer,

This is what I see in Tomcat Output. Seems to break down the entire params string into separate characters?

Got XML request <root><query_layout_action query_name='Timeline_Person_Attribute' > 
<prompted_value name="0" >{</prompted_value> 
<prompted_value name="1" >O</prompted_value> 
<prompted_value name="2" >b</prompted_value> 
<prompted_value name="3" >j</prompted_value> 
<prompted_value name="4" >e</prompted_value> 
<prompted_value name="5" >c</prompted_value> 
<prompted_value name="6" >t</prompted_value> 
<prompted_value name="7" >I</prompted_value> 
<prompted_value name="8" >D</prompted_value> 
<prompted_value name="9" >=</prompted_value> 
<prompted_value name="10" >5</prompted_value> 
<prompted_value name="11" >8</prompted_value> 
<prompted_value name="12" >7</prompted_value> 
<prompted_value name="13" >1</prompted_value> 
<prompted_value name="14" >7</prompted_value> 
<prompted_value name="15" >,</prompted_value> 
<prompted_value name="16" > </prompted_value> 
<prompted_value name="17" >A</prompted_value> 
<prompted_value name="18" >t</prompted_value> 
<prompted_value name="19" >t</prompted_value> 
<prompted_value name="20" >r</prompted_value> 
<prompted_value name="21" >i</prompted_value> 
<prompted_value name="22" >b</prompted_value> 
<prompted_value name="23" >u</prompted_value> 
<prompted_value name="24" >t</prompted_value> 
<prompted_value name="25" >e</prompted_value> 
<prompted_value name="26" >N</prompted_value> 
<prompted_value name="27" >a</prompted_value> 
<prompted_value name="28" >m</prompted_value> 
<prompted_value name="29" >e</prompted_value> 
<prompted_value name="30" >=</prompted_value> 
<prompted_value name="31" >W</prompted_value> 
<prompted_value name="32" >o</prompted_value> 
<prompted_value name="33" >r</prompted_value> 
<prompted_value name="34" >k</prompted_value> 
<prompted_value name="35" >p</prompted_value> 
<prompted_value name="36" >l</prompted_value> 
<prompted_value name="37" >a</prompted_value> 
<prompted_value name="38" >c</prompted_value> 
<prompted_value name="39" >e</prompted_value> 
<prompted_value name="40" >}</prompted_value> 
</query_layout_action> 
</root>

There are no errors visible and the query still runs showing all records. Googling Java hashtable suggests a 'hashtable' is like

{5=TUTORIAL, 4=BEST, 3=THE, 2=IS, 1=TP}

So I still think my issue is knowing the correct form for the params hashtable for runQueryWithParams.

Love to see a working example 🙂

Jaymer

Pretty sure you need Server Output, not Tomcat Output.
On windows, they're right next to each other in a pulldown.

Jaymer

ok, turns out I had to do exactly this last night.

I saw YOUR log with this:
<prompted_value name="22" >b</prompted_value>
<prompted_value name="23" >u</prompted_value>
<prompted_value name="24" >t</prompted_value>
<prompted_value name="25" >e</prompted_value>
<prompted_value name="26" >N</prompted_value>
<prompted_value name="27" >a</prompted_value>

At one point I saw similar display of my incorrect input.

If you see that, its not working correctly.

Proper display would be this:

The biggest problem with the questions in the forum (and replies by Support) is that in ALL CASES (that I see), there is only 1 param being passed in.
You need 2.
And you need to know the way java/js wants to see those 2 tuples in an array. (btw, I don't know this answer)
I succeeded in getting this to work with 1 parm passed in (see in pic).
Would take more dicking around to find the "right" way to add 2nd, 3rd parms correctly.
Had someone in the past just posted a clear example of 2 parms, we'd be in the clear.
Hopefully, future searchers won't see YOUR example of 2 parms - you might want to re-edit that original post to emphasize to "DONT DO IT THIS WAY" - LOL

This works for me. (If you tie it to a button, you need this in an onclick statement.)

And the matching Query has this for its Text View:
FIND TwilioMessageLog WHERE TwilioMessageLog.ob_Lead=?'ob Lead' AND TwilioMessageLog.bounceYN='No'

Your original Query:
FIND Timeline WHERE
Timeline.ObjectName='Person' AND
Timeline.ObjectID=?'Object ID' AND
Timeline.AttributeName=?'Attribute Name'
ORDER BY Timeline.Changed

Looking at it here, it might be that your statement should be this:
var params = {};
params ['Object ID'] ='<< Person.ID>>';
params ['Attribute Name'] ='Workplace';
AwareApp.runQueryWithParams ('Timeline_Person_Attribute',params,"{modeless: true, position: {top: 120, left: 100 }}");

EDIT:
Was just looking at Kendo docs... noticed this example:

$("#grid").kendoGrid({
  columns: [
    { selectable: true },
    { field: "name" }
  ],
  dataSource: [ { name: "Jane Doe" }, { name: "John Doe" } ]
});

I know mine works with the "=" as I stated. This doesn't do it that way. dunno. FYI

UnionSystems

Jaymer , I cannot thank you enough for your generous help. Your solutions does work!

I've ended up using a shorter syntax but I'm still defining params in javascript onclick before calling the runQueryWithParams functions.

For the record the final working code is

QUERY ('ObjectID' & 'AttributeName' can be whatever but they must match the values used in the definition of params)

FIND Timeline WHERE Timeline.ObjectName='Person' AND Timeline.ObjectID=?'ObjectID' AND Timeline.AttributeName=?'AttributeName' ORDER BY Timeline.Changed DESC

JAVASCRIPT

var params = {'ObjectID':'<< Person.ID>>', 'AttributeName':'Workplace'}; 
AwareApp.runQueryWithParams('Timeline_Person_Attribute',params,{modeless: true, position: {top: 120, left: 100 }});

BSV DEPLOYMENT (Inserted as text of a form label....users click clock icon to view this attributes history)

Workplace 
<a href="#" onclick="
var params = {'ObjectID':'<< Person.ID>>', 'AttributeName':'Workplace'}; 
AwareApp.runQueryWithParams('Timeline_Person_Attribute',params,{modeless: true, position: {top: 120, left: 100 }});">
<span class="k-sprite fa fa-clock-o"></span>
</a>

Jaymer

This is awesome Dave.
You've cracked the code for sending more than one parameter to a query. Other may have done it, but its finally documented clearly.
Can you wrap this up with a picture of the implementation (and icon) on the form! Thanks again and congrats!

UnionSystems

Images added to my last post.