Restrict duplicate while select the value for Query

(0) Share

Report

Posted on by MUHAMMAD HAARIS

770

Dear All,

I have added one data source in Query : PayrollStatementGenerationQuery. This is default for Generate pay statement. While i select the record in Query it loaded all the record which filed i gave as range. In table for that field some values are repeated. I want to Restrict duplicate while select the value for Query ?

7220.Doubt.png

Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Iulian Cordobin 8,201 on at

Like (0)

Report
Copy link

Link copied!

This looks strange. Are you sure those are duplicates and not actual records in the Pay Group table, so can you check this?

Was this reply helpful? Yes No
MUHAMMAD HAARIS 770 on at

Like (0)

Report
Copy link

Link copied!

Thanks Iulian.

But actually Pay group id not from Pay Group table.. That is from our new Table.

we related Query Datasource(PayrollStatementGenerationView) with our new Table.. In that table duplicate pay group id is allowed....

How to restrict in mentioned lookup?

Was this reply helpful? Yes No
Mariano Gracia on at

Like (0)

Report
Copy link

Link copied!

You can't do it unless you create a view using your new table and grouping PayGroupId in the view, then you'll need to link the view in the query instead the new table, but then, I don't know if the query will return the results you're expecting.

Was this reply helpful? Yes No
MUHAMMAD HAARIS 770 on at

Like (0)

Report
Copy link

Link copied!

Hi All,

Can anyone solve my above query?

Was this reply helpful? Yes No
Martin Dráb 239,451 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

If you let me select "Pro", how will you whether it means the first Pro record in your table, or the second one, or the third one etc.?

It sounds like a wrong design to me. Either you want to pick a pay group ID, and therefore your lookup should refer to pay group table. Or you want to pick a record from your new table, but pay group ID isn't sufficient for that, because it doesn't uniquely identify records there. You would have to pick the primary key of your table.

Was this reply helpful? Yes No
Iulian Cordobin 8,201 on at

Like (0)

Report
Copy link

Link copied!

Martin's comment is right. Looks like you have an issue with the design (logic) of your query. But in the current scenario, what you are looking for is not possible (displaying Pro only one time).

Was this reply helpful? Yes No