1

كيفية عمل بارميتر لكود الصنف من شاشة المقاسات والالوان؟

مثال اريد انا اقوم بعمل بارميتر يدمج اكواد الصنف مع مقاستة والوانة لهذا الصنف

updated 2018-09-27 11:41:00 +0200
This post is a wiki. Anyone with karma >5 is welcome to improve it.
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

1

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

Ahmed Sayed's avatar
26
Ahmed Sayed
answered 2018-09-27 11:54:20 +0200
Ahmed Qasid's avatar
5.8k
Ahmed Qasid
updated 2018-09-27 12:08:21 +0200
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments

Your Answer

Login/Signup to Answer