Filtering records based on availability

[Deepak Kumar]

Hi all,

 

I need to filter records based on Product availability.

 

I have a table, Products. There are thousands of records, each having different product code in it.

Also, I have a table, Project. When i create a project & i use different products in it.

 

Suppose I created a Project ABC for the duration 10/6/2013 to 15/6/2013. Between these duration, I will get a list of available products during these period. and from that i will choose the product which i require.  i choose a Product X for this duration.

 

Again, when i create a Project XYZ for the duration 12/6/2013 to 14/6/2013. Product X should not be available in the list.

 

Please, give a logic or example file to solve this out.

 

Thanks.

[Manjit Behera]

Hi,

Looking into your requirement I am thinking that you are want a to setup rental type functionality in your project section. For this you can use many ways but if you want to solve this in a simple way here is a file which can give you a solution I have attached  for the same. Here its just checking the availability of product in the date range slot from its occupier and showing available products. Go through it and let me know if you will need any help there.

 

If you are using FM12 then you can also use the Execute SQL function to find out the available products for the date range slot but that need some complex select query :-)

 

 

 

with regards,

 

Project.zip

[Deepak Kumar]

Hi Manjit,

 

Thanks for the reply.

 

I have attached the file actually what i need and mentioned the details. If you can look at it , it will very helpful for me.

 

Thanks.

 

Deepak

 

 

Projects.zip

[bruceR]

You have not supplied enough information for anybody to give you an answer.

 

Are there multiple time slots per project?

 

That would suggest that there might be a project time slot table; with projectID; start; and end.

 

What does it mean for a product to be available? Can a product have multiple time slots?

 

If a product is used in one project time slot, is it still available for use in other projects for that time slot?

[Manjit Behera]

Hi Deepak,

 

Please the updated file which can fit to your requirements.

 

 

 

with regards,

Manjit

ProjectV2.zip