in X++ validTimeState query

(0) Share

Report

Posted on by Riyas ahamed F

1,215

Hi, all

public void executeQuery()
{
this.query().dataSourceTable(tableNum(NewTestCase)).clearRanges();

if (StartDate.dateValue())
{
this.query().validTimeStateAsOfDate(StartDate.dateValue());
}
if (LessThan.dateValue())
{
this.query().validTimeStateDateRange(LessThan.dateValue() , StartDate.dateValue());
}
if (greaterThan.dateValue())
{
this.query().validTimeStateDateRange(greaterThan.dateValue(), StartDate.dateValue());
}
if (greaterThanEqual.dateValue())
{
this.query().validTimeStateAsOfDate(greaterThanEqual.dateValue()-1);
}
if (lessthanEqual.dateValue())
{
this.query().validTimeStateAsOfDate(lessThanEqual.dateValue()+1);
}
super();

// i am working on inquiry form now i want to how to do it in the ValidTimeState
// aslo how to clear in the grid validTimeState
// 1. start date only working on it.
//2. secound i need a <
// 3. three i need a >
// 4. four i nedd a <=
// 5. five i need a >=
// in x++ how to do it ValidTimestate

thanks

I have the same question (0)

All responses (8)

Answers (2)

Verified answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Riyas,

What kind of issue you have?

For eqality case you need to use validTimeStateAsOfDate and in other cases validTimeStateDateRange.

So I think in your case it should be like

1. this.query().validTimeStateAsOfDate(StartDate.dateValue());

2. this.query().validTimeStateDateRange(dateNull() , StartDate.dateValue() - 1);

3. this.query().validTimeStateDateRange(StartDate.dateValue() + 1, datemax());

4. this.query().validTimeStateDateRange(dateNull() , StartDate.dateValue());

5. this.query().validTimeStateDateRange(StartDate.dateValue(), datemax());

Was this reply helpful? Yes No
Riyas ahamed F 1,215 on at

Like (0)

Report

Many thanks sergei sir now working fine

but how to clear in the grid normal clearranges not working validTimeState

thanks

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (1)

Report

Hi Riyas,

Do you want clear validTimeState parameters? Or do you want to clear ranges?

Was this reply helpful? Yes No
Riyas ahamed F 1,215 on at

Like (0)

Report

Now , once I set to datevalue it is record filtered but remove the data grid is filtered only show not able to clear data how to clear range set to validTimeState

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi,

Default state is this.query().validTimeStateAsOfDate(systemdateget());

Was this reply helpful? Yes No
Riyas ahamed F 1,215 on at

Like (0)

Report

Hi, sir

I don't want systemgetDate

Now, I want to how to clear data in the grid also usually addrange we can use clear ranges datasoure but, my question

In validTimeState how to set clear so that what to be done.

Was this reply helpful? Yes No
Verified answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Riyas,

There is no clear option for ValidTimeState. The default state is for today. If you want to see all records without limitation you need to use validTimeStateDateRange(dateNull(), dateMax());

Was this reply helpful? Yes No
Riyas ahamed F 1,215 on at

Like (0)

Report

Thanks for your valuable answer sir.

Was this reply helpful? Yes No

Join the conversation

Community site session details

in X++ validTimeState query

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

in X++ validTimeState query

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates