Hi
You can try this by following
<property expression=“//qu:user/qu:query/text()" name="queryString"/>
<salesforce.query>
<batchSize>1</batchSize>
<queryString>$ctx: queryString}</queryString>
</salesforce.query>
Thanks.
On Fri, Aug 21, 2015 at 9:45 AM, Shakila Sivagnanarajah <[email protected]>
wrote:
> Hi Bhathiya,
>
> From my knowledge, creating my query with a dynamic value using property
> is the best way rather setting the value for queryString directly. If we
> do like this, that value will be set to message context.
>
> Thank you
>
> On Fri, Aug 21, 2015 at 9:42 AM, Shakila Sivagnanarajah <[email protected]>
> wrote:
>
>> Hi Bhathiya,
>>
>> From my knowledge, creating my query with a dynamic value is the best
>> way. If we do like this, that value will be set to message context.
>>
>> Thank you
>>
>>
>> On Fri, Aug 21, 2015 at 5:26 AM, Bhathiya Jayasekara <[email protected]>
>> wrote:
>>
>>> Hi all,
>>>
>>> I want to execute $subject. I could achieved it like below, but I
>>> believe there must be a better way.
>>>
>>> <property name="UserQuery" value="Select a.name, a.age From Users a where
>>> name='"/>
>>> <property name="Username" value="newuser"/>
>>> <property name="Apostrophe" value="'"/>
>>> <property name="CompleteUserQuery"
>>> expression="fn:concat(get-property('UserQuery'), get-property('Username'),
>>> get-property('Apostrophe'))"/>
>>>
>>>
>>> <payloadFactory media-type="xml">
>>> <format>
>>> <qu:user xmlns:qu="user.com">
>>> <qu:query>$1</qu:query>
>>> </qu:user>
>>> </format>
>>> <args>
>>> <arg evaluator="xml"
>>> expression="get-property('CompleteActivityQuery')"/>
>>> </args>
>>> </payloadFactory>
>>>
>>>
>>> <salesforce.query>
>>> <batchSize>1</batchSize>
>>> <queryString
>>> xmlns:qu="user.com">{//qu:user/qu:query/text()}</queryString>
>>> </salesforce.query>
>>>
>>>
>>> I'd like to know 2 things. what is the best way,
>>>
>>> 1) to create my query with a dynamic value (i.e. property)?
>>> 2) to set a property value to queryString?
>>>
>>> Thanks,
>>>
>>> --
>>> *Bhathiya Jayasekara*
>>> *Senior Software Engineer,*
>>> *WSO2 inc., http://wso2.com <http://wso2.com>*
>>>
>>> *Phone: +94715478185 <%2B94715478185>*
>>> *LinkedIn: http://www.linkedin.com/in/bhathiyaj
>>> <http://www.linkedin.com/in/bhathiyaj>*
>>> *Twitter: https://twitter.com/bhathiyax <https://twitter.com/bhathiyax>*
>>> *Blog: http://movingaheadblog.blogspot.com
>>> <http://movingaheadblog.blogspot.com/>*
>>>
>>> _______________________________________________
>>> Dev mailing list
>>> [email protected]
>>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>
>>>
>>
>>
>> --
>> Shakila Sivagnanarajah
>> Associate Software Engineer
>> Mobile :+94 (0) 770 760240
>> [email protected]
>>
>
>
>
> --
> Shakila Sivagnanarajah
> Associate Software Engineer
> Mobile :+94 (0) 770 760240
> [email protected]
>
> _______________________________________________
> Dev mailing list
> [email protected]
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>
--
Regards
S.Sriashalya,
WSO2 *Inc*.
lean . enterprise . middleware
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
