How do I get the value of the filter code 2 from the WHSInventTable?

(0) Share

Report

Posted on by Marvin Richter

Hey,

i want to get the filter code 2 from a specific dataset of the EcoResProductDetailsExtended.

It should look like this example:

public Str getFilterCode2()

{

               Select firstonly RecId from whsInventTable

                    where  [….];

               return whsInventTable.FilterCode[2] // This obviously doesn't work :D

}

Unfortunately the WHSInventTable works like this:

- WHSInventTable only stores the column FilterCode (not FilterCode1,2,3,…)

- The DataField Property of the form access the value of the WhsInventTable with „FilterCode[2“

All responses (6)

Answers (1)

Marvin Richter 50 on at

Like (1)

Report

RE: How do I get the value of the filter code 2 from the WHSInventTable?

There just was a missing "="

That's exactly why I looove to switch between "normal" SQL statements and the x++ SQL statements at work (not) :D

Thanks a lot for your help!
Mohit Rampal 12,558 Moderator on at

Like (0)

Report

RE: How do I get the value of the filter code 2 from the WHSInventTable?

May I know on which table/class are you creating this method. What 'this' denotes in this.ItemId

Instead of this.ItemId = whsInventTable.ItemId please try whsInventTable.ItemId = this.ItemId. If still get same error then you need to create either join or create ItemId variable, map this.ItemId to variable and pass the variable in select statement.
Marvin Richter 50 on at

Like (0)

Report
RE: How do I get the value of the filter code 2 from the WHSInventTable?

Thanks for the fast answers, but i still have an error at the build. It says "Join expected" right before the "[".

This leads me to believe that x doesn't know this syntax.

To make sure I didn't copy anything wrong, here is the full code:

public Str getFilterCode2() { WHSInventTable whsInventTable; Select firstonly FilterCode[2] from whsInventTable where this.ItemId = whsInventTable.ItemId; return whsInventTable.FilterCode[2]; }
Suggested answer

Mohit Rampal 12,558 Moderator on at

Like (0)

Report

RE: How do I get the value of the filter code 2 from the WHSInventTable?

This is an array field, so at Table level you will see only FIlterCode but it has array elements. Please check WHSFilterCode EDT. I have tried the code and it works. Please test and let me know if any issues.
Marvin Richter 50 on at

Like (0)

Report

RE: How do I get the value of the filter code 2 from the WHSInventTable?

I guess I didn't express myself correctly. Yes, that would certainly be correct if the column existed on the table, but unfortunately it doesn't. Unfortunately, I don't know how the data model works here. Because: FilterCode exists, FilterCode[2], [3] etc. does not. Unfortunately, your statement would lead to the error that no string array can be made from a string because it only knows FilterCode as a column. The image below explains the structure of the WHSInventTable.
Verified answer

Mohit Rampal 12,558 Moderator on at

Like (1)

Report
RE: How do I get the value of the filter code 2 from the WHSInventTable?

Hi Marvin, If you check WHSInventTable in SQL Server, you will the value is saved per FilterCode field in a record, such as value in FilterCode2, FilterCode3 etc.

Your select statement is incorrect as you are selecting only RecId from WHSInventTable and returning FilterCode[2. If you want, you can select FilterCode[2 and return it as below.

public Str getFilterCode2() { WHSInventTable whsInventTable;\ Select firstonly FilterCode[2] from whsInventTable where [….]; return whsInventTable.FilterCode[2]; }