E9.2 Assign Data Selection to Grid Based on Column Values

[Rana22_]

Hi,

I would like to populate a grid in a Power Edit form from a business view of two tables, but only on the condition of "if Column A != Column B, then write to the grid"
I know the Set Selection function but it only seems to work on hard coded values and not BC values. I have around 10k rows of data in the tables but I only want to display the rows that meet the condition above.
I'm fairly new to developing in FDA so I'm not sure how to make this work.

Thanks,
Monica

 

[Scott Beebe]

Did you try joining those 2 fields in your business view and selecting the not equal (<>) operator. I have never played with <> myself.

 

[Rana22_]

Did you try joining those 2 fields in your business view and selecting the not equal (<>) operator. I have never played with <> myself.

Hi Scott,

I'm using the business view in different forms where I'll need all the data, so I'm hoping to add the logic of <> operator in a form specific grid or something.

So let's say I have a Find/Browse form that displays all the data (the 'before' value in one column, and the 'after' value on the next), and I would like to add a row exit or something with a Power edit form that would show the user the columns that have differences in them.

 

[Scott Beebe]

your options are limited. You can't do what you want with the business you have unless you want to go through all the records and use code to hide the ones you don't want to see. Use differnt business view and see if the <> works, or create a virtual table based on a SQL that does what you want, or write a C function to so the select and store the records in cache to retreive for the grid or put the records in a temp table and have the new form show the records in the temp table.

 

[Kim Schmidt]

Another possibility would be to create a "virtual table" and a corresponding business view. Basically, a virtual table is actually a database view instead of a physical table, where JDE has matching table specs. You can search the JDELIST archives for detailed instructions on how to create one. In your use case, the SQL to create a DB view could be like "CREATE VIEW testdta.F550006 AS SELECT * FROM testdta.F0006 WHERE MCDL01 <> MCDL02" to select business units having differences in those description columns.