ValidTimeStateFieldType in a table

(0) Share

Report

Posted on by Danial47

142

HI all,

In my salesorderlistpage form, all records do not display in the grid because of the date effective table of logisticspostal address.

When I update validto field from the database, I can see the records in the grid.

So what should I do to display all records in the grid?

Thanks.

I have the same question (0)

All responses (11)

Answers (1)

Sort by

Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Hi Danial,

I assume you have a customization in SalestableListPage form to display address fields. Please try setting these properties on the LogisticsPostalAddress data source and check if you can see all records.

Was this reply helpful? Yes No
Danial47 142 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your reply, but I try it before, and does not work!!!

I have many sales orders which not show in the grid.

BR.

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

What is the join mode between SalesTable and LogisticsPostalAddress?

Was this reply helpful? Yes No
Danial47 142 on at

Like (0)

Report
Copy link

Link copied!

it is a default join of ax form, not customized.

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Hi Danial,

Sales order list page by default does not have LogisticsPostalAddress as a data source. I believe there is some customization don here.

Was this reply helpful? Yes No
Danial47 142 on at

Like (0)

Report
Copy link

Link copied!

join mode is innerjoin and fetchmod : 1:1

anyway, i do not see any customization in CUS or USR layer.

thanks.

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Hi Danial,

Please go to Tools > Options > Development and turn on "Show all layers" for Application object layer. Please share a screenshot of the object so that we can see in which layers it is modified.

You can also try setting the join mode to Outer join and check if you can see all the sales order records.

Was this reply helpful? Yes No
Danial47 142 on at

Like (0)

Report
Copy link

Link copied!

Hi Gunjan,

I can not change the join type.

Thanks

Was this reply helpful? Yes No
Danial47 142 on at

Like (0)

Report
Copy link

Link copied!

When I set ValidTimeStateAutoQuery of salestable to daterange, my grid does not return any records!!

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,423 on at

Like (1)

Report
Copy link

Link copied!

Hi Danial,

The join type needs to be changed from the underlying query. Please go to AOT > Queries > SalesTableListPage and change the join type.

As for the ValidTimeStateAutoQuery property, please leave it as "AsOfDate" (the default value) for now and try again.

Was this reply helpful? Yes No