Method

(0) Share

Report

Posted on by Community Member

Hi I have a library table, i need to fill the to be return date as maximum date of the books customer subscribed, how can i do that in modified field method..

For example customer subscribed 4 books his return date should be based on the book whose page is maximum.. if it is a small book he can return in 2 weeks and if it is a large book he can take 4 weeks..
Thanks in advance..

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Ajit 8,788 on at

Like (0)

Report
Copy link

Link copied!

Where you are going to put the criteria? I mean, how many pages will take 2 weeks and 4 weeks? You should set the threshold in parameters form for 2 weeks and 4 weeks and based on that you can calculate the return date.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

If the pages of the book is more than 1000 the subscriber can return after 4 weeks, if it is less than 1000 pages the return date would me 2 weeks..

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I already calculated the tobereturndate as follows:

case fieldnum(AX_SubscriberLine,Book_Id):

select axbm where axbm.Book_Id==this.Book_Id;

this.Book_Name=axbm.Book_Name;

if(axbm.Pages>'1000')

this.ToBereturnDate=systemdateget()+28;

else

this.ToBeReturnDate=systemdateget()+14;

break;

Now wat i need to do is if the subscriber subscribed 4 books means he can't come and return each book separately so I need to set the return date for each subscriber as maximum return date automatically from the subscribed book...

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (1)

Report
Copy link

Link copied!
Hi,

There are many ways to accomplish this. One way is to write code on the validateWrite method of table AX_SubscriberLine(i.e when trying to save the customer subscribing book record) to check the books that are already subscribed by the given customer and in that list, if we have at least one book with more than 1000 pages then set the return date for 4 weeks or 2 weeks accordingly.
Typically your code would look like below.

Table: AX_SubscriberLine
Method: ValidateWrite

public boolean validateWrite() { AX_SubscriberLine AX_SubscriberLineLocal; axbm axbm; boolean ret; select firstOnly AX_SubscriberLineLocal where AX_SubscriberLineLocal.CustAccount == this.CustAccount join axbm where axbm.Book_Id == AX_SubscriberLineLocal.Book_Id && axbm.Pages > 1000; if (AX_SubscriberLineLocal.RecId) { this.ToBereturnDate=systemdateget()+28; } else { this.ToBeReturnDate=systemdateget()+14; } ret = super(); return ret; }

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks Chaitu :)

Wat i want is i need to update the tobereturndate as maximum return date of all the subscribed books,

I dont know how to do tat in case, can you suggest me how to do tat??

my sample code is:

case fieldnum(AX_SubscriberLine,ToBereturnDate):

select maxof(tobereturndate) from axsl where axsl.Sub_Id==this.Sub_Id;

// select forupdate axsl where axsl.ToBereturnDate

Was this reply helpful? Yes No