Buy Now
Sign in

reletionship take excluded data

S
samir1903 175
April 25 2019, 17:13 #386302
I have releted two different table based on their codes
first table where the people
second table the statue
i want to list to dropdown table People but their status does not exist yet.
So i can distunguish if their sttus is not entered yet i can add a status
im doing currently
in people module
Status.job != "Yes"
It takes whatever tehere is in status table no
but i want people from people table but their status does not exist
i do this doesnt work
Status.job:People.status
because status doesnt exist in people table it gives error
healyhatman 6
April 25 2019, 21:56 #386306
where FIELD IS NULL
Web developer at SkySpider.com.au
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
S
samir1903 175
April 25 2019, 23:06 #386307
it is not clear for me
there is two table
People and status
people table has names and id nos of people it doesn have any column with status
status has column of peopleid
this peopleid of status is connected to id of people table
i am on db read where there is people model is related to status model with code number
when i say read yes on where condition
it takes one record
when i say read no on where condition
it takes one records
when i say non of the like null or nothing it takes zero records
because reads from status table record
but i want to read from people table records where there is no records of status table job position
healyhatman 6
April 26 2019, 00:00 #386309
Sorry, I meant where
table2.foreignkeyfield IS NULL
Web developer at SkySpider.com.au
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
S
samir1903 175
April 26 2019, 02:02 #386310
it gives zero records
because there is only two records registered in table 2
when you exclude them zero
however registered list is in table 1
i want names from table1 exluded records of table1
healyhatman 6
April 26 2019, 05:44 #386313
You want all records that DONT have an entry in the othet table then use the thing i said. Works for me. If it doesnt work for you post screenshots of your read data setup
Web developer at SkySpider.com.au
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
S
samir1903 175
April 26 2019, 11:23 #386317
2919A707-C60B-4A0A-9DAA-39F34CBE55DE.png25EF0F8C-B9F0-41F9-88C1-BAB2108E6816.png1EF7C6FC-A407-44B3-B394-BDB7885BEEF5.png0CE7C97A-5602-41DD-A796-B059C56B044F.png
Attachments
E578CDC9-083D-4611-98AC-4DB416749CF8.png
E578CDC9-083D-4611-98AC-4DB416749CF8.png
(77.32 KiB)
30 Downloads/Views
0CE7C97A-5602-41DD-A796-B059C56B044F.png
0CE7C97A-5602-41DD-A796-B059C56B044F.png
(105.28 KiB)
37 Downloads/Views
1EF7C6FC-A407-44B3-B394-BDB7885BEEF5.png
1EF7C6FC-A407-44B3-B394-BDB7885BEEF5.png
(107.41 KiB)
36 Downloads/Views
25EF0F8C-B9F0-41F9-88C1-BAB2108E6816.png
25EF0F8C-B9F0-41F9-88C1-BAB2108E6816.png
(84.42 KiB)
37 Downloads/Views
2919A707-C60B-4A0A-9DAA-39F34CBE55DE.png
2919A707-C60B-4A0A-9DAA-39F34CBE55DE.png
(88.31 KiB)
37 Downloads/Views