BDOC query parameter

[Former Member]

Hi all,

I have a Bdoc parameter syntax related question.

I want to set a query bdoc parameter as below where TERRID is a parameter and

i want to pass sql like ...

****SQL****

WHERE TABLE1.NTERRID LIKE 'TERRID%'

***BDOC QUERY***

WHERE TABLE1.NTERRID LIKE :TERRID

Now when this BDOC query is actually executes it puts % in front as well sql looks like below

WHERE TABLE1.NTERRID LIKE '%TERRID%'

how do i change my boc query parameter syntax to have % only at the end of the parameter and not in front.

Thanks in advance

Hetal

[Former Member · Accepted solution]

Hi,

the generated SQL statement in a where clause is based on the match type of the related property of the Business Query object.

In your example it should be <MatchAdvanced> or <MatchAtBegin>.

Regards,

Wolfhard

[Former Member · Accepted solution]

Thank you Wolfhard for your quick reply as always.

where do i do this <MatchAdvanced> or <MatchAtBegin>? in CRM BDOC level or in BOL layer in MAS?

Thanks

Hetal

[Former Member · Accepted solution]

Hi,

the Business Query objects you can find in the BOL layer in the Dev studio.

But you have to know which is the right one...;-))

Regards,

Wolfhard

[Former Member · Accepted solution]

Thanks Wolfhard

Its already MATCHADVANCED so i guess i will have to change to <MatchAtEnd> since i want "TERRID%'

could you tell me what <Match Empty> and <MatchSubString> means?

Thanks,

Hetal

[Former Member · Accepted solution]

Hi,

no, I guess in your example you would need MatchAtBegin rather than MatchAtEnd. But normally MatchAdvanced is used. You need to try anyway...

MatchEmpty looks like the possibility to search for empty content explicitely, but I never have seen this somewhere...

Regards,

Wolfhard

[Former Member · Accepted solution]

thanks a lot!!!