Click here to Skip to main content
15,117,830 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi can any one please help me in writing a method inside the query for the following criteria.

Method name: GetFamilyByModelCCC
Parameter: string lineNo
Return Type: string
Attribute: [MapperFunction(Constants.AppID.ALL,GetFamilyByModelCCC]
Logic:
* Get value from MODELCCC@LU_INV_LOC. Criteria: TESTER_ID = lineNo
* Get value from PRODUCT_FAMILY@LU_FAMILY.
Criteria:
If length of MODELCCC value <= 3, criteria: CACHE_FAMILY = MODELCCC.
If length of MODELCCC value > 3, criteria: CACHE_FAMILY = [cache family value from ModelCCC]
Example of MODELCCC value:
- A1Y -> <= 3; cache family=A1Y
- WD9001BKHG-12D22V1 --> length>3; cache family=D22
- WD5000AAKX-083CA1 -->length > 3; cache family=3C


relation to the above tables is: cachefamily@lu_family refers to modelccc@lu_inv_loc
Posted
Updated 15-Jul-13 22:22pm
v2
Comments
Sudhakar Shinde 16-Jul-13 2:37am
   
You have logic and everything with you and still you are asking us to write code for you?You have to write it on your own and post queries/difficulties you are facing.
OriginalGriff 16-Jul-13 2:38am
   
What have you tried? Where are you stucK?
Maciej Los 16-Jul-13 3:10am
   
What are relationships between tables?
Share with example data. Use "Improve question" widget!
KPrao82 16-Jul-13 3:41am
   
the relation is : the value of CACHE_FAMILY@lu_FAMILY get from

MODELCCC@LU_INV_LOC ..
USERID IS THE COMMONFIELD
Maciej Los 16-Jul-13 3:41am
   
Still nothing useful ;(
If you want our help, you need to be more specific and need to provide more details...

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900