Filter Form Datasource on init

(0) Share

Report

Posted on by Community Member

Hi All,

i customized the table "DimensionAttribute" with a new field (Enum: NoYes).

Now i have a form where i want to display all rows of the table "DimensionAttribute" where the new field has "yes"/1 in a dropdown (referencegroup).

For better understanding here a screenshot:

Then i overwrite the init method on my form, have a look at the left side of the second screenshot.

On the Table "DimensionAttribute" only one row has the value on true, but i get all available DimensionAttributes without any range.

I tried also to filter in the executeQuery method on the datasource, but the same here.

Thanks in advance

James

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Israel Gonzalez 733 on at

Like (0)

Report

Hi James,

The problem is that you have using the FormDataSource.executeQuery() method instead of init() method. Something like this:

public void executeQuery()
{
QueryBuildDataSource qbds;
;

qbds = dimensionAttribute_ds.queryBuildDataSource();

qbds.clearRanges();
qbds.addRange(fieldNum(DimensionAttribute, ownExchangerates)).value(enum2str(NoYes::Yes));

super();
}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Isreal,

thank you for your answer.

As i mentioned above i also tried in executeQuery method.

To be sure i tried your code, but no success.

Here a screenshot:

Was this reply helpful? Yes No
Verified answer

Israel Gonzalez 733 on at

Like (0)

Report

Oh, I see, in that case you should using a lookup() method, in the field called dimension, try this:

public void lookup()
{
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange queryBuildRange;
Query query;
SysTableLookup sysTableLookup;
;

query = new Query();
sysTableLookup = SysTableLookup::newParameters(tableNum(DimensionAttribute), this);

sysTableLookup.addLookupField(fieldNum(DimensionAttribute, FieldYouWantShow));
queryBuildDataSource = query.addDataSource(tableNum(DimensionAttribute));

queryBuildRange = queryBuildDataSource.addRange(fieldNum(DimensionAttribute, ownExchangerates));
queryBuildRange.value(enum2str(NoYes::Yes));

sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();

//super();
}

Note, don't forget coment the super()

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Isreal,

tried your code and on the first look i thought it is the solution.

I open the form and only one dimension, where i set the enum to yes was displayed ("ProjVS").

Now i set the enum to yes by another dimension ("BusModel").

My expectation was, that i have two values to select now.

But the dropdown won't appear any more. I click on the arrow to the bottom, but no dropdown is opening..

Best regards

james

Was this reply helpful? Yes No
Israel Gonzalez 733 on at

Like (0)

Report

James, check the field properties. Is it a StringEdit control?

Was this reply helpful? Yes No
Chaitanya Golla 17,225 on at

Like (0)

Report

Hi,

I am bit confused with your requirement. My understanding is that MDISDimensionExchangeRate is a lookup form and this form is supposed to show only the dimensions with value Yes for the new field ownExchangeRates.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi Israel,

no i used a ReferenceGroup. I changed it to StringEdit control and copy/paste the code for the lookup method. Now it works fine! Thank you very much :)

Was this reply helpful? Yes No
Israel Gonzalez 733 on at

Like (0)

Report

Ok James, don't forget verify the answer :)

Was this reply helpful? Yes No