Listview xpath is not working.

0
Hi all,   I am having the workorder and wageregister table. they are associated    In the screen I am selecting the workorder and giving the date for wage register   in the list view, I am using the following xpath.  [month-from-dateTime(Month) = month-from-dateTime($dataView4/Month) and year-from-dateTime(Month) = year-from-dateTime($dataView4/Month)andCMS.WageRegister_Workorder = $workorder_dataview]   Unfortunately, It is not retrieving the records.    What could be the problem ?   Regards Sudhir  
asked
4 answers
7

Hello Sudhir,

In your xpath you have used month-from-dateTime ,Year-from-dateTime.

First check your list view without date xpath filter if that work then add date filter.

make sure the month attribute is DateTime type, check the workoder association is properly setup,verify that there is actually records that should match your criteria.

answered
0

Hi Sudhir,

 

In this type of filtering, I think listing with Microflow gives better performance. and you have more options to manage filters. You can also optimize and test your filtering better by using other functions with variables. You have the opportunity to see every step.

answered
0

Hi Raju,

 

Yes. issue with month-from-datetime  and year-from-datetime

 

How to fix this ?

 

Regards

Sudhir

 

answered
0

Hi Raju,

 

I have figgered-it out. the problem is with field 'Month'. which is available in 2 tables. 

So , I have to write

month-from-dateTime($currentObject/Month) = month-from-dateTime($dataView4/Month) 

 

now it works.

 

Thanks for your co-operation

 

Regards

Sudhir

answered