Skip to Content (Press Enter)
UserImage.jpg
ragul sp
589Views
5Comments
Solved
Displaying record in dropdown list whose boolean value is true
Question

Hi All,

         I am a beginner so I will try to be clear with my question.

         I have a master named "Status" in which i get two values from the user. One is the status(like Completed, Inprogress etc) and the other is a boolean value named IsActive. I have linked it with a detail called tracker. So when I click on the dropdown I need to get the values only which have been marked as true in their IsActive value.Can you please tell me how to do that?Thanks

0
0
09 Jan 2018
Copy Link
2025-04-22 05-54-18
Shashi Kant Shukla
Solution

Hi Ragul,

As per my understanding you are having a Static table like Status and Table holding data like Pending, Completed,In-progress out of three status IsActive property of Pending is False then you want to populate only Completed,In-progress in dropdown.

Then you need aggregate like GetStatus filter Status.IsActive=True and you need to bind dropdown with same aggregate




Regards

-SK-

See solution in context
1
0
10 Jan 2018
Copy Link
UserImage.jpg
ragul sp

Shashi kant Shukla wrote:

Hi Ragul,

As per my understanding you are having a Static table like Status and Table holding data like Pending, Completed,In-progress out of three status IsActive property of Pending is False then you want to populate only Completed,In-progress in dropdown.

Then you need aggregate like GetStatus filter Status.IsActive=True and you need to bind dropdown with same aggregate




Regards

-SK-

Hi Shashi kant Shukla,

                                    Thanks a lot it helped.


0
0
10 Jan 2018
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

Hi Ragul,

I'm not sure what you mean with "master". And how does the user supply these values? Are they in a database? Do you have an Aggregate to query them? What do you have as input to the Combobox?

0
1
10 Jan 2018
Copy Link
UserImage.jpg
ragul sp

Kilian Hekhuis wrote:

Hi Ragul,

I'm not sure what you mean with "master". And how does the user supply these values? Are they in a database? Do you have an Aggregate to query them? What do you have as input to the Combobox?

Hi Kilian Hekhuis,

Sorry for being unclear.Next time I will try to be more accurate with my question


0
0
10 Jan 2018
Copy Link
2025-04-22 05-54-18
Shashi Kant Shukla
Solution

Hi Ragul,

As per my understanding you are having a Static table like Status and Table holding data like Pending, Completed,In-progress out of three status IsActive property of Pending is False then you want to populate only Completed,In-progress in dropdown.

Then you need aggregate like GetStatus filter Status.IsActive=True and you need to bind dropdown with same aggregate




Regards

-SK-

1
0
10 Jan 2018
Copy Link
UserImage.jpg
ragul sp

Shashi kant Shukla wrote:

Hi Ragul,

As per my understanding you are having a Static table like Status and Table holding data like Pending, Completed,In-progress out of three status IsActive property of Pending is False then you want to populate only Completed,In-progress in dropdown.

Then you need aggregate like GetStatus filter Status.IsActive=True and you need to bind dropdown with same aggregate




Regards

-SK-

Hi Shashi kant Shukla,

                                    Thanks a lot it helped.


0
0
10 Jan 2018
Copy Link
2025-04-22 05-54-18
Shashi Kant Shukla

Welcome Ragul !!

Regards

-SK-

1
0
10 Jan 2018
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.