Revision history [back]

Revision 3

updated 2018-09-27 12:08:21 +0200

Create parameter and add property suggestionquery
Value should be:

select distinct top 75   s.code,s.name1,s.name2 from SizesAndColors s left join InvItem i on i.id = s.invItem_id where i.code  = {FromSubCode} and (s.code like '%'+{sizeandcolor}+'%' or s.name1 like '%'+{sizeandcolor}+'%'  or s.name2 like '%'+{sizeandcolor}+'%' )

image description

Revision 2

Ahmed Sayed

updated 2018-09-27 12:04:20 +0200

~~Create parameter and add property suggestionquery~~1- parmater (property code)=(suggestionquery)
Value should be:

select 2- value ``select distinct top 75 s.code,s.name1,s.name2 from SizesAndColors s left join InvItem i on i.id = s.invItem_id where i.code = {FromSubCode} and (s.code like '%'+{sizeandcolor}+'%' or s.name1 like '%'+{sizeandcolor}+'%' or s.name2 like '%'+{sizeandcolor}+'%' )
)

Revision 1

Ahmed Sayed

answered 2018-09-27 11:54:20 +0200

1- parmater (property code)=(suggestionquery)
2- value ``select distinct top 75 s.code,s.name1,s.name2 from SizesAndColors s left join InvItem i on i.id = s.invItem_id where i.code = {FromSubCode} and (s.code like '%'+{sizeandcolor}+'%' or s.name1 like '%'+{sizeandcolor}+'%' or s.name2 like '%'+{sizeandcolor}+'%' )